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.
Didn’t find the job appropriate? Report this Job