SAP BODS Data Engineer

Capgemini; Dubai; On-site; AED 150,000 - 200,000; Full time

Job summary

A global business and technology transformation partner seeks a skilled SAP BODS Data Engineer in Dubai. In this role, you will design, develop, and maintain ETL solutions using SAP BusinessObjects Data Services. You should have extensive knowledge of BODS, strong SQL capabilities, and the ability to collaborate with BI teams. This position offers opportunities to innovate and grow in a diverse and inclusive environment.

Qualifications

• In-depth knowledge of SAP BusinessObjects Data Services architecture.
• Expert in data flows, workflows, and advanced project organization.
• Proven ability to create, schedule, and troubleshoot batch jobs.
• Experience with Data Integrator and Platform Transforms.
• Capability to define and apply data quality transforms.
• Proficient in BODS scripting and variable handling.
• Skilled in data profiling and quality assessment.
• Experience designing error and exception handling processes.
• Strong command of SQL and query performance tuning.
• Familiarity with BI reporting solutions.
• Knowledge of ETL performance tuning techniques.
• Willingness to learn new tools and technologies.

Responsibilities

• Design, develop, and maintain ETL solutions using SAP BODS.
• Architect and optimize SAP BODS environments.
• Build robust data flows and workflows within BODS.
• Create, schedule, and troubleshoot batch jobs.
• Implement and monitor data quality transforms.
• Perform thorough data profiling and assessment.
• Design and implement error handling mechanisms.
• Develop and optimize complex SQL and Oracle queries.
• Collaborate with BI/reporting teams.

Skills

SAP BusinessObjects Data Services expertise

BODS Designer proficiency

Batch job management

Transformations knowledge

Data quality implementation

Scripting & functions

Data assessment skills

Error & exception handling

SQL / Oracle expertise

Reporting tools awareness

Performance optimization

Learning mindset

Education

Bachelor’s or Master’s in Computer Science, IT, Engineering

Tools

SAP BODS

Oracle databases

Job description

Overview

SAP BODS Data Engineer About the job you are considering

Choosing Capgemini means joining a company where you will be empowered to shape your career, be supported and inspired by a collaborative community of colleagues around the world, and reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Your Role

• Design, develop, and maintain ETL solutions using SAP BusinessObjects Data Services (BODS), ensuring best practices and industry standards are adhered to.
• Architect, configure, and optimize SAP BODS environments, including understanding system architecture, components, and project organization.
• Build robust data flows and workflows within BODS Designer, organizing projects for clarity, scalability, and maintainability.
• Create, schedule, and troubleshoot batch jobs to ensure timely and accurate data integration across multiple systems and sources.
• Leverage Data Integrator and Platform Transforms (lookup, merge, validation, etc.) to meet complex business and technical requirements.
• Implement and monitor data quality transforms, ensuring clean, reliable, and accurate data throughout the ETL lifecycle.
• Utilize functions, scripts, and variables within BODS for dynamic data manipulation and to support advanced transformation logic.
• Perform thorough data profiling and assessment to identify data issues, inconsistencies, and opportunities for data quality improvement.
• Design and implement robust error and exception handling mechanisms within ETL processes to ensure resilience and reliability.
• Develop and optimize complex SQL and Oracle queries, including views and stored procedures, ensuring efficient data extraction and transformation.
• Collaborate with BI / reporting teams, maintaining basic familiarity with reporting tools such as SAP BO, Tableau, or Power BI to support downstream analytics requirements.
• Apply performance tuning and optimization techniques to enhance ETL job efficiency, minimize runtime, and ensure scalability.
• Demonstrate a proactive approach to learning new technologies and cross-skilling across domains, contributing to a culture of continuous improvement within the team.

Your Skills and Experience

• Extensive SAP BODS Expertise: In-depth knowledge of SAP BusinessObjects Data Services, its architecture, and its components.
• BODS Designer Proficiency: Expert in data flows, workflows, and advanced project organization within BODS Designer.
• Batch Job Management: Proven ability to create, schedule, and troubleshoot batch jobs for high-volume data integration.
• Transformations Knowledge: Solid experience with Data Integrator and Platform Transforms such as lookup, merge, and validation transforms.
• Data Quality Implementation: Capability to define and apply data quality transforms to ensure data accuracy and reliability.
• Scripting & Functions: Proficient in BODS scripting, functions, and variable handling for dynamic ETL logic.
• Data Assessment Skills: Skilled in data profiling, data quality assessment, and remediation of identified data issues.
• Error & Exception Handling: Experience in designing resilient error and exception handling processes within ETL workflows.
• SQL / Oracle Expertise: Strong command of SQL and Oracle database concepts, query performance tuning, and complex stored procedure development.
• Reporting Tools Awareness: Familiarity with BI / reporting solutions (SAP BO, Tableau, Power BI) to understand integration requirements.
• Performance Optimization: Knowledge of ETL performance tuning techniques and experience in optimizing large-scale data flows.
• Learning Mindset: Demonstrated willingness to learn new tools and technologies, and ability to cross-skill as needed.
• Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or a related discipline.
• Certifications: Relevant certifications in SAP BODS and/or Oracle databases are an advantage.

Why you should consider Capgemini

Growing clients’ businesses while building a more sustainable, more inclusive future is a tough ask. When you join Capgemini, you’ll join a thriving company and be part of a diverse collective of free-thinkers, entrepreneurs and industry experts. We explore new ways technology can help us reimagine what’s possible. It’s why, together, we seek opportunities that will transform the world’s leading businesses, and it’s how you’ll gain the experiences and connections you need to shape your future. By learning from each other every day, sharing knowledge, and always pushing yourself to do better, you’ll build the skills you want. You’ll use your skills to help our clients leverage technology to innovate and grow their business. So, it might not always be easy, but making the world a better place rarely is.

About Capgemini

Capgemini is a global business and technology transformation partner, helping organizations accelerate their digital and sustainable transformation while delivering tangible impact for enterprises and society. It is a responsible and diverse group of over 340,000 team members in more than 50 countries. With a long-standing heritage, Capgemini is trusted by its clients to unlock the value of technology to address a broad range of business needs. It delivers end-to-end services and solutions—from strategy and design to engineering—driven by capabilities in AI, cloud, and data, combined with deep industry expertise and partner ecosystems. The Group reported 2023 global revenues of €[amount not specified].