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
- 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).
- 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.
- 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.
- Strong SQL and PL/SQL development experience.
- Experience migrating data from Oracle to Snowflake.
- Knowledge of Oracle performance tuning, backup, and optimization.
- 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.
- 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.
- Hands-on experience with S3, EC2, DMS , and related AWS services.
- Build and orchestrate cloud-based data pipelines.
- Experience with serverless data integration solutions.
- Analyze large datasets using SQL and Python.
- Strong understanding of ER Models, Star Schema, and Snowflake Schema .
- Design scalable, maintainable enterprise data models.
- Informatica Intelligent Cloud Services (IICS/ICS)
- Design and develop ETL workflows integrating Oracle, Snowflake, and AWS.
- MuleSoft
- API-led integrations between Snowflake, Oracle, and AWS.
- Experience building enterprise integration workflows using MuleSoft APIs.
- 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
- ...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...SeniorFull time
$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...SuggestedContract work- ...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
- ...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
- ...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...
$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- ...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...SeniorFull time
- ...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 timeFor contractorsCasual workWork at officeRemote work
$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...- ...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
$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 workWorldwide- ...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
- ...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...Senior3 days per week
- ...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...SeniorTemporary workFlexible hoursNight shift
- ...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
- 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
- ...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
- ...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 ....SeniorFull time
- ...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...SeniorFull time
- ...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...
- 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...SeniorShift work
- 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
- 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
$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...SeniorRemote workWorldwide- 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...SeniorShift work
- ...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...SeniorLocal area3 days per week1 day per week
- 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...SeniorRemote job
- ...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...SeniorFull timeWork at officeShift work
- ...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...SeniorFor contractorsWork at officeLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Informatica ETL & Snowflake Data Engineer. Be the first to apply!
Related searches
- data engineering intern summer Fort Mill, York County, SC
- data engineer analytics Fort Mill, York County, SC
- data developer Fort Mill, York County, SC
- aws data engineer Fort Mill, York County, SC
- data science developer Fort Mill, York County, SC
- finance data engineer Fort Mill, York County, SC
- data engineer Fort Mill, York County, SC
- senior data center engineer Fort Mill, York County, SC
- data engineer machine learning Fort Mill, York County, SC
- data center engineer Fort Mill, York County, SC






