Back to list

Vacancy description

Senior Data Engineer - Informatica CDI & SAS Migration in Indhur, भारत

NucleusTeq

Indhur, भारत

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.

Similar vacancies

More like this role

... 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 What you need - SAS - Informatica - SQL - Python - Snowflake ...

Raipur, भारत

  • Full-time
  • Contract
... 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 ...

Raipur, भारत

... East, India, Africa) and we partner with 1,000+ clients. What you will be doing As a Senior Engineer in our India office, you will support and develop client data platforms, with a focus on metadata management and data governance using enterprise tools such as Informatica Intelligent Data Management Cloud (IDMC). Your role ...

Pune, भारत

Mid-level data science role at NucleusTeq. Needs 3+ years. Remote. What you'll do - Source/Target Integration: Establish connections and ingest data from heterogeneous sources, including relational databases, cloud storage (AWS S3, Azure Data Lake - Scheduling & Automation: Schedule and orchestrate workflows via CDI Taskflows ...

Raipur, भारत

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

Indhur, भारत

Technogen India Private Limited

Data Engineer - Informatica/Snowflake

About the Role : We are looking for an experienced Data Engineer with strong expertise in ETL/ELT development, Informatica, SQL, Python, and cloud-based data platforms. The ideal candidate will be responsible for designing, developing, and maintaining scalable data pipelines, managing data integration processes, and supporting ...

Hyderabad, भारत

... Integration (CAI), Cloud Data Integration (CDI), and B2B Gateway - Configure, administer, and optimize Informatica Managed File Transfer (IMFT) for secure and reliable data exchange across internal and external systems - Develop and maintain Shell scripts (Bash/PowerShell) to automate integration workflows, data processing activities, ...

Bangalore, भारत

Senior data science role at HCLTech in Ahmedabad. What you'll do - Collaborate within team to gather and understand data requirements - Develop and implement informatica mdm solutions for data integration and management - Design and optimize sql queries and procedures for data extraction and manipulation What you need - ...

Ahmedabad, भारत

... REST/SOAP APIs and real-time messaging patterns via CAI guides and processes - Optimization & Troubleshooting: Tune performance of complex mappings, bottlenecks, and data flows; troubleshoot and resolve production issues promptly What you need - Informatica - SQL - REST APIs - Salesforce - ETL - SAP Good to have - NoSQL - CI/CD ...

Coimbatore, भारत

Leadership software engineering role at Horizontal Digital in Jaipur. Needs 10+ years and an MBA. What you'll do - Work with functional and business clients to determine solutions that drive additional business value and lead data strategy, design robust data models - Work with Salesforce products: Informatica, Mulesoft, ...

Jaipur, भारत