Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home

Jobs

Home
>
Jobs in Chandigarh
>
Emerson
>
Senior ETL Developer - Oracle

Senior ETL Developer - Oracle

Emerson

9 - 12 years

20 - 25 Lacs

Chandigarh

Posted:2 days ago| Platform:

Apply

Skills Required

Computer science Performance tuning Career development Production support MIS Business analytics Schema Medical insurance Troubleshooting Monitoring

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Summary

If you are looking for an opportunity in Technology Solutions and Development, Emerson has this exciting role for you! The Senior ETL Developer - Oracle will be part of team of individuals whose responsibility is to develop ETL programs and to improve the performance of poorly written or poorly performing applications code in Oracle Data Integrator tool. This will include existing code and new code which have not yet been promoted to production. This team delivers technology solutions for strategic business needs, drives adoption of these services and support processes and boosts value by enhancing our customers experience. This role work along a hardworking and dedicated team of self-motivated professionals who share a collective passion for progress and excellence.

In this Role, Your Responsibilities Will Be:

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

Who You Are:

You show a tremendous amount of initiative in tough situations; are exceptional at spotting and seizing opportunities. You observe situational and group dynamics and select best-fit approach. You make implementation plans that allocate resources precisely. You pursue everything with energy, drive, and the need to finish.

For This Role, You Will Need:

8+ 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.

Preferred Qualifications that Set You Apart:

Bachelor s degree or equivalent in Science with a technical background (MIS, Computer Science, Engineering or any related field)
Good interpersonal skills using English, both spoken and written, as will be working with overseas team

Our Culture & Commitment to You

More Jobs at Emerson

Senior Engineer/ Assistant Manager - Instruments

Greater Kolkata Area

5 - 8 yrs

Salary: Not disclosed

Senior Executive/ Assistant Manager - Stores

Chennai, Tamil Nadu, India

5 - 8 yrs

Salary: Not disclosed

Assistant Manager - Mechanical

Pune

5 - 10 yrs

INR 22 - 27 Lacs

Manager / Senior Manager - Human Resources

Chennai

12 - 15 yrs

INR 15 - 20 Lacs

Order Administrator

Chennai, Tamil Nadu

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Emerson

Industrial Automation

St. Louis

87,500 Employees

847 Jobs

Key People

Lal Karsanbhai

President and Chief Executive Officer
Sanjay Bhatnagar

Senior Vice President
Bob Sharp

Executive President

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Senior ETL Developer - Oracle