AU Small Finance Bank - Product Manager - Data Warehouse

Required Competencies :

- Hands on experience in ODI, should have worked on packages, scenarios, mappings, variables.

- Should be well versed with Data Warehousing concepts like SCD, CDC, FACTS, DIMENSIONS, STAR SCHEMA, SNOWFLAKE SCHEMA etc.

- Experience with Oracle database SQL queries, stored procedure, functions etc.

- Should be well versed in Logical data model and Physical data model. 

- Should have experience on of source code management tools like git or svn.

- Should have good knowledge of SQL/PL-SQL and Shell scripting.

- Good communication skill and should be a good team player

- The flexibility to work outside of normal working hours to meet deadlines.  

Job Responsibilities : 

- Handling project management, maintaining business intelligence infrastructure, and providing support to business analysts and managers.

- Responsible for developing datawarehouse by understanding various systems architecture.

- Responsible for design, development, integration, performance tuning, rollout, support and optimization during implementation of data warehouse. 

- Debug complex SQL queries.

- Should have detailed understanding of SDLC and implementation during the project.

- Ability to manage customer expectations, proactively identify the risks and mitigate them before its occurrence.