Data Integration Developer – Informatica CDI

NucleusTeq

. Design, build, and optimize end-to-end data pipelines using Informatica CDI, including mappings, mapping tasks, taskflows, and synchronization tasks .

Posted 11/9/2026full-timeIndore • IndiaMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and optimizing data pipelines using Informatica CDI, with strong SQL skills for complex data manipulation and a solid understanding of dimensional modeling. Proficient in cloud data warehousing and familiar with cloud storage solutions to support enterprise analytics.

Highest-signal resume keywords

Informatica CDI (IDMC) ExperienceSQL Query Performance TuningDimensional Modeling ExpertiseCloud Data Warehouse FamiliarityInformatica Certification

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data Pipeline DesignMappings and TaskflowsAdvanced TransformationsSQL ELT PushdownUnit TestingDebuggingRoot-Cause AnalysisData Mapping SpecificationsUnix/Linux Shell ScriptingPython for Pre/Post-Processing

Tools & Technologies

Informatica CAISnowflakeGoogle BigQueryAmazon RedshiftAWS S3Azure Data Lake StorageInformatica Secure Agents

Certifications & Qualifications

Informatica IDMC Cloud Data Integration Specialist

Industry Keywords

Cloud-Native Data PipelinesTaskflowsData WarehousingIncremental Load StrategiesSlowly Changing Dimensions

Tech Stack

Tools & technologies

Amazon RedshiftAWSAzureBigQueryCloudInformaticaLinuxPythonShell ScriptingSnowflakeSQLUnix

About the role

Key responsibilities & impact

Design, build, and optimize end-to-end data pipelines using Informatica CDI, including mappings, mapping tasks, taskflows, and synchronization tasks
Establish connections and ingest data from relational databases, cloud storage, APIs, and modern data warehouses
Implement business logic using standard and advanced transformations, including Expression, Router, Aggregator, Joiner, Lookup, Normalizer, and SQL ELT pushdown
Schedule and orchestrate workflows via CDI Taskflows and integrate with external job schedulers or CI/CD deployment pipelines where applicable
Perform unit testing, resolve pipeline bottlenecks, and debug runtime errors or session logs
Monitor production execution runs, optimize execution runtimes, and assist in root-cause analysis for failed jobs
Support enterprise analytics and reporting ecosystems through cloud-native data pipelines

Requirements

What you’ll need

3+ years of hands-on experience building, deploying, and troubleshooting mappings and taskflows in Informatica CDI (IDMC)
Strong practical knowledge of SQL, including complex joins, aggregations, window functions, and query performance tuning
Solid understanding of dimensional modeling, including Star and Snowflake schemas, slowly changing dimensions (SCD Type 1/2), and incremental load strategies
Working familiarity with at least one major cloud data warehouse: Snowflake, Google BigQuery, or Amazon Redshift
Familiarity with cloud object stores: AWS S3 or Azure Data Lake Storage (ADLS)
Ability to read data mapping specifications, translate functional requirements into technical workflows, and debug mapping issues independently
Hands-on experience with Informatica CAI for API-led or real-time workflows preferred
Familiarity with Unix/Linux shell scripting or basic Python for pre/post-processing tasks preferred
Experience configuring Informatica Secure Agents on Linux/Windows environments preferred
Official Informatica certification, such as Informatica IDMC Cloud Data Integration Specialist, preferred