SAP BODS Consultant

Role : SAP BusinessObjects Data Services

Work Location : Kolkata

Years of experience : 6+ Years

Job Description :

Must Have Skills :

- Proficiency in SAP BusinessObjects Data Services.

- Strong understanding of data integration and transformation processes.

- Experience with ETL (Extract, Transform, Load) methodologies.

- Familiarity with database management systems and SQL.

- Ability to troubleshoot and resolve application issues effectively.

Roles & Responsibility :

- Strong SAP BODS development experience

- Strong Understanding of Dimensional modelling, Star/Snowflake Schemas.

- Deploys code across Dev 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

- Implementation experience of various SCD Types using BODS flows.

- Works on building Change Data Capture or computation of Delta by various methods.

- Works on building Change Data Capture/Delta logic using Hash MD5 Algorithm.

- Works on enabling CDC at source.

- Works with the 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

- Should have developed complex transformations/pipeline

- Experience in Sybase IQ, SQL Server or any other Cloud Database is required

- Strong in SQL & PL/SQL programming.