Data Integration Developer (Informatica CDI)
At a glance
Mid-level Data Engineering role at NucleusTeq. Indore/Raipur/Gurugram/Bangalore, India · full-time.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Create and improve CDI pipelines through mappings, taskflows, mapping tasks and synchronization tasks
- Bring data in from databases, APIs, cloud storage and warehouses, then connect it to downstream targets
- Apply business rules with CDI transformations such as joins, lookups, aggregations and SQL ELT pushdown
- Orchestrate scheduled workflows, test pipeline behavior and resolve runtime errors or performance bottlenecks
- Track production runs, tune execution times and help identify why jobs fail
What you bring
- At least three years of practical CDI work creating, deploying and fixing mappings and taskflows
- You can write complex SQL with joins, aggregations and window functions, and tune query performance
- You understand dimensional schemas, SCD Type 1 and 2, and incremental load approaches
- You have working knowledge of a major cloud warehouse and object storage such as S3 or ADLS
- You can turn data mapping documents into technical workflows and diagnose mapping problems on your own
Who this fits
This suits a hands-on, mid-level developer focused on data pipelines and production operations. The role is hybrid in India.
From the employer
Role Overview
We are looking for a proactive Data Integration Developer with practical, hands-on experience in
Informatica Cloud Data Integration (CDI). In this role, you will design, build, test, and maintain cloud-native data pipelines, ingesting and transforming data across diverse cloud and on-premise platforms to support our enterprise analytics and reporting ecosystems.
Key Responsibilities
● Pipeline Development: Design, build, and optimize end-to-end data pipelines using Informatica CDI (mappings, mapping tasks, taskflows, and synchronization tasks).
● Source/Target Integration: Establish connections and ingest data from heterogeneous sources, including relational databases, cloud storage (AWS S3, Azure Data Lake, GCP), APIs, and modern data warehouses (Snowflake, BigQuery, Databricks, or Amazon Redshift).
● Data Transformation: Implement business logic using standard and advanced transformations (e.g., Expression, Router, Aggregator, Joiner, Lookup, Normalizer, and SQL ELT pushdown).
● Scheduling & Automation: Schedule and orchestrate workflows via CDI Taskflows and integrate with external job schedulers or CI/CD deployment pipelines where applicable.
● Testing & Debugging: Perform unit testing, resolve pipeline bottlenecks, and debug run-time errors or session logs.
● Maintenance & Monitoring: Monitor production execution runs, optimize execution runtimes, and assist in root-cause analysis for failed jobs.
Required Qualifications & Skills
● Informatica Expertise: 3+ years of hands-on experience building, deploying, and troubleshooting mappings and taskflows in Informatica CDI (IDMC).
● SQL Proficiency: Strong practical knowledge of SQL (writing complex joins, aggregations, window functions, and query performance tuning).
● Data Warehousing Foundations: Solid understanding of dimensional modeling (Star and Snowflake schemas), slowly changing dimensions (SCD Type 1/2), and incremental load strategies.
● Cloud & Platform Experience: Working familiarity with at least one major cloud data
warehouse (Snowflake, Google BigQuery, or Amazon Redshift) and cloud object stores (S3, ADLS).
● Problem Solving: Ability to read data mapping specifications, translate functional requirements into technical workflows, and debug mapping issues independently.
Preferred / Nice-to-Have Skills
● Hands-on experience with Informatica CAI (Cloud Application Integration) for API-led or real-time workflows.
● Familiarity with Unix/Linux shell scripting or basic Python for pre/post-processing tasks.
● Experience configuring Informatica Secure Agents on Linux/Windows environments.
● Official Informatica certification (e.g., Informatica IDMC Cloud Data Integration Specialist).
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.