Create a Job Alert.

Enter your email below to save this search and receive job recommendations for similar positions.
Thank you. We'll send jobs matching these to
You already suscribed to this job alert.
GB
0 suggestions are available, use up and down arrow to navigate them
IN

DW Data Engineer job in Chandigarh at Emerson

Create Job Alert.

Get similar jobs sent to your email

Apply to this job.
Think you're the perfect candidate?
Apply on company site
DW Data Engineer at Emerson

DW Data Engineer

Emerson Chandigarh/Chandigarh, Chandigarh Full Time
Apply on company site

Data Warehouse Developer/ Analyst

Job Summary:

Designing, developing, implementing, and maintaining a data warehouse to collate and integrate current/historical data from various sources/systems within an organization

The position is responsible for designing, implementation and development and maintenance of Enterprise Data Warehouse. 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 Enterprise Data Warehouse.

Responsibilities: 

  • Designing, developing, implementing, and maintaining a data warehouse to collate and integrate current/historical data from various sources/systems within an organization
  • Implementing procedures for maintenance, monitoring, backup, and recovery for the data warehouse and related systems
  • Expertise in Dimensional Modelling (using Star / Snowflake schema) and drafting High Level and Low Level DWH Design
  • Conducting research into new data warehouse applications and determining viability for adoption
  • Gathering and analysing data requirements and data flows to other systems
  • Developing physical data models to define the database structure
  • Optimizing database & ETL performance through efficient Performance Tuning techniques
  • Expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs.
  • Developing data architecture and logical and physical data models
  • Developing strategies for data acquisition, archive recovery, and database implementation
  • Experience of automating various ETL jobs, failure notification etc
  • Managing data migrations/conversions and troubleshooting data processing issues
  • Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
  • Preparing data verification and testing methods for data/applications loaded into the warehouse to ensure compatibility across different sources

Required Skills and Experience:  

  • 5 years of relevant experience working in Data Warehousing , Data Modelling and ETL
  • Proficient in OBIA using ODI in BIAPPS environment.
  • Exposure to working in other ETL tools like SSIS, Informatica, Synapse
  • 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



Data Warehouse Developer/ Analyst

Job Summary:

Designing, developing, implementing, and maintaining a data warehouse to collate and integrate current/historical data from various sources/systems within an organization

The position is responsible for designing, implementation and development and maintenance of Enterprise Data Warehouse. 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 Enterprise Data Warehouse.

Responsibilities: 

  • Designing, developing, implementing, and maintaining a data warehouse to collate and integrate current/historical data from various sources/systems within an organization
  • Implementing procedures for maintenance, monitoring, backup, and recovery for the data warehouse and related systems
  • Expertise in Dimensional Modelling (using Star / Snowflake schema) and drafting High Level and Low Level DWH Design
  • Conducting research into new data warehouse applications and determining viability for adoption
  • Gathering and analysing data requirements and data flows to other systems
  • Developing physical data models to define the database structure
  • Optimizing database & ETL performance through efficient Performance Tuning techniques
  • Expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs.
  • Developing data architecture and logical and physical data models
  • Developing strategies for data acquisition, archive recovery, and database implementation
  • Experience of automating various ETL jobs, failure notification etc
  • Managing data migrations/conversions and troubleshooting data processing issues
  • Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
  • Preparing data verification and testing methods for data/applications loaded into the warehouse to ensure compatibility across different sources

Required Skills and Experience:  

  • 5 years of relevant experience working in Data Warehousing , Data Modelling and ETL
  • Proficient in OBIA using ODI in BIAPPS environment.
  • Exposure to working in other ETL tools like SSIS, Informatica, Synapse
  • 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



20191014-1001 
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.” 
Our Automation Solutions business enables the greatest use of the world's most valuable resources, ensuring the performance and safety of industries that are the backbone of daily life.
Our Commercial & Residential Solutions business helps ensure human comfort and health, protect food quality and safety, advance energy efficiency and create sustainable infrastructure.
No calls or agencies please. 
 

Recommended Skills

Extract Transform Load (Etl)
Data Warehousing
Extract Transform And Load (Etl)
Data Modeling
Data Architecture
Business Intelligence

Recommended Jobs

DW Data Engineer
Emerson Chandigarh/Chandigarh Full Time
Data Engineer
Emerson Chandigarh Full-Time
Lead Data Engineer
Emerson Pune Full-Time
Apply to this job.
Think you're the perfect candidate?
Apply on company site

Job ID: 21007156