Senior Informatica ETL & Snowflake Data Engineer

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.