Senior ETL Developer - Oracle Emerson Climate Technologies Inc

8.0 - 10.0 years

0 Lacs

chandigarh, india

On-site

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 partof 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 At Emerson, we prioritize a workplace where every employee is valued, respected, and empowered to grow. We foster an environment that encourages innovation, collaboration, and diverse perspectives-because we know that great ideas come from great teams. Our commitment to ongoing career development and growing an inclusive culture ensures you have the support to thrive. Whether through mentorship, training, or leadership opportunities, we invest in your success so you can make a lasting impact. We believe diverse teams, working together are key to driving growth and delivering business results. We recognize the importance of employee wellbeing. We prioritize providing competitive benefits plans, a variety of medical insurance plans, Employee Assistance Program, employee resource groups, recognition, and much more. Our culture offers flexible time off plans, including paid parental leave (maternal and paternal), vacation and holiday leave.

Posted 23 hours ago

Apply

ODI & DB Senior Developer Acesoft Labs

6.0 - 8.0 years

15 - 18 Lacs

bengaluru

Hybrid

Hi all, Were Hiring: ODI & DB Senior Developer Location: Bangalore (Hybrid/Remote) Experience: 68 Years Notice Period: Immediate 15 Days Email: mojesh.p@acesoftlabs.com Call: +91 9701971793 Were seeking a skilled ODI & Database Senior Developer to join our team supporting Sony Electronics’ Online Marketing Applications in the EU region. The ideal candidate will have deep expertise in ODI, database migration, SQL, and DB administration . Mandatory Skills: ODI Development Database Migration SQL (MSSQL, Oracle, PostgreSQL) Database Administration Key Responsibilities: Write and debug complex PL/SQL procedures across MSSQL, Oracle, and Postgres. Construct and deconstruct complex SQL queries and reports . Modify and maintain PowerShell scripts . Tune performance of mappings, handle errors, and troubleshoot issues. Migrate ODI objects and manage files, MSSQL DB, and XMLs through ODI. Develop Load Plans , schedule jobs, and integrate ODI with multiple sources and targets. Perform data modeling using dimensional, star/snowflake schema, fact/dimension tables. Work independently on assigned tasks with minimal supervision. Collaborate effectively in a deadline-driven, multi-priority environment . Professional Skills: Strong verbal and written communication Detail-oriented problem solver Team player with a sense of ownership and accountability Apply Now! Send your CV to mojesh.p@acesoftlabs.com or call +91 9701971793 .

Posted Date not available

Apply

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.