Job Title:  T&T - ET&P - Analyst - SAP BODS - Gurugram

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)