Sap Bods Consultant

Deloitte Shared Services India; Delhi Cantonment; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Deloitte Shared Services India in Delhi invites a skilled SAP BODS ETL Developer to design, build, and maintain scalable ETL pipelines. You will work across data sources and target warehouses, focusing on performance and data quality.

The role involves collaborating with data architects and business analysts, implementing data governance, and pre- and post-load validation, with a strong emphasis on SAP BODS proficiency and real-time data capabilities.

Qualifications

• Design, develop, and maintain ETL workflows using SAP BODS to extract, transform, and load data from various sources to data warehouses.
• Develop complex data integration solutions including batch and real-time data pipelines with data cleansing and validation.
• Customize SAP BODS jobs for performance improvements, including data flow optimization and parallel processing.

Responsibilities

• Design, develop, and maintain scalable ETL workflows and jobs using SAP BODS to extract, transform, and load data from various sources to target data warehouses.
• Develop complex data integration solutions, including batch and real-time data pipelines, incorporating data cleansing, validation, and error handling mechanisms.
• Customize and optimize SAP BODS jobs for performance improvements, including data flow optimization.
• Collaborate with data architects, business analysts, and functional consultants to translate business requirements into technical ETL solutions.
• Integrate SAP BODS with SAP and non-SAP systems using adapters, RFC, web services, APIs, and relational databases.
• Conduct thorough unit testing, performance tuning, and debugging of ETL jobs to ensure data quality, reliability, and consistency.
• Monitor and troubleshoot production ETL workflows and resolve data loading issues promptly to minimize downtime.
• Prepare and maintain technical documentation, including design documents, job specifications, and operational guides.
• Participate in data governance initiatives by implementing data quality rules and monitoring data lineage through SAP BODS.

Skills

SAP BODS

ETL/ELT

Data profiling

Data cleansing

Data migration

SQL scripting

SQL Server

Oracle

SAP ECC

SAP BW

Cloud databases

RFC/IDoc/Web services

Relational databases

Education

Graduate degree (Science or Engineering)

Tools

SAP Data Services Designer

SAP Data Services Administrator

Job description

The team

Enterprise technology must do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P

Your work profile

• Design, develop, and maintain scalable and efficient ETL workflows and jobs using SAP BODS to extract, transform, and load data from various sources to target data warehouses.
• Develop complex data integration solutions, including batch and real-time data pipelines, incorporating data cleansing, validation, and error handling mechanisms.
• Customize and optimize SAP BODS jobs for performance improvements, including data flow optimization and parallel processing.
• Collaborate with data architects, business analysts, and functional consultants to gather and translate business requirements into technical ETL solutions.
• Integrate SAP BODS with SAP and non-SAP systems using adapters, RFC, web services, APIs, and relational databases.
• Conduct thorough unit testing, performance tuning, and debugging of ETL jobs to ensure data quality, reliability, and consistency.
• Monitor and troubleshoot production ETL workflows and resolve data loading issues promptly to minimize downtime.
• Prepare and maintain technical documentation, including design documents, job specifications, and operational guides.
• Participate in data governance initiatives by implementing data quality rules and monitoring data lineage through SAP BODS.

Key skills required

• 1-3 years strong hands-on experience in SAP BusinessObjects Data Services (BODS) designing and developing ETL/ELT jobs.
• Expertise in data profiling, data transformation, data cleansing, and data migration using BODS.
• Proficiency in working with various source and target systems like SQL Server, Oracle, SAP ECC, SAP BW, and cloud databases.
• Sound knowledge of SAP Data Services Designer and Administrator tools and repository management.
• Experience with bulk data processing, real-time data integration, and capturing change data using SAP BODS.
• Understanding of SAP integration protocols including RFC, IDoc, BAPI, and web services is a plus.
• Knowledge of SQL scripting, query optimization, and relational databases (RDBMS).

Education: Graduate degree (Science or Engineering)