SAP BODS Consultant 102927

Role : SAP BODS Consultant

Location : Bengaluru, Karnataka

Experience : 9 years

Job Description for BODS Consultant :

As a BODS Consultant for data migration from a legacy system to SAP S / 4HANA IS-U, your key responsibilities will revolve around the extraction, transformation, loading, fallout reports, reconciliation, and data cleansing processes. The position requires expertise in employing SAP BusinessObjects Data Services (BODS) as the ETL tool to ensure efficient and accurate data migration.

Key Responsibilities : -

• Extraction :
• Utilize SAP BODS to extract data from various sources, including databases and spreadsheets
• Create and configure data stores and file formats necessary for connecting to source systems
• Transformation :
• Perform data transformations utilizing SAP BODS, employing various components like Query Transform, Table Comparison, Pivot, Reverse Pivot, and Address Cleanse for data quality and cleansing.
• Develop transformation rules and mappings to align legacy data structures with SAP S / 4HANA IS-U requirements.
• Load :
• Implement data loading strategies that may include direct loads or sending IDOCs to the SAP system, ensuring adherence to SAP Best Practices.
• Set up IDOC configurations such as Logical Systems, RFC Destination, RFC Port, and Partner Profiles for smooth integration.
• Fallout Reports & Reconciliation :
• Generate fallout reports to identify and address data migration errors, facilitating reconciliation with business stakeholders.
• Employ SAP BODS for validating, enriching, and reconciling migrated data to ensure completeness and accuracy.
• Data Cleansing :
• Engage in pre-load and post-load data validation processes to cleanse legacy data, removing inaccuracies, duplicate entries, and inconsistencies [4].
• Collaborate with business users to assess data quality and implement rules for data correction.

Qualifications : -

1. Strong proficiency in configuring SAP BODS ETL environments and establishing connectivity with source and target

2. Strong Oracle SQL / PL-SQL experience for usage of advanced functions and procedures

3. Experience in BODS Administration activities CMC server management, DB configuration and Repositories creation

4. Participate in Source to Target data mapping workshops and define transformation rules

5. Experience in writing ETL code for data extraction-transformation-Reconciliation

6. Plan and own data migration mock runs and perform defect analysis

Additional Skills (Optional) : -

Familiarity with SAP S / 4HANA IS-U configurations and integration processes.

Experience in generating reports and performing detailed reconciliations using BODS.

Thanks & Regards!

Puneet Kaur

(Technical Recruiter)

Email : puneet.kaur@mwidm.com

Phone : +91 7087580018