Informatica Cloud Data Quality (CDQ) Consultant

Job Description:

Skill Set

Informatica, IDMC, Informatica MDM

Experience

4-6 Years

Location

Faridabad, Haryana, India

Work Mode- Hybrid

Job Description

Roles & Responsibilities

• Lead project team members through all activities required to successfully deliver Informatica.
• Define technical specifications for workflows and business rules.
• Prepare detailed design documents for data migration.
• Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
• Train and mentor colleagues in Informatica implementation activities and best practices.
• Support integration, system, and user acceptance testing.
• Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
• Profile & Analyze Source Data usage using ETL tool.
• Automation, job scheduling, dependencies, monitoring.
• Configure/Script Business rules and transformation rules in ETL
• Data pipeline using IICS
• Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
• Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
• Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
• Experience in administering, supporting, and performance tuning using Informatica.

Hiring: Informatica IDMC / IICS Developer

Location: Faridabad, Haryana

Experience: 4–7 Years

Must-Have:

• Informatica IDMC / IICS

• Data Integration & Application Integration (CAI)

• ETL / Data Pipelines / Data Migration

• REST, SOAP, SFTP & API Integration

• Strong SQL, Stored Procedures & RDBMS

• Job Scheduling, Monitoring & Performance Tuning

Good to Have: Informatica MFT, DX, DT, MDM & Data Quality

Job Description: Informatica IDMC & Snowflake Developer

Experience: 6+ Years

Required Skills: Informatica IDMC, ETL, Data Warehousing, Snowflake, SQL

Contract Duration: 2 months

Required Technical Skills

• Informatica: Strong hands-on experience with Informatica IDMC, Cloud Data Integration (CDI), Cloud Application Integration (CAI), Mass Ingestion (MI).
• ETL / ELT: Strong understanding of ETL architecture, data integration patterns, incremental loading, and error-handling strategies.
• Data Warehousing: Good understanding of dimensional modelling, data marts, fact and dimension tables, and data warehouse design principles.
• Snowflake: Hands-on experience with Snowflake architecture, SQL, data loading, transformations, performance tuning, and warehouse optimization.
• SQL: Strong proficiency in complex SQL queries, analytical functions, views, stored procedures, and query optimization.
• Database Development: Experience creating and maintaining database objects, validating data, reconciling datasets, and troubleshooting performance issues.

Candidate Profile

• 6+ years of hands-on experience in ETL/ELT development and data integration along with IDMC, Snowflake, Data Warehousing and SQL.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently, manage priorities, and collaborate effectively with cross-functional teams.
• Proven ability to deliver high-quality, scalable, and maintainable data solutions in an Agile Environment.