Sign upLog in

Senior Informatica ETL & Snowflake Data Engineer

Kasmo Inc

Fort Mill, SC(remote)

Apply
JOB DETAILS
SKILLS
AWS Lambda, Amazon Elastic Compute Cloud (EC2), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Application Programming Interface (API), Authentication, Best Practices, Cloud Computing, Data Management, Data Migration, Data Modeling, Data Processing, Data Sets, Database Extract Transform and Load (ETL), Database Technology, Enterprise Data Integration, Entity Relational (ER) Modeling, Identify Issues, Informatica, JSON, OAuth, Object Oriented (OO), Oracle, Oracle PL-SQL, Performance Modeling, Performance Tuning/Optimization, Python Programming/Scripting Language, Query Optimization, REST (Representational State Transfer), SQL (Structured Query Language), Scalable System Development, Scripting (Scripting Languages), Snowflake Schema, Star Schema, Technical Delivery, Warehousing, Wheel/Front-End Loader, XML (EXtensible Markup Language)
LOCATION
Fort Mill, SC
POSTED
3 days ago

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.

About the Company

K

Kasmo Inc