Analyst- ETL Administration

Job Description

Job Title:  Analyst - ETL Administration # 072269


If you desire to be part of something special, to be part of a winning team, to be part of a fun team - winning is fun.


We are looking forward to an Analyst – ETL Administration in Eaton’s India Technology Center, based in Pune, India.


In Eaton, making our work exciting, engaging, meaningful; ensuring safety, health, wellness; and being a model of inclusion & diversity are already embedded in who we are - it’s in our values, part of our vision, and our clearly defined aspirational goals.


This exciting role works within Integration Platform and Architecture (IPA) COE and alongside other IT COEs as well as business and functional leadership to provide end to end support for all ETL processes and systems.

 

Your essential responsibilities:

  • Responsible for all aspects of ETL integration administration, provide end to end administration for all ETL processes and systems. Function as a primary point of contact for any ETL admin requests.

  • Develop and maintain ETL administration processes and documentation. Maintain the integrity of the ETL environments.

  • Provide specialized ETL support to multiple Enterprise applications and projects utilizing Extract, Transform & Load (ETL) technologies.  

  • Manage ETL Admin Remedy queue and provide quick Incident/Request analysis to Business users.

  • Coordinate with ETL architects and leverage DAC for task scheduling, workflow management and maintenance activities.

  • Support OBIEE release go live 

  • Collaborate with application owners to address any ETL platform issues

  • Responsible for administration of ETL integration applications including Informatica, DAC, Kalido, Oracle OBIA

  • Conduct ETL optimization, troubleshooting and debugging.

  • Conduct troubleshooting for production issues related to Informatica and DAC administration

  • Participate in problem management and performance tuning activities

  • Collaborate, build and maintain relationships with other technical groups. Initiate continuous improvement initiatives within the team and Enterprise

  • Report regularly on health and performance of ETL environment and jobs


Qualifications

If you have:

  • Experience on Data Warehouse Administration Console (DAC) and OBIA

  • Good understanding of OBAW architecture  

  • Experience in configuring and maintaining Oracle Business Intelligence system and troubleshooting issues

  • Experience in OBAW data model &performance tuning

  • Hands on experience on Informatica and Troubleshooting experience on Informatica 9 and above.

  • Significant experience in supporting systems that have involved data acquisition, data extracts/loads, data interfaces between systems

  • Experience of working with large data sets and multi-million row database structures

  • Expertise of BI concepts including ETL, data warehousing, reporting and related tools

  • Understanding of ETL architecture, design, development and implementation principles across Enterprise platforms

  • Understanding of the use of BI and Analytics in one or more Enterprise Functions

  • Hands-on experience with performance tuning ETL and PL SQL code

  • Good Oracle / PL SQL/ UNIX & Unix scripting knowledge

  • Ability to solve problems independently, quickly, and completely, and to communicate clearly to management and peers

  • Knowledge of ITSM/ITIL, various Business Processes embedded across an Enterprise

  • B.E. / B.Tech. / MCA with minimum 4 years of relevant experience of which minimum 2 years of experience working with global teams

Yes! Because you are the one we are looking for, we hope to hear from you now!


*We make what matters work.

Making what matters work at Eaton takes the passion of every employee around the world. We create an environment where creativity, invention and discovery become reality, each and every day.

It’s where bold, bright professionals like you can reach your full potential - and where you can help us reach ours.  Need more about Eaton? Come on in @ www.eaton.com.


We make what matters work. Everywhere you look—from the technology and machinery that surrounds us, to the critical services and infrastructure that we depend on every day—you’ll find one thing in common. It all relies on power. That’s why Eaton is dedicated to improving people’s lives and the environment with power management technologies that are more reliable, efficient, safe and sustainable. Because this is what matters. We are confident we can deliver on this promise because of the attributes that our employees embody. We’re ethical, passionate, accountable, efficient, transparent and we’re committed to learning. These values enable us to tackle some of the toughest challenges on the planet, never losing sight of what matters.

Job: Information Technology

Region: Asia Pacific
Organization: Corporate Sector

Job Level: Individual Contributor
Schedule: Full-time
Is remote work (i.e. working from home or another Eaton facility) allowed for this position?: No
Does this position offer relocation?: Relocation from within hiring country only
Travel: No