About this role
Job title: Informatica IDMC / Snowflake Developer
About the Role The Informatica IDMC / Snowflake Project Developer designs, builds, and optimizes data integration solutions using Informatica IDMC and Snowflake. You will design ETL/ELT pipelines, enable seamless data movement across cloud and on-premises environments, and support enterprise data modernization initiatives. You will collaborate with cross-functional teams to translate business requirements into scalable data solutions.
What You'll Do
- Design, develop, implement, and maintain data integration solutions using Informatica IDMC.
- Build and optimize ETL/ELT pipelines for data ingestion, transformation, and loading across on-premises and cloud platforms, with a strong focus on Snowflake.
- Develop and manage Snowflake-based data pipelines, including data loading, transformation logic, performance tuning, and warehouse usage optimization.
- Collaborate with data architects, business analysts, and stakeholders to understand business and technical requirements and translate them into scalable data solutions.
- Support data migration and modernization initiatives, including movement from legacy data platforms to Snowflake.
- Monitor, troubleshoot, and improve data pipelines to ensure performance, reliability, scalability, and data quality.
- Implement and follow best practices related to data integration, data security, governance, and cloud data engineering.
- Work with scheduling and orchestration tools such as Control-M to automate and manage workflows efficiently.
- Document technical designs, workflows, mappings, and operational procedures to support ongoing maintenance and future enhancements.
What We're Looking For
- 3+ years of hands-on experience in Informatica IDMC development.
- Strong Snowflake experience: data loading and transformation, Snowflake SQL and scripting, performance tuning, virtual warehouses, stages, file formats, and best practices.
- Strong knowledge of SQL, data warehousing concepts, and ELT/ETL frameworks.
- Experience with cloud platforms such as Azure and GCP.
- Familiarity with Oracle and other enterprise data platforms is a plus.
- Experience with Control-M, workflow scheduling, and job orchestration tools.
- Knowledge of API-based integrations, semi-structured data processing, and real-time / near real-time integration patterns.
- Strong troubleshooting, analytical, and performance optimization skills.
- Ability to work effectively in a fast-paced, collaborative environment and manage multiple priorities.
Nice to Have
- Familiarity with Oracle and other enterprise data platforms is a plus.
Compensation & Benefits
- Not specified in the posting.