Senior Data Engineer Informatica CDI And SAS Migration

NucleusTeq; Indore District; On-site; INR 1,500,000 - 3,200,000; Full time

Job summary

NucleusTeq in Indore, India, is seeking an experienced Informatica Cloud Data Integration (CDI) Engineer to lead our data modernization initiative. You will design, implement, and optimize cloud-based ingestion and transformation pipelines using IICS CDI to migrate legacy SAS workflows and business logic.

You will partner with data governance and security teams to ensure data fidelity, performance, and compliant data movement, while mentoring junior engineers and driving best practices across

Qualifications

• 4+ years with Informatica CDI building mappings and taskflows in IICS.
• 2+ years SAS modernization; read SAS code and translate to CDI/SQL.
• Advanced SQL and data warehousing with Snowflake/Redshift/BigQuery.
• Strong data modeling and end-to-end data re-platforming experience.
• Experience mentoring engineers and conducting code reviews.

Responsibilities

• Architect and deploy ELT/ETL pipelines using CDI.
• Migrate legacy SAS workflows to CDI and rewrite logic in SQL.
• Optimize performance, governance, logging, and security data handling.

Skills

Informatica Cloud Data Integration CDI

SAS Modernization / Translation

SQL & Data Warehousing

Data Modeling

End-to-End Delivery

Education

Bachelor's or Master’s in CS/IT/Data Engineering

Tools

Control-M

Autosys

CI/CD pipelines (IICS artifacts)

Git integration

Cloud data warehouses (Snowflake/Redshift/BigQuery/Databricks)

Job description

Job Description:

Role Overview

We are looking for an experienced Informatica Cloud Data Integration (CDI) Engineer to join our data modernization initiative. In this role, you will be instrumental in migrating legacy, mission-critical SAS data workflows, scripts, and business logic onto modern cloud-native architectures using Informatica Intelligent Cloud Services (IICS) CDI.

You will lead the end-to-end design, implementation, and optimization of cloud-based data ingestion and transformation pipelines, ensuring seamless business continuity and data fidelity.

Key Responsibilities

Pipeline Architecture & Design (CDI)

• Architect, design, develop, and deploy robust, scalable ELT/ETL pipelines using Informatica Cloud Data Integration (CDI).
• Design modular data integration components, including complex Data Synchronization Tasks, Mapping Tasks (MCTs), and Taskflows.
• Build low-latency, scalable pipelines connecting diverse sources to enterprise cloud data warehouses/lakes (e.g., Snowflake, BigQuery, AWS Redshift, or Databricks).
• Establish best practices for parameterization, dynamic configuration, error handling, session logging, and alerting in IICS CDI.

SAS Migration & Modernization

• Conduct thorough analysis of legacy SAS scripts, macros, data steps, and SQL procedures (PROC SQL, DATA steps, hash objects) to extract and document business rules.
• Reverse-engineer legacy SAS logic into target data models and transformational logic in CDI and SQL.
• Design parallel-run execution strategies, reconciliation pipelines, and regression testing frameworks to validate numerical and structural parity between SAS outputs and CDI outputs.
• Decommission obsolete SAS workflows, identifying consolidation and performance optimization opportunities.

Performance Optimization & Governance

• Optimize CDI mappings and pushdown optimization (Full/Source pushdown) to maximize processing efficiency on cloud warehouses.
• Manage IICS Secure Agents, runtime environments, and scheduling integration (e.g., Control-M, Autosys, or Cloud Native Schedulers).
• Partner with Data Governance, Security, and Quality teams to implement data masking, lineage tracking, and compliance standards.

Technical Qualifications

Must-Have Experience

• Informatica Cloud Data Integration (CDI): 4+ years of hands-on experience building complex mappings, hierarchical transformations, lookups, and taskflows in IICS CDI.
• SAS Modernization / Translation: 2+ years of direct experience analyzing, modernizing, or re-platforming legacy Base SAS / SAS MACRO workflows. Ability to read SAS code fluently and reconstruct its logic using modern SQL/CDI.
• SQL & Data Warehousing: Advanced SQL proficiency (complex analytical functions, windowing, subqueries) with hands-on experience in at least one modern cloud warehouse (Snowflake, AWS Redshift, Google Cloud BigQuery, or Azure Synapse/Databricks).
• Data Modeling: Solid understanding of Star Schema, Snowflake Schema, SCD (Slowly Changing Dimensions Types 1, 2, 3), and data staging patterns.
• End-to-End Delivery: Proven record of participating in large-scale data re-platforming, validation, and historical data reconciliation.

Nice-to-Have / Preferred

• Official Informatica Cloud Data Integration Specialist Certification.
• Hands-on scripting capability in Python or Bash for pipeline automation and validation.
• Familiarity with CI/CD deployment pipelines for IICS artifacts (Git integration, asset export/import APIs).
• Experience handling semi-structured data formats (JSON, Parquet, Avro, XML) within CDI.

Soft Skills & Leadership

• Strong analytical problem-solving skills with meticulous attention to detail in data validation and discrepancy resolution.
• Ability to articulate technical trade-offs between pushdown SQL execution and CDI transformations to technical and non-technical stakeholders.
• Experience mentoring mid-level/junior engineers and conducting code/design reviews.

Qualifications

• Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Engineering, or a related quantitative field (or equivalent practical experience).
• Experience: 6+ years of overall data engineering/integration experience, with a proven focus on IICS CDI implementations and legacy ETL/code migrations.