SAP BODS Developer jobs in Gurgaon at Client of Teamlease

Designation - SAP BODS Developer

Job description

Responsibilities:

Deploys code across Dev, QA and Production environments using central repositories

Develops/Maintains/Supports new and existing data flows from multiple source systems

Develops/Maintains/Supports business rules and process around data cleansing, consolidation and validation, etc.

Troubleshoots/debugs ETL and SQL query issues and provides solutions

Develop views and ad hoc/scheduled SQL queries to analyze data, produce exception reports, validate data and as required by the functional team

Creates ETL solutions using data warehouse design best practices, such as Star-Schema design and Change Data Capture, etc.

Assists in the design and creation of logical and physical data models for reporting databases

Produces data flow diagrams and other documentations and diagrams as needed

Works with Director and Project Manager to develop and follow project plans and resource estimates. Works with Reporting team and data integration team to define and develop user data requirements

Integrates, collaborates and leads projects, working hand in hand with Business Analysts, Data Warehouse team and DBA and the infrastructure team

Works with functional team to assist in the preparation of source to target data maps. Work with project team and collaborate with both reporting application developers and OLTP technical leads.

Assists in gathering/reviewing business requirements, partnering with business analysts, providing feedback on functional request feasibility and scope

Technical experience with all of the SAP BODS application modules (Extract, Transform, Load)

Perform data load activities for each mock load, cutover simulation and production deployment identified in L1 plan into environments identified.

Provide technical support, defect management, and issue resolution during all testing cycles, including Mock Data Load cycles.

Complete all necessary data migration documentation necessary to support system validation / compliance requirements.

Support the development of unit and end-to-end data migration test plans and test scripts (including testing for data extraction, transformation, data loading, and data validation).

Experience in BODS Designer Components- Projects, Jobs, Workflow, Data Flow, Scripts, Data Stores and Formats.

Experience in BODS performance tuning techniques using parallel processing (Degree of Parallelism),Multithreading, Partitioning, and Database Throughputs to improve job performance

Experience with SQL and SQL Scripting

HANA, Oracle Databases

Understanding technical specs for ETL

Understanding of integration points and the order of their execution

Profiling various information systems, capture source/target mappings and transformations based on project requirements

Designing complex SAP Data Services job flows to extract from/load to systems such as HANA and Oracle

Experience with SAP BODS transforms such as Query, Validation, Merge, Case transforms

Tuning jobs for high volume and complex transformation scenarios

Configuring BODS components

Good communication skills

Must have hands on experience with SAP HANA (Installations, troubleshooting, upgrades/migrations)