SAP BODS (PAN India)

Greetings from TATA CONSULTANCY SERVICES LIMITED !!!

Role– SAP BODS

Experience Range-

Work Location –

SKILLS REQUIRED:

• Strong SAP BODS development experience
• 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

• Produces Source to Target mapping templates for ETL Flows.

• Perform and document Unit testing, support Integration and UAT.

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

• Works on building Change Data Capture/Delta logic using Table comparison Transofrmation.

• Experience on using complex transformations to build ETL flows.

• 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