Business Analyst

Must Have:

• Experience in Cognos.
• Experience with ETL Mappings.

Skill Description:

• Experience in Cognos.
• Experience with ETL Mappings.
• 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