Azure Data Engineer – Offshore 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

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself. We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.