Pipeline build · iBuy automation · Scorecard orchestration · DQ & audit
Technology skills
Azure ADF, SSIS, SQL Server, Logic Apps, Azure Monitor / alerting, MS Access Knowledge
Role & responsibilities
- Migrates SSIS packages to ADF, builds iBuy ingestion pipelines (SFTP / ODBC), and automates Scorecard load processes — replacing all MS Access macros and Windows Scheduler dependencies with ADF orchestration.
- Implements the DQ framework (PK checks, null validation, deduplication, reject handling) and establishes the audit layer (row counts, hash totals, source-to-target traceability) with automated stakeholder alerting.
Expectation from role
- Must have hands-on experience migrating SSIS packages to ADF and building production-grade pipelines with dependency management, scheduling and error handling.
- Expected to deliver working, tested pipelines with minimal handholding; strong T-SQL and ADF debugging skills are essential as legacy code will be
