Senior Data Engineer – Informatica CDI, SAS Migration

NucleusTeq

. Architect, design, develop, and deploy robust, scalable ELT/ETL pipelines using Informatica Cloud Data Integration .

Posted 11/9/2026full-timeIndore • IndiaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in architecting and deploying scalable ELT/ETL pipelines using Informatica Cloud Data Integration, with a strong focus on data integration, optimization, and compliance. Proficient in modern SQL and experienced in managing cloud data warehouses such as Snowflake and AWS Redshift.

Highest-signal resume keywords

Informatica Cloud Data Integration (IICS CDI)Advanced SQL ProficiencyData Engineering ExperienceLegacy SAS Analysis and ModernizationCloud Data Warehouse Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ELT/ETL Pipeline DevelopmentData Integration Components DesignSAS Code ReconstructionData Staging PatternsTaskflow CreationData Mapping OptimizationError Handling Best PracticesData Masking ImplementationJSON HandlingPython Scripting

Soft Skills

MentoringCollaborationCode Review

Tools & Technologies

SnowflakeAWS RedshiftGoogle Cloud BigQueryDatabricksControl-MAutosysIICS Secure Agents

Certifications & Qualifications

Informatica Cloud Data Integration Specialist Certification

Industry Keywords

Data GovernanceData QualityCompliance StandardsStar SchemaSnowflake SchemaSCD TypesData Re-platformingHistorical Data Reconciliation

Tech Stack

Tools & technologies

Amazon RedshiftAWSAzureBigQueryCloudETLInformaticaPythonSnowflakeSQL

About the role

Key responsibilities & impact

Architect, design, develop, and deploy robust, scalable ELT/ETL pipelines using Informatica Cloud Data Integration
Design modular data integration components, including Data Synchronization Tasks, Mapping Tasks, and Taskflows
Build low-latency, scalable pipelines connecting diverse sources to Snowflake, BigQuery, AWS Redshift, or Databricks
Establish best practices for parameterization, dynamic configuration, error handling, session logging, and alerting in IICS CDI
Analyze legacy SAS scripts, macros, data steps, and SQL procedures 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 parity between SAS and CDI outputs
Decommission obsolete SAS workflows and identify consolidation and performance optimization opportunities
Optimize CDI mappings and pushdown optimization to maximize processing efficiency on cloud warehouses
Manage IICS Secure Agents, runtime environments, and scheduling integrations such as Control-M, Autosys, or cloud-native schedulers
Partner with Data Governance, Security, and Quality teams to implement data masking, lineage tracking, and compliance standards
Mentor mid-level and junior engineers and conduct code and design reviews

Requirements

What you’ll need

4+ years of hands-on experience building complex mappings, hierarchical transformations, lookups, and taskflows in IICS CDI
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
Advanced SQL proficiency, including complex analytical functions, windowing, and subqueries
Hands-on experience with at least one modern cloud warehouse: Snowflake, AWS Redshift, Google Cloud BigQuery, or Azure Synapse/Databricks
Solid understanding of Star Schema, Snowflake Schema, SCD Types 1, 2, and 3, and data staging patterns
Proven record of participating in large-scale data re-platforming, validation, and historical data reconciliation
Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Engineering, or a related quantitative field, or equivalent practical experience
6+ years of overall data engineering/integration experience, with a proven focus on IICS CDI implementations and legacy ETL/code migrations
Official Informatica Cloud Data Integration Specialist Certification preferred
Python or Bash scripting capability preferred
Familiarity with CI/CD deployment pipelines for IICS artifacts preferred
Experience handling JSON, Parquet, Avro, and XML within CDI preferred