SAP BODS Consultant

Job Description

Job Title: SAP BODS Consultant Location: Bangalore Experience: 3-5 Years Job Description: Design, develop, and maintain ETL workflows using SAP BODS to support data migration, integration, and transformation processes. Understand and develop BODS jobs based on complex requirements. Develop pre-load and post-load data reconciliation reports. Responsible for monitoring and reporting the data migration activities including setting up Data Migration Cockpit, Data reconciliation and support necessary Data cleansing / transformation. Work with various data sources and formats to extract, transform, and load (ETL) data into target systems. Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions. Use SAP Information Steward for data profiling, data quality monitoring, and scorecard creation. Develop and maintain SQL queries to manage, manipulate, and analyze data from different databases. Monitor and troubleshoot data loads, ensuring high performance and data accuracy. Perform data validation and quality checks to ensure data consistency and integrity across various systems. Document technical specifications, data flow diagrams, and process workflows for data integration solutions. Optimize ETL processes for performance, scalability, and efficiency. Collaborate with business stakeholders and data governance teams to enforce data quality standards and best practices. Regularly exposing data quality metrics via standard reporting mechanisms (for example, data quality scorecard or dashboard). Actively participate in the design and deployment of applications and data integration processes to ensure standards, controls and consistently high-quality data are implemented. Follow prescribed data quality methodologies to execute data quality improvement projects. Identify and quantify resources for data quality improvement projects. Design and support the development of changes to business processes. Identify and support the resolution of processes and behaviors that impact data quality. Publicize successes to further engage individuals at all levels of the organization. Key Responsibilites: Bachelors degree in a Business, Finance or IT discipline or equivalent experience 4 to 6 years of hands on experience in SAP BODS 4.x development and implementation. Experience in using SAP Information Steward 4.x for data profiling and quality monitoring. Should have hands-on experience in Data loading into SAP ECC and S4 system. Should have had experience with LSMW/LTMC/IDOC/BAPI. Strong proficiency in SQL for data querying, analysis, and troubleshooting. Solid understanding of data integration, data migration and data quality concepts and best practices. Strong analytical and problem-solving skills with attention to detail. Excellent communication skills to work effectively with cross-functional teams. Experience with SAP / SAP S4 business processes understanding. Strong Knowledge of Data Quality dimensions and approach to establish the Data Quality metrics / Scorecards. Experience with Data Quality rule mining Strong skills using MS Excel