Data Engineer

Provide prompt and effective support, maintenance and development on OBIA based Analytics Datawarehouse using Oracle Data Integrator – ODI as underlying ETL Tools

The position is responsible for designing, implementation and development and maintenance of ODI environment. The requirements of the position include Data warehouse Maintenance, ETL Development & Support, performance tuning and expertise in dimensional modelling and design

Roles and 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

Qualification And Experiences:-

• B.Tech / MCA
• 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.

Required Competencies:-

• Ready to work in 24*7 environments.
• Good team player
• Ensure Accountability
• Customer Focus
• Manages Complexity
• Plans and aligns
• Manages Ambiguity
• Optimizes Work Processes

Location:-

• Chandigarh, India.

Company Overview:-

Emerson, a Fortune 500 company with $16.8 billion in sales, more than 20 Innovation, Solutions & Engineering Centers, and 200 manufacturing locations worldwide, is committed to helping employees grow and thrive throughout their careers. We are innovators, question-askers and problem-solvers. We don’t settle for good enough or “This is the way it’s always been done.” Instead, we push ourselves and strive for the “never been done before.”