Responsible for analysis, requirements gathering, documentation of functional/technical specifications, development and testing.
Troubleshoot and validate existing Reports/ETL generated SQL and write new SQL Stored procedure, shell script utility to validate the test data provided by ERP source system/ ETL solutions.
Creating new data modeling solution to rectify the existing problem by creating new tables, new partitions, Indexes, Stored Procedures, Functions, Packages, ETL jobs, ETL/Reports as per business need.
Responsible for the end to end delivery of project(s) from data analysis side.
Support the business user during UAT testing, Integration testing, and Production rollout testing, help business user after production rollout for data validations & performance testing.
Find and build process improvement solutions. Provide new innovation ideas/solutions to automate most of manual tasks.
To coordinate between different teams i.e. Business, Development, DBA, ETL architect teams.
To provide weekly/daily updates to the client on the status/health of Project(s).
In short, Responsible for the delivery of project(s).
Use SQL queries to get data from ERP data sources in order to facilitate the discussion with business and also with the development team for Data triaging
Develop test plan / cases using data dictionary/mapping documents to validate data integrity, data transformation covering mapping, transformations and business rules