Senior Informatica ETL & Snowflake Data Engineer
Kasmo· enterprise· Information Technology And Services· Jul 21, 2026 · 3mo agoPosted 98 days ago
Fort Mill, SC
Remote
Full-time
Senior
$120K–$176K est.
Before you apply
Ghost Signal:
Open since July 21, 2026 — 98 days, and still accepting applications.
Job description
Job Title: Senior Informatica ETL & Snowflake Data Engineer
Client: Princess Cruises
Location: Remote (EST/CST only)
Duration: 6+ Months Contract
Required Experience (must)
• 8+ years of Data Engineering/ETL experience.
• Recent 4+ years of hands-on experience with Python, APIs, AWS, Snowflake, and Informatica Cloud Services (IICS/ICS).
Key Responsibilities
• Design, develop, and optimize scalable ETL/ELT data pipelines.
• Migrate and integrate enterprise data from Oracle to Snowflake.
• Build automated API ingestion frameworks using Python and AWS services.
• Develop high-performance Snowflake data models and optimize warehouse performance.
• Collaborate with business and technical teams to deliver reliable cloud-based data solutions.
Required Technical Skills
Snowflake
• Strong understanding of Snowflake architecture and best practices.
• Experience with Dynamic Tables, Tasks, Streams , and Snowflake Warehouses.
• Advanced SQL development and query optimization.
• Performance tuning, troubleshooting, and warehouse optimization.
• Designing scalable Snowflake data models.
Oracle
• Strong SQL and PL/SQL development experience.
• Experience migrating data from Oracle to Snowflake.
• Knowledge of Oracle performance tuning, backup, and optimization.
Python
• Develop Python scripts for cloud-based data processing.
• Build reusable, modular, and object-oriented code.
• Automate API integrations and data ingestion workflows.
• Experience with AWS Lambda for serverless processing.
API Integration
• Build ETL/ELT pipelines using REST APIs.
• Process JSON/XML payloads into structured datasets (CSV, Parquet, Database tables).
• Secure authentication using OAuth2, JWT, and API Keys.
AWS
• Hands-on experience with S3, EC2, DMS , and related AWS services.
• Build and orchestrate cloud-based data pipelines.
• Experience with serverless data integration solutions.
Data Analysis & Modeling
• Analyze large datasets using SQL and Python.
• Strong understanding of ER Models, Star Schema, and Snowflake Schema .
• Design scalable, maintainable enterprise data models.
ETL Tools (Required)
• Informatica Intelligent Cloud Services (IICS/ICS)
• Design and develop ETL workflows integrating Oracle, Snowflake, and AWS.
Nice to Have
• MuleSoft
• API-led integrations between Snowflake, Oracle, and AWS.
• Experience building enterprise integration workflows using MuleSoft APIs.
Must-Have Skills
• Snowflake
• Informatica IICS / ICS
• Oracle
• Python
• AWS (S3, EC2, DMS, Lambda)
• REST APIs
• SQL / PL-SQL
• ETL / ELT
• Data Modeling
• Performance Tuning
Priority: Candidates must have recent hands-on experience (4+ years) with Python, AWS, Snowflake, APIs, and Informatica IICS/ICS in their latest projects.
Application prep
Use the role’s language and application details while tailoring your materials.
Keywords to mirror
pythonawsapisqlrest
- Platform
- jobdiva
- Effort
- medium