NucleusTeq

Data Engineer

• 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

Explore Senior Data Engineer – Informatica CDI, SAS Migration at NucleusTeq. Review requirements and application details.

Senior Data Engineer – Informatica CDI, SAS Migration

Engineer

• Review and analyze existing SAS Data Integration Studio jobs, workflows, and ETL pipelines
• Understand data processing logic, transformations, business rules, and dependencies
• Analyze SAS DI job flows and SAS-generated code to identify data movement and processing logic
• Document pipeline architecture, data flows, transformation logic, and dependencies
• Translate existing SAS DI logic into technical specifications for migration and redevelopment
• Prepare source-to-target mapping documents, transformation specifications, and data lineage documentation
• Identify upstream and downstream dependencies, data sources, target tables, and job scheduling requirements
• Collaborate with business analysts, data engineers, architects, and migration teams
• Identify gaps, redundancies, and potential migration challenges in legacy SAS pipelines
• Support migration planning, impact analysis, and technical assessment activities
• Assist in validating migrated data pipelines by comparing legacy and target outputs
• Ensure technical documentation is accurate, complete, and aligned with business requirements

Explore Senior SAS DI Migration Engineer at NucleusTeq. Review requirements and application details.

Senior SAS DI Migration Engineer

QA Engineer

• Design, implement, and maintain scalable test automation frameworks from scratch using Java and Python
• Formulate automated test suites to validate complex ETL pipelines, data transformations, data quality, data completeness, and schema migrations across distributed environments
• Automate functional, regression, and end-to-end user workflows using Selenium WebDriver integrated with BDD Cucumber
• Build and execute test suites using Pytest for data scripts, API services, and scheduled pipeline jobs
• Author advanced SQL queries to extract, reconcile, and validate high-volume data sets across relational databases, data warehouses, and data lakes
• Partner with product managers and data engineers to derive comprehensive test scenarios, edge cases, and acceptance criteria from functional requirements
• Integrate automated test suites into CI/CD pipelines such as Jenkins, GitHub Actions, and GitLab CI
• Identify, report, trace, and isolate defects using issue tracking tools such as JIRA, performing root cause analysis on pipeline or automation failures

Explore ETL, Big Data Tester at NucleusTeq. Review requirements and application details.

ETL, Big Data Tester

Software Engineer

• Design, build, and optimize end-to-end data pipelines using Informatica CDI, including mappings, mapping tasks, taskflows, and synchronization tasks
• Establish connections and ingest data from relational databases, cloud storage, APIs, and modern data warehouses
• Implement business logic using standard and advanced transformations, including Expression, Router, Aggregator, Joiner, Lookup, Normalizer, and SQL ELT pushdown
• Schedule and orchestrate workflows via CDI Taskflows and integrate with external job schedulers or CI/CD deployment pipelines where applicable
• Perform unit testing, resolve pipeline bottlenecks, and debug runtime errors or session logs
• Monitor production execution runs, optimize execution runtimes, and assist in root-cause analysis for failed jobs
• Support enterprise analytics and reporting ecosystems through cloud-native data pipelines

Explore Data Integration Developer – Informatica CDI at NucleusTeq. Review requirements and application details.

Open roles

Senior Data Engineer – Informatica CDI, SAS Migration

Senior SAS DI Migration Engineer

ETL, Big Data Tester

Data Integration Developer – Informatica CDI