Translate SAP BODS/SSIS ETL logic into Azure Data Factory pipelines, design and optimize SQL/stored procedures, perform testing and migration from BODS to ADF, troubleshoot data integration issues, ensure monitoring/logging, and mentor junior developers while collaborating with onshore/offshore stakeholders.
Key Responsibilities
- Analyze existing SAP BODS jobs and job definitions and translate them into ADF pipeline designs
- Design, develop, test, and deploy Azure Data Factory pipelines following best practices
- Lead migration activities from BODS to ADF, ensuring functional parity and performance optimization
- Develop and optimize SQL queries and stored procedures to support ADF pipelines
- Work closely with architects, data analysts, and downstream consumers to understand data transformation logic
- Apply a strong analytical mindset to troubleshoot complex data integration issues
- Perform unit testing, integration testing, and support UAT activities
- Ensure proper error handling, logging, monitoring, and performance tuning in ADF
- Provide technical guidance and mentoring to junior developers (if applicable)
- Contribute to documentation, knowledge transfer, and handover activities
- Collaborate with onshore/offshore teams and stakeholders across time zones
- Azure Data Factory (ADF)
- Hands-on experience building complex ADF pipelines
- Strong understanding of activities, datasets, linked services, triggers, and integration runtimes
- Analytical Mindset
- Proven ability to analyze legacy ETL logic and translate it into modern cloud-based solutions
- SSIS
- Strong SSIS development and migration experience
- Ability to map SSIS/BODS logic to ADF patterns
- SQL
- Advanced SQL skills for data transformation, validation, and performance tuning
- Stored Procedures
- Strong experience in designing, developing, and optimizing stored procedures
- Python
- Experience using Python for data processing, automation, or orchestration
- SAP BODS (Business Objects Data Services)
- Prior hands-on experience developing or maintaining BODS jobs
- Understanding of BODS workflows, dataflows, and transformations
- 8–12 years of overall experience in Data Integration / ETL / Data Engineering
- Strong experience working on large-scale migration or decommissioning programs
- Experience in enterprise data platforms and complex data landscapes
- Ability to work independently with minimal supervision
- Strong communication and stakeholder management skills
- Experience working in Agile / Iterative delivery models preferred
Sr. Azure Data Engineer with SAP BODS experience
QualificationsSr. Azure Data Engineer with SAP BODS experience
About UsAt 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.
Top Skills
Azure Data Factory (Adf)
Python
Sap Bods
SQL
Ssis
Stored Procedures
Similar Jobs
App development
The Azure DevOps Engineer will design and maintain CI/CD pipelines, automate deployments, manage Azure resources, and troubleshoot issues while collaborating with architecture and development teams.
Top Skills:
AzureAzure CliGitMicrosoft FabricPowershellTerraform
App development
Design, build, test, and deploy Azure Data Factory pipelines; analyze and translate SAP BODS/SSIS ETL into ADF; develop and optimize SQL and stored procedures; perform testing, monitoring, and performance tuning; lead migrations, collaborate across teams, and mentor junior developers.
Top Skills:
Azure Data FactoryPythonSap BodsSQLSsis
App development
Lead cloud data engineering and architecture initiatives focused on Azure. Design and implement scalable, secure, AI-ready enterprise data platforms, guiding cloud data strategy and best practices.
Top Skills:
Azure
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
