Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior Informatica ETL & Snowflake Data Engineer

Kasmo Inc

Job Description

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.

Vacancy posted 20 days ago
Similar jobs that could be interesting for youBased on the Senior Informatica ETL & Snowflake Data Engineer in Fort Mill, York County, SC vacancy
  •  ...experienced Developer based in South Carolina to design, implement, and optimize data engineering solutions. With over 10 years of IT experience, the ideal candidate will have deep expertise in Snowflake and cloud platforms including AWS and Azure. This role involves leading... 
    Senior

    Capgemini

    Fort Mill, York County, SC
    4 days ago
  •  ...Role: Senior AWS Data Engineer Locations: Fort Mill, SC Experience: 09+ years Key Skills: Data,...  ...Description: Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into Snowflake. Utilize AWS services such as... 
    Senior
    Full time

    Coforge

    Fort Mill, York County, SC
    5 days ago
  • $39.86 - $62.29 per hour

     ...with 10+ years of IT experience and deep expertise in data engineering and cloud-based data platforms (Snowflake/AWS). The ideal candidate will have strong hands-on...  ...compliance frameworks. Familiarity with ETL tools and modern data integration frameworks. Strong... 
    Suggested
    Contract work

    Capgemini

    Fort Mill, York County, SC
    4 days ago
  •  ...Senior Data QA Engineer | LPL Travel: One week per month onsite in Fort Mill, SC. Travel expenses are paid. Role overview We’re looking...  ...’ll also contribute to Playwright automation and help test ETL workflows. Responsibilities Write complex SQL... 
    Senior

    ECCO Select

    Fort Mill, York County, SC
    22 hours ago
  •  ...Job Title: Senior AWS Data Engineer Experience: 8+ Years Skills: AWS Glue, Lambda, Pyspark, Python Location: Fort Mill, SC Job Description : Develop migration workflows based on the approved metadata extraction design. Implement support for full... 
    Senior

    Coforge

    Fort Mill, York County, SC
    a month ago
  •  ...Lead Data Engineer Location : Fort Mill SC Skills : Snowflake, AWS glue, Hive, Python and Pyspark. Experience: +10 years We at Coforge are hiring Lead...  ...for data extraction, transformation, and loading (ETL) processes. Manage containerized applications... 

    Coforge

    Fort Mill, York County, SC
    29 days ago
  • $39.86 - $62.29 per hour

    Data Engineer (AWS Glue, Airflow, Lambda, Postgres) We are seeking a skilled Data Engineer with...  .... Build and maintain AWS Glue ETL jobs (PySpark/Python) for data ingestion...  ...with downstream teams (BI, analytics, and Snowflake if applicable) to ensure reliable data consumption... 
    Contract work

    Capgemini

    Fort Mill, York County, SC
    4 days ago
  •  ...Senior Data Analyst Data Analytics · Business Analysis · Snowflake · AWS · SQL · Python Fort Mill, SC | Hybrid | Full Time...  ..., data analytics, and digital engineering to deliver impactful solutions...  ...Expertise in data profiling, ETL processes, data quality, and reporting... 
    Senior
    Full time

    Incedo Inc.

    Fort Mill, York County, SC
    11 days ago
  •  ...Data Engineer Technology  |  Rock Hill, SC (Hybrid)  |  Full-Time Mission Statement: At ARC Energy Services, we are a veteran-...  ...Experience with at least one cloud data platform, such as Databricks, Snowflake, BigQuery, or Redshift. ~ Experience with Git and code... 
    Full time
    For contractors
    Casual work
    Work at office
    Remote work

    Arc Energy Services

    Rock Hill, SC
    12 days ago
  • $39.86 - $62.29 per hour

    Capgemini is seeking a skilled Data Engineer (AWS Glue, Airflow, Lambda, Postgres) in Fort Mill, South Carolina. The role involves designing and building scalable data pipelines and performing analytics on AWS and Postgres platforms. The ideal candidate should have 6+ years... 

    Capgemini

    Fort Mill, York County, SC
    4 days ago
  •  ...production test records every day across test sites, customers, and the Rock Hill production line. Engineering, quality, and machine learning teams depend on that data being collected, organized, and searchable. This role builds the pipelines and data stores that... 
    Permanent employment

    Powerus

    Rock Hill, SC
    9 days ago
  • $7.5k

     ...25,000+ patents , and 7,000+ engineers , operating across 70+ countries...  ..., manufacturing, healthcare, data centers, and utilities...  ...experience developing data pipelines, ETL processes, business...  ...technologies such as PowerBI, Snowflake, Databricks, or Spark. ~3+ years... 
    Temporary work
    Worldwide

    On Time Hire

    Weddington, NC
    6 days ago
  •  ...are seeking an accomplished Senior Program Manager / Program Director – Data, Analytics & Digital Engineering with approximately 20+ years...  ...involving AWS, AWS Glue and Snowflake is essential. The candidate is...  ...Architecture • Data Engineering and ETL/ELT • Data Warehousing,... 
    Senior

    Coforge

    Fort Mill, York County, SC
    12 days ago
  •  ...Experience: 10+ years About the Role We are looking for a Senior Camunda Developer with strong Java expertise to design,...  ...Camunda BPM platform (7.x and/or Camunda 8) and a strong backend engineering background. Key Responsibilities Design, develop, and... 
    Senior
    3 days per week

    VGAI Solutions

    Fort Mill, York County, SC
    9 days ago
  •  ...ESP Associates, Inc. (ESP) is seeking a Special Inspector / Senior Engineering Technician to perform inspection and testing services related...  ...team Report inspections and test results through ESP’s field data collection software Qualifications: # High School... 
    Senior
    Temporary work
    Flexible hours
    Night shift

    ESP Associates

    Fort Mill, York County, SC
    24 days ago
  •  ...Description Job Description Senior SQL Developer Job Number: 2...  ...availability solutions. ETL Development & SSIS: Develop...  ...packages for ETL processes to ensure data is efficiently integrated from...  ...Certified: Azure Data Engineer Associate or Microsoft Certified... 
    Senior

    ECLARO

    Fort Mill, York County, SC
    20 days ago
  • Transportation Security Administration in Fort Mill, SC is seeking Supervisory Transportation Security Officers (STSOs) to lead screening operations and supervise teams across checkpoints and related activities. You will supervise Transportation Security Officers and Lead...
    Senior

    TSA Careers Center

    Fort Mill, York County, SC
    16 hours ago
  •  ...The Company: Fortune 500 Financial Services Corporation What You Will Be Doing: Hands on Senior SQL Database Administrator responsible for the secure design, administration, and operational integrity of enterprise Microsoft SQL Server environments (SQL Server... 
    Senior

    Associate Staffing

    Fort Mill, York County, SC
    a month ago
  •  ...Senior Product Owner with Scrum Master experience - Wealth Management Location: Fort Mill, SC Mode of Hire: Full Time   Job Summary: We are seeking a highly experienced Senior Product owner with a strong background in the Wealth Management domain .... 
    Senior
    Full time

    Coforge

    Fort Mill, York County, SC
    a month ago
  •  ...Role: Senior Product Manager – Payments Location: Fort Mill, SC Mode of Hire: Full Time Responsibilities Product Delivery...  ...Stakeholder & Team Collaboration Partner with business, engineering, architecture, QA, and operations teams. Lead backlog refinement... 
    Senior
    Full time

    Coforge

    Fort Mill, York County, SC
    18 days ago
  •  ...helping maintain our AWS hosted web application. Collaborate with data modelers, analysts, and business users to ensure ongoing...  ...or other cloud providers. Experience with Databricks, ADF, Glue, ETL's, and ELT's. • Shown ability to work inclusively, communicate efficiently... 

    Javen Technologies

    Fort Mill, York County, SC
    16 hours ago
  • Shutterfly in Fort Mill, SC seeks an experienced supervisor/lead operator to manage daily manufacturing activities and safety protocols. You will drive production metrics, support cross-training, and coordinate with shift teams to ensure on-time fulfillment of all products...
    Senior
    Shift work

    Shutterfly

    Fort Mill, York County, SC
    4 days ago
  • Mills Automotive Group is seeking a highly skilled Automotive Diagnostic Specialist to serve as the first technical touchpoint for shop appointments. This role involves pre-inspecting scheduled vehicles and providing a strong diagnostic direction to ensure efficient repairs...
    Senior

    Mills Automotive Group

    Fort Mill, York County, SC
    4 days ago
  • Job DescriptionJob DescriptionEssential Functions- Interviews residential mortgage loan applicants.- Requests specified information for loan application.- Notifies applicant of loan decision.- Corresponds with customers, applicants or creditors to resolve questions regarding...
    Senior

    First Federal Bank

    Fort Mill, York County, SC
    2 days ago
  • $159.75k - $225.5k

     ...order retail environment. We are hiring a Senior Principal Software Engineerto drive the...  ...role reports directly to the Director of Engineering and is for a deeply technical engineer who...  ...problemDefine and improve service boundaries, data models, and integration points across... 
    Senior
    Remote work
    Worldwide

    Shutterfly

    Fort Mill, York County, SC
    1 day ago
  • Shutterfly in Fort Mill, SC is seeking a hands-on manufacturing leader to oversee safety, quality and throughput on the production floor. You will coach associates, drive metrics, and coordinate cross‑training while ensuring on‑time fulfillment of all products. Join a team...
    Senior
    Shift work

    Shutterfly

    Fort Mill, York County, SC
    2 days ago
  •  ...Senior.Net DeveloperFort Mill, SCContractNeed only local candidates who can work onsite from day 1 (hybrid 3 days a week)Prefer to have candidate with financial backgroundSkills required:Should have strong experience with.Net full stack development.Should have strong... 
    Senior
    Local area
    3 days per week
    1 day per week

    E-Solutions

    Fort Mill, York County, SC
    5 days ago
  • Intuit, Inc. is seeking a highly qualified tax professional to help TurboTax customers complete their returns remotely. You will provide expert tax guidance, perform full-service return preparation and signature, and answer product questions with clear, everyday language...
    Senior
    Remote job

    Intuit, Inc.

    Fort Mill, York County, SC
    2 days ago
  •  ...ROLE SUMMARY: The Senior Nuclear Quality Engineer for Flowserve is key to ensuring we continue to deliver high-quality and reliable products that meet...  ...to define and analyze quality management workflows. Make data driven decisions Embrace and drive accountability and... 
    Senior
    Full time
    Work at office
    Shift work

    Flowserve

    Fort Mill, York County, SC
    1 hour ago
  •  ...Job Description Job Description FindTalent is seeking a highly experienced Senior Civil Engineer to provide engineering and technical expertise for site development and permitting projects in the power delivery sector . This role involves supporting utility substation... 
    Senior
    For contractors
    Work at office
    Local area

    FindTalent

    Fort Mill, York County, SC
    18 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior Informatica ETL & Snowflake Data Engineer. Be the first to apply!