NucleusTeq Benefits Overview

Analyze legacy SAS Data Integration pipelines, workflows, transformations, dependencies, and generated code. Create technical specifications, source-to-target mappings, data lineage, and migration documentation. Collaborate with business and data engineering teams to assess migration challenges, support planning, and validate migrated pipelines through data comparison and reconciliation. The role requires strong SAS DI Studio, SAS programming, SQL, ETL, analytical, problem-solving, and technical documentation skills.

Lead the migration of legacy SAS workflows to cloud-native Informatica CDI architectures. Design, build, deploy, and optimize ETL/ELT pipelines, mappings, taskflows, and data warehouse integrations. Analyze SAS code and translate business logic into CDI and SQL, while developing reconciliation, regression testing, governance, lineage, masking, and compliance processes. Manage Secure Agents and scheduling integrations, optimize pushdown execution, and mentor engineers through technical reviews and modernization delivery.

Design, build, and maintain automated testing frameworks for large-scale data platforms and web applications. Validate ETL/ELT pipelines, data transformations, data quality, schema migrations, APIs, databases, and user workflows. Develop Java and Python automation using Selenium, Cucumber, and Pytest; write advanced SQL for data reconciliation; integrate tests into CI/CD pipelines; and manage defects through root cause analysis and issue tracking.