Informatica IDMC & Snowflake Developer

Job Title: Informatica IDMC & Snowflake Developer

Experience: 6+ Years

Employment Type: Contractual

Contract Duration: 2 Months

Notice Period: Immediate Joiners Preferred

We are looking for an experienced Informatica IDMC & Snowflake Developer with strong hands-on expertise in ETL/ELT development, Data Warehousing, Snowflake, and advanced SQL.

Mandatory Technical Skills

• Informatica IDMC: Hands-on experience with CDI, CAI, and Mass Ingestion (MI).
• Snowflake: Data ingestion, transformations, SQL, performance tuning, and warehouse optimization.
• ETL/ELT: Pipeline development, incremental loads, CDC, error handling, and data reconciliation.
• Data Warehousing: Dimensional modelling, star/snowflake schemas, fact/dimension tables, and SCD.
• Advanced SQL: Complex queries, joins, CTEs, analytical functions, stored procedures, and query optimization.

Key Responsibilities

• Design, develop, and optimize ETL/ELT pipelines using Informatica IDMC and Snowflake.
• Implement scalable data integration, transformation, and data warehousing solutions.
• Perform SQL and ETL performance tuning, data validation, and troubleshooting.
• Develop source-to-target mappings and technical documentation.
• Ensure data quality and support testing, deployments, and production activities.

Candidate Requirements

• 6+ years of experience in ETL/ELT development and data integration.
• Proven hands-on experience with all mandatory technologies.
• Strong analytical, troubleshooting, and communication skills.
• Ability to work independently in an Agile environment.

Important: Apply only if you have hands-on experience with Informatica IDMC, Snowflake, Data Warehousing, and Advanced SQL, and are comfortable with a 2-month contractual assignment.