SAP BODS Data Engineer | Dubai, UAE

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

Job summary

A global technology firm in Dubai is seeking an experienced professional to design and maintain ETL solutions using SAP BusinessObjects Data Services (BODS). The ideal candidate will have extensive experience with data integration, batch job management, and a strong command of SQL and Oracle. Join a diverse community and help clients innovate and grow their businesses through technology.

Qualifications

• In-depth knowledge of SAP BusinessObjects Data Services and its core components.
• Expert in data flows and advanced project organization within BODS Designer.
• Proven ability to create, schedule, and troubleshoot batch jobs.

Responsibilities

• Design, develop, and maintain ETL solutions using SAP BODS.
• Architect, configure, and optimize SAP BODS environments.
• Create, schedule, and troubleshoot batch jobs for data integration.

Skills

Extensive SAP BODS 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 degree in Computer Science, Information Technology, Engineering

Tools

SAP BusinessObjects Data Services

SQL

Oracle

Tableau

Power BI

Job description

About the job you are considering

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to 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 core 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.
• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline.
• 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 become part of a diverse collective of free-thinkers, entrepreneurs and industry experts. We find new ways technology can help us reimagine what's possible. It's why, together, we seek out 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 to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion.

#GetTheFutureYouWant | www.capgemini.com

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.