Data Integration Developer (Informatica CDI)

NucleusTeq; Indore District, Raipur, Gurugram District, Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

NucleusTeq is seeking a proactive Data Integration Developer with hands-on Informatica CDI experience to design, build, test, and maintain cloud-native data pipelines across cloud and on-premise platforms.

You will ingest, transform, and orchestrate data for enterprise analytics, collaborating with data engineers and analysts to ensure reliable, scalable data flows and timely reporting.

Qualifications

• 3+ years of hands-on Informatica CDI experience.
• Strong SQL with complex joins, aggregations, and performance tuning.
• Solid understanding of dimensional modeling and SCDs.
• Experience with cloud data warehouses and object stores.
• Ability to translate requirements into technical workflows and debug issues.

Responsibilities

• Design, build, and optimize end-to-end data pipelines using Informatica CDI.
• Ingest data from relational sources, cloud storage, APIs, and data warehouses.
• Implement transformations such as Expression, Router, Joiner, and Lookup.
• Schedule and orchestrate workflows and integrate with CI/CD pipelines.
• Monitor, test, and debug pipelines and resolve run-time issues.

Skills

Informatica CDI

SQL

DW fundamentals

Cloud DW

Cloud storage

Problem solving

Tools

Informatica CDI tooling

Unix/Linux shell

Python

Informatica CAI

Job description

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).