Position Name: Senior Technical Consultant-ODI
Location: Bangalore/Pune/Noida/Chennai
Shift Timings: UK Shift (1.00 PM to 10.00 PM)
Exp: Min 7 Years
Notice Period: Immediate to 15 days joiners only
Key Skills: ODI, Data Warehousing, ETL, Oracle, Performance Tuning, Oracle Database etc.
Job Description:
- Strong ODI ETL Developer.
- Strong understanding of Data warehouse concepts, Data Vault knowledge would be plus
- Extensive development experience in ODI to Extract/Load/Transform data from multiple sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files, JSON and XML Files into ODS and EDW (Enterprise Data Warehouse) systems
- Good at writing Procedures, triggers, Partitioning, tables, views in PL/SQL/Query Performance tuning, Hands on experience in Performance Tuning at all levels
- Experience and or knowledge of Agile Methodology is a plus.
- Flexible working hours as per Offshore/onsite model.
- Very good communication and documentation skills.
- Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modelling like Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, FACT and Dimensions Tables using Analysis Services.
- Should have some report tools experience.
- Work closely with PowerBI developer to understand the data requirements.
- Translate their ETL/ELT jobs/workflows, fix the data quality issues and transform the data based on the business rules.
- Having Oracle tech stack knowledge will be a big plus.