Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
Worked extensively on different types of transformations like Query transformation, Merge, Case, Validations etc.
Implemented Change Data Capture Mechanism for different loading Strategies (Initial/Delta load) using Table Comparison, and Map Operation Transforms.
Scheduled the Batch as per the client requirement using BODS Management Console.
Extensively used ETL to load data from FILE FORMAT and from the relation database.
Created dynamic flat file Extraction by using variables and conditions.
Extracted data from different sources such as Flat files, Oracle to load into SQL Server
Implemented Recovery mechanism from previous failed job.
Optimized the Job Loading by implementing the Performance Techniques in the ETL flows.
Worked on Performance Tuning Techniques for long running jobs used techniques like source level, transform level and target level and pushing down operations to database level and by applying DOP dataflow level.
Good to have knowledge on SAP BO.
Should have minimum 5 years of experience in SAP BODS.