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 2 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
- ...are seeking an experienced Data Engineer to design, build, and enhance... ...Glue , Python/PySpark , ETL pipelines , and metadata... ...across systems like SQL Server, Informatica, AWS Glue, and Azure Data... ...(SQL Server, Oracle, or Snowflake) - complex queries, stored procedures...Senior
Euclid Innovations
Fort Mill, York County, SC4 days ago - ...Senior Data Engineer Fort Mill, SC Responsibilities: Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into Snowflake. Utilize AWS services such as Airflow and Glue for orchestration and data processing tasks...SeniorFull time
Coforge
Fort Mill, York County, SC3 days 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...SeniorFull time
Coforge
Fort Mill, York County, SC2 days 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...SuggestedFull time
Coforge
Fort Mill, York County, SC1 day ago - ...Job Description Job Title / Role: Senior AWS Data Engineer \n Key Skills: AWS services, Airflow... ...\n \n Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into Snowflake. \n Utilize AWS services such as...SuggestedFull timeShift work
Coforge
Fort Mill, York County, SC2 days ago - ...Job Description Job Title: Senior AWS Data Engineer \n Experience: 8+ Years \n Skills: AWS Glue, Lambda, Pyspark, Python \n Location: Fort Mill, SC \n \n Job Description : \n \n \n Develop migration workflows based on the approved metadata extraction...Senior
Coforge
Fort Mill, York County, SC24 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 timeFor contractorsCasual workWork at officeRemote work
ARC Energy Services, Inc
Rock Hill, SC4 days ago - ...Job Title: Senior Automation QE Tead Skills: HVR and AWS services, specifically... ...Airflow and Glue, automation, data integration, and ETL processes, Snowflake and SQL for data management and... ...automation technologies and data engineering. The ideal candidate will have extensive...SeniorFull time
Coforge
Fort Mill, York County, SC2 days ago - ...a high-growth Digital, Data and AI Transformation Specialist... ...& Data capabilities • Engineering & Operations excellence. Title:: Senior QA Engineer Location... ...in Data Warehouse, ETL, and Cloud Data Platform... ...expertise in AWS, DBT, Snowflake, Python, Apache Airflow,...SeniorFull time
Incedo Inc.
Fort Mill, York County, SC2 days ago $159.75k - $225.5k
...moments that reflect who they uniquely are.We are seeking a Senior Principal Software Engineer to lead the design and development of next-generation... ...efficiency, and business KPIsPartner with Product, UX, and Data teams to translate AI capabilities into: Increased...SeniorRemote workShutterfly
Fort Mill, York County, SC5 days ago$240k - $290k
...Financial is seeking a strategic, forward-looking leader to serve as Senior Vice President and Chief Privacy Officer (CPO). Reporting... ..., Enterprise Risk Management, Information Security, Technology, Data Governance, Legal, Internal Audit, and various other business leaders...SeniorFull timeWork from homeLPL Financial
Fort Mill, York County, SC1 day ago$113.92k - $189.83k
...Job Overview:The Assistant Vice President (AVP), Release Train Engineer (RTE) & Program Manager, will serve as a strategic leader within... ...of technology initiatives. The AVP will partner closely with Senior Vice Presidents and cross-functional stakeholders to align roadmaps...SeniorFull timeWork at officeWork from homeLPL Financial
Fort Mill, York County, SC5 days ago- ...Job Title: Senior AI Automation Engineer Location: Fortmill, SC (Onsite) Duration: Contract Job Description: Mandatory Skills Agentic AI workflows AI orchestration API's & MCP integration Job Description: Position...SeniorContract work
Apptad
Fort Mill, York County, SC5 days ago $128k - $181.25k
...capture moments that reflect who they uniquely are.This is an exciting time for Shutterfly, and we are looking for a Senior Application Security Engineer to join our team. In this role you will help shape an evolving offensive security practice, leading Red Team...SeniorRemote workShutterfly
Fort Mill, York County, SC4 days ago$106.1k - $176.9k
...clients pursue their financial goals.Job OverviewAs a Senior Full‑Stack Software Engineer, you will contribute to the design, delivery, and... ...3, EventBridge, Athena, or Glue).Experience building ETL processes or data pipelines using structured and unstructured data sources...SeniorFull timeWork from homeLPL Financial
Fort Mill, York County, SC2 days 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 ....SeniorFull time
Coforge
Fort Mill, York County, SC2 days ago - ...strong emphasis on utilizing innovation and technology to cultivate client relationships. What You Will Be Doing: Hands on Senior SQL Database Administrator responsible for the secure design, administration, and operational integrity of enterprise Microsoft SQL...SeniorFull time
Associate Staffing
Fort Mill, York County, SC1 day ago - ...level of autonomy with visibility across business functions and senior leadership Opportunity to identify efficiencies, introduce new... ...Evaluate product performance, market trends, and operational data to identify opportunities for improvement and growth Oversee...SeniorFull time
AccruePartners
Fort Mill, York County, SC2 days ago - ...Full-Time Senior Veterinary Assistant UrgentVet bridges the gap between daytime general practice and emergency/overnight care, offering after-hours care for canine and feline patients without the additional expense of emergency clinic fees. Our hospitals offer care...SeniorFull timeNight shift
Clinical Support Staff
Fort Mill, York County, SC2 days ago $50 per hour
...hosted web application. Collaborate with data modelers, analysts, and business users to... ...Experience with Databricks, ADF, Glue, ETL's, and ELT's. Benefits ~ Medical,... ...team includes software developers, data engineers, data modelers, analysts, and technology...Contract workWork at officeWorldwideWork visaGlobal Technical Talent
Fort Mill, York County, SC3 days ago- ...Collaborate with other technology teams and business users to understand complex user journeys, workflows, and data interactions.Work with the company’s Engineering - 3rd Line Support Manager and collaborate with internal and external business collaborators.Manage,...Senior3 days per week
Axelon
Fort Mill, York County, SC3 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, SC2 days 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, SC5 hours ago $95k - $105k
...Senior Corporate Accountant Our client, a leading $11B+ global equipment services company headquartered near Charlotte that recently transitioned its primary public listing to the NYSE, is seeking a Senior Corporate Accountant to join their team! The Senior Corporate...SeniorWork at officeRemote workCRG
Fort Mill, York County, SC1 day ago- Essential 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 application information...Senior
First Federal Bank
Fort Mill, York County, SC3 days ago - ...SalaryUp to $65 / hourRemote50% RemoteJob Title : Senior Full Stack Developer Location : Fort Mill, SC... ...agentic development tools in day-to-day software engineering. Key ResponsibilitiesDevelop modern, responsive and data-intensive user interfaces using React.Maintain,...Senior3 days per week
Axelon
Fort Mill, York County, SC5 days ago - ...AI EngineerLocation: 100% Remote Role OverviewAs an AI Software Engineer, you will be responsible for designing, developing, and deploying... ...operations. You will work on a product team with engineers, data scientists, and product managers, contributing to the full product...Remote work
Apex Systems
Fort Mill, York County, SC5 days ago $63 per hour
...Release Train Engineer/Program Manager 12 month contract Fort Mill, SC (Hybrid) The role of the Release Train Engineer/Program Manager is to plan, execute, and oversee multiple project efforts aligned to a shared business objective. Experience with Cursor AI is...SeniorContract workYoh, A Day & Zimmermann Company
Fort Mill, York County, SC2 days ago- ...Senior.Net Full Stack Developer Location: Fort Mill, SC (ONSITE FROM DAY ONE, NO HYBRID OR REMOTE) Duration: long term Contract Must-Have Skills/Strong experience in:.NET Core / ASP.NET Core / C# Angular (latest versions) Experience in building REST APIs and...SeniorLong term contractRemote work
Kasmo Global
Fort Mill, York County, SC4 days ago - ...ResponsibilitiesDesign, develop, and maintain GraphQL APIs and Data Solutions using Aurora, Postgres, and Amazon Memory DB/Redis, ensuring... ...technical leadership, guidance and mentorship to junior engineers, promoting best practices and fostering a culture of continuous...SeniorFull time
OneMain Holdings
Fort Mill, York County, SC1 day 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!
Related searches
- senior devops engineer remote Fort Mill, York County, SC
- senior implementation engineer Fort Mill, York County, SC
- remote senior project manager Fort Mill, York County, SC
- senior software engineer Fort Mill, York County, SC
- senior mainframe developer Fort Mill, York County, SC
- senior financial analyst fp&a Fort Mill, York County, SC
- senior database analyst Fort Mill, York County, SC
- international tax senior Fort Mill, York County, SC
- senior operations technician Fort Mill, York County, SC
- senior manager legal Fort Mill, York County, SC