21 Oct
|
Assessment360.ai
|
Bengaluru
21 Oct
Assessment360.ai
Bengaluru
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 workplace.
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.
📌 Informatica IDMC & Snowflake Developer (Bengaluru)
🏢 Assessment360.ai
📍 Bengaluru