Data Integration Developer
Indore, India · Hybrid · Full-time
- Posted 1w ago
- From NucleusTeq’s careers page
- Location
- Indore, India
- Work mode
- Hybrid
- Type
- Full-time
- Experience
- 3+ years
- Department
- Data and Analytics
Opens the listing on nucleusteq.breezy.hr
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.
About the role
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).
Skills they ask for
Pick one to see other roles that ask for it.
About NucleusTeq
AI and data solutions for industry transformationNucleusTeq provides AI, data, and technology services to support business transformation and decision-making across industries including banking, retail, and insurance.
See all 5 roles at NucleusTeqMore roles at NucleusTeq
See all 5- SAS DI Migration EngineerIndore · Senior · HybridData and Analytics · Senior · HybridIndore, India1w
- Data EngineerIndore · Senior · HybridData and Analytics · Senior · HybridIndore, India1w
- ETL Big Data TesterIndore · HybridQuality Assurance · HybridIndore, India1w
- Infrastructure EngineerIndoreInformation TechnologyIndore, India1mo
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.