Job Title

Greetings from TATA CONSULTANCY SERVICES LIMITED !!!Role– SAP BODSExperience Range-4to 8 yearsWork Location –Anywhere in IndiaSKILLS 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