YASH Technologies - ODI Consultant

Job Summary :

Provide prompt and effective support, maintenance and development on OBIA based Analytics Datawarehouse using Oracle Data Integrator ODI as underlying ETL Tool. The position is responsible for implementation and development and maintenance of ODI environment.

The requirements of the position include Data warehouse design, Dimensional Modelling, Datawarehouse Maintenance, ETL Development & Support and ETL performance tuning.

Roles And Responsibilities :

• Candidate will be responsible to provide solution design, implementation, migration and support in Oracle BI Tool stack especially ODI and SQL.
• ODI development (in OBIA Environment), enhancements and support would be the primary responsibility along with performance tuning of SQL programs.
• Data warehouse design, development and maintenance using Star Schema (Dimensional Modelling)
• Production Support of Daily running ETL loads, monitoring, troubleshooting failures and bug fixing across environments
• Experience of working in Oracle BI Analytics Warehouse Methodology & Star Schema with good understanding of CM, SDE, SIL, PLP, Knowledge Modules, Load Tracking tables, Metadata etc
• Experience on working with different data sources Oracle, CRM, Cloud, Flat Files, Sharepoint and other non-oracle systems
• Experience in performance tuning of mappings in ODI and SQL query tuning.
• Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
• Migration and other deployment activities in Oracle BI tool stack(ODI), Kintana and PVCS
• Working knowledge of OBIEE
• Must have strong Oracle database experience including complex SQL, query debug and optimization
• Should have strong understanding in BI / data warehouse analysis, design, development & test experience
• Strong understanding of Change Management Processes and basic understanding of SBM and ServiceNow

Required Skills And Experience :

Required Qualification : Tech / MCA

Required Competencies :

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

(ref : hirist.tech)