ODI Data Engineer

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

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

ODI Data Engineer

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 designing, implementation and development and maintenance of ODI environment. The requirements of the position include Datawarehouse Maintenance, ETL Development & Support, performance tuning and expertise in dimensional modelling and design

Roles and Responsibilities:

Candidate will be responsible to design end to end solutions to cater to business needs of data in Oracle BI Tool stack especially ODI and SQL.

Responsibilities:

• Expertise in designing custom Data warehouse solutions specific to business needs.
• Expertise in Dimensional Modelling (using Star / Snowflake schema) and drafting High Level and Low Level DWH Design
• Expertise in preparing Data lineage sheets.
• Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
• Expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs.
• Experience of automating various ETL jobs, failure notification etc
• Ability to review and suggest DWH Design optimization solutions.
• Expertise in performance tuning of mappings in ODI and SQL query tuning.
• Production Support of Daily running ETL loads, monitoring, troubleshooting failures and bug fixing across environments
• Expertise in Multiple databases (Oracle/ SQL Server/etc) including complex SQL, query debug and optimization
• Should have strong understanding of Business Analytics, data warehouse analysis, design, development & testing.
• Strong understanding of Change Management Processes and basic understanding of SBM and ServiceNow

Required Skills and Experience:

• 5+ years of relevant experience working in OBIA on ODI as the ETL tool in BIAPPS environment.
• Exposure to working in other ETL tools.
• Ability to work on highly complex problems and provide feasible solutions in time.
• Ability to review and suggest improvements in existing DWH solution.
• Ability to work in a demanding user environment.
• Ability to provide trainings on ETL, DWH and Dimensional modelling.
• Ability to guide and help team members in technical issues.
• Strong Written and Oral communication skills.
• 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:

• Ensure Accountability
• Customer Focus
• Manages Complexity
• Plans and aligns
• Manages Ambiguity
• Optimizes Work Processes

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.

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