Data Engineer


  • Chandigarh, India
Data Engineer
Job Posted : Jun 26th, 2021

Job Description

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


  • 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.”