Back to list

Vacancy description

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

NucleusTeq

  • Full-timeStandard weekly hours
  • ContractFixed-term or freelance

Raipur, भारत

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

  • Remote
... expertise in Informatica MDM, including the configuration of Data Modeling, Hierarchy Management, and Informatica Data Director (IDD).- Exhibit strong proficiency in Data Integration tools, specifically Informatica PowerCenter or IICS, with a proven ability to handle complex ETL processes and large-scale data migrations.- Possess ...

India, भारत

... practices around data engineering.- Lead architecture discussions, align with business needs, security, and best practices.- Has strong conceptual understanding of Data Warehousing and ETL, Data Governance and Security, Cloud Computing, and Batch & Real Time data processing.- Has strong execution knowledge of Data Modeling, Databases ...

Hyderabad, भारत

  • Full-time
Mid-level data science role at KreditBee in Bengaluru. Needs 2–4 years and a https://jobeax.com/link/2DENLGgQM7whDhaE or B.E.. What you'll do - ⁠ ⁠Develop various RestFul APIs & Integrate with various data sources - ⁠ ⁠Develop tools & techniques related to ETL - ⁠ ⁠Exposure in AWS or Other Cloud Platform is advantageous ...

Bangalore, भारत

  • On-site
  • Full-time
... your world, creating more fulfilling work and projects for our people and clients. For more information, visit [ Job Description We’re looking for a skilled Senior Data Engineer with strong experience in distributed systems, Python/Scala, and modern data engineering tools to help design and implement an end-to-end data ...

Hyderabad, भारत

  • Full-time
  • Contract
Senior Data Engineer POSITION PURPOSE: - The Data & Analytics organization enables Bayer’s Corporate Functions—including Finance, Supply Chain & Logistics, HR, Procurement, Legal, and Sustainability—to become more insight and data-driven. Our mission is to deliver a robust data foundation and FAIR—Findable, Accessible, ...

Bangalore, भारत

  • Full-time
This is a strategic data engineering engagement with our client to architect and plan the migration of their entire data processing and ETL estate from Matillion to AWS Glue — a foundational shift in how one of the world's largest financial market infrastructure companies handles its data pipelines. During this Mobilisation ...

Bangalore, भारत

Merrill Communications

Senior Data Engineer

  • Full-time
... Spark (PySpark) – Strong experience in building distributed data pipelines . - Python – Proficiency in writing optimized and maintainable Python code for data engineering. - Unity Catalog – Hands-on experience implementing data governance, access controls, and lineage tracking . - SQL – Strong knowledge of SQL for data transformations ...

Chennai, भारत

  • Remote
  • Hybrid
  • Full-time
  • Contract
... perfect your skills in a field filled with exciting challenges and opportunities. About the role As part of the Big Data B2B program, OBS set up a shared Big Data platform and a Data Lake for Use cases exploration and industrialization. We are looking for Senior Data Engineer 5-8 years of experience in building Data Pipelines ...

Gurgaon, भारत

  • Full-time
  • IT
... networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential. Title and Summary Senior Data Engineer Overview We are the global technology company behind the world’s fastest payments processing network. We are a vehicle for commerce, a connection ...

Pune, भारत

  • Full-time
Job Summary Valorem Reply is looking for a Data Engineer with experience building and contributing to the design of database systems, both normalized transactional systems and dimensional reporting systems. Strong experience with SQL Server as a database engine, as well as Microsoft and Databricks technology experience ...

Ernakulam, भारत