Dec 2017 – Dec 2021 · 4 yrs · Hyderabad, Telangana, India · Remote

• Designed and developed ETL processes using SAP BODS to extract data from multiple source systems including SAP ERP, Oracle, and SQL Server databases.
• Implemented complex transformations and business rules to cleanse, enrich, and transform raw data into a format suitable for loading into the target data warehouse.
• Worked closely with business users to understand data requirements and translate them into technical specifications for ETL development.
• Have performed data load using Idocs/BAPI from BODS and Migration Cockpit and MDG.
• Extensively worked in Extraction, Transformation and Loading of data from multiple sources (Relational and Non-Relational) into Data Warehouse/Data Migration.
• Experience in developing ETL mappings and reusable Data Flows, Workflows and Jobs in BODS tool using various transformations like Query, Map Operation, Table Comparison, History Preserving, Validation, Merge, Case etc.
• Experience in writing SQL queries.
• Extensive SQL experience with relational databases (SQL Server 2016/2020, Oracle 9i/10g, HANA).
• Experienced in Unit testing and Integration Testing with excellent debugging skills. Created/simulated ETL test data for ETL mapping rules to test the functionality of the BODS Data flows/Business requirements.
• Worked on various data formats / file types like tables, CSV files, Excel files and Flat Files to extract and load into target tables.
• Optimized ETL workflows and data loading processes to improve performance and reduce overall processing time.
• Integrated SAP BODS with data extraction, transformation, and loading.
• Implemented data quality checks and validations to ensure data accuracy and consistency across different systems.
• Provided production support and troubleshooting for SAP BODS jobs, resolving issues in a timely manner to minimize business impact.
• Conducted training sessions for end users to familiarize them with SAP BODS functionalities and best practices.