SAP BODS Developer

Full Time

10 am - 7 pm

Job Location: Nagpur / Pune / Remote
Job Type: Full Time

Responsibilities:

  • 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.

Required Skills:

  • Should have minimum 5 years of experience in SAP BODS.
  • Should have hands on experience on SQL
  • Required basic knowledge on SAP HANA.