Senior Data Engineer – Informatica CDI & SAS Migration

NucleusTeq

Indiana

On-site

USD 120,000 - 160,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

NucleusTeq is seeking an experienced Informatica Cloud Data Integration (CDI) Engineer to lead migration of legacy SAS data workflows to modern cloud-native CDI pipelines. You will design end-to-end data ingestion, transformation, and validation across Snowflake, Redshift, and BigQuery environments.

The role requires strong CDI implementation, SQL proficiency, and experience modernizing SAS logic into CDI mappings and taskflows. Collaboration with governance and security teams is essential.

Qualifications

  • Hands-on CDI development and mappings in IICS CDI.
  • Experience converting legacy SAS workflows to CDI/SQL.
  • Advanced SQL skills and data warehousing concepts.
  • Experience with cloud data platforms and ELT/ETL patterns.

Responsibilities

  • Design, implement, and optimize cloud-based ELT/ETL pipelines.
  • Migrate legacy SAS logic to CDI and target data models.
  • Ensure data fidelity, validation, and performance optimization.
  • Coordinate with governance and security teams for compliance.

Skills

Informatica CDI
SQL
Data Warehousing
ETL/ELT design
Cloud data

Education

Bachelor's or Master's in Computer Science / IT / Data Engineering

Tools

Snowflake
BigQuery
AWS Redshift
Databricks
SAS

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer - CDI & SAS Modernization Architect
Senior Data Engineer - CDI & SAS Modernization Architect

NucleusTeq • Indiana

On-site
USD 120,000 - 160,000
Lead Data Engineer
Lead Data Engineer

Experion Technologies Pvt. Ltd. • United States

On-site
USD 120,000 - 160,000
Imformatica Lead
Imformatica Lead

Diligent Tec, Inc • Santa Ana (CA)

On-site
USD 110,000 - 160,000
Data Engineer 3 (Mid-Level)
Data Engineer 3 (Mid-Level)

Uncomn • Shiloh (IL)

On-site
USD 120,000 - 160,000
Instant Flexible PTO
Generous Holidays
Immediate Health Coverage
+3
AI-Driven Cloud ETL Migration Engineer
AI-Driven Cloud ETL Migration Engineer

Compunnel Inc. • Texas

On-site
USD 90,000 - 120,000
ETL Migration Engineer
ETL Migration Engineer

Compunnel Inc. • Texas

On-site
USD 90,000 - 120,000
Senior Data Engineer (IICS)
Senior Data Engineer (IICS)

Strategio Inc. • McLean (VA)

On-site
USD 100,000 - 130,000
Data Engineering Lead
Data Engineering Lead

Ignite IT, LLC • Suitland (MD)

On-site
USD 130,000 - 150,000
IICS Lead
IICS Lead

TechDigital Group • Frisco (TX)

On-site
USD 80,000 - 120,000
ETL Data Migration Lead
ETL Data Migration Lead

Valiant Technologies LLC • New Jersey

On-site
USD 150,000 - 230,000