Consultant - Oracle Data Integrator Job

At YASH, we re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

We are looking forward to hire Oracle Data Integrator - ODI Professionals in the following areas :

:

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.

Responsibilities:

• 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:

• 5-7+ years of relevant experience working in OBIA on ODI as the ETL tool in BIAPPS environment.


• Ability to work in a demanding user environment.


• Strong Written and Oral communication skills.


• Knowledge on Tools like Serena Business Manager and Service Now


• Knowledge on SDLC and change management process.


• Coordinating among various teams for day to day activity.


• Working with Project Managers for assistance in various project implementations.


• Designing and improving BI processes for Development and Change Management.


• Ready to work in 24*7 environments.


• Good team player

Required Qualification:

• B. Tech / MCA

Required Competencies:

• Tech Savvy


• Communicate Effectively


• Optimizes Work Processes


• Cultivate Innovation

Our Hyperlearning workplace is grounded upon four principles

• Flexible work arrangements, Free spirit, and emotional positivity


• Agile self-determination, trust, transparency, and open collaboration


• All Support needed for the realization of business goals,


• Stable employment with a great atmosphere and ethical corporate culture