Senior ETL Data Analyst

Job Summary

As a key contributor to our ERP Transformation Services team, the Senior ETL Data Migration Analyst is responsible for owning the design, development, and execution of enterprise-wide data migration activities. This role is instrumental in the success of global ERP implementations—primarily Oracle EBS and SAP ECC—by ensuring consistent, auditable, and high-quality data migration processes using industry-standard tools and frameworks.

In This Role, Your Responsibilities Will Be:

Pre-Go-Live: Planning & Development

• Design and implement global data migration strategies for Oracle and SAP ERP projects.
• Develop ETL processes using Syniti DSP / SKP or an equivalent tool to support end-to-end migration.
• Collaborate with legacy system teams to extract and analyze source data.
• Build workflows for data profiling, cleansing, enrichment, and transformation.
• Ensure audit ability and traceability of migrated data, aligned with compliance and governance standards.

Go-Live & Cutover Execution

• Support mock loads, cutover rehearsals, and production data loads.
• Monitor data load progress and resolve issues related to performance, mapping, or data quality.
• Maintain a clear log of data migration actions and reconcile with source systems.

Post-Go-Live: Support & Stewardship

• Monitor data creation and updates to ensure business process integrity post go-live.
• Provide data extract/load services for ongoing master data maintenance.
• Contribute to legacy data archiving strategies, tools, and execution.

Tools, Documentation & Collaboration

• Maintain documentation of ETL procedures, technical specifications, and data lineage.
• Partner with implementation teams to translate business requirements into technical solutions.
• Contribute to the development and refinement of ETL frameworks and reusable components.

Travel Requirements

• Willingness to travel up to 20% for project needs, primarily during key implementation phases

Who You Are:

• You show a tremendous amount of initiative in tough situations; you are someone who has strong analytical and problem-solving skills. You are self-motivated, accountable, and proactive in learning and applying new technologies. You possess superb communication and collaboration across global teams.

For This Role, You Will Need:

• 12+ years of IT experience with a focus on ETL, data management, and ERP data migration.
• Strong hands-on experience with Oracle EBS or SAP ECC implementations.
• Proficiency in Syniti DSP, Informatica, Talend, or similar enterprise ETL tools.
• Proficient SQL skills; ability to write and optimize queries for large datasets.
• Demonstrable track record in data profiling, cleansing, and audit trail maintenance.
• Academic background in MCA / BE / BSC - Computer Science, Engineering, Information Systems, or Business Administration
• Proven Application development experience in .NET, ABAP, or scripting languages
• Familiarity with Data Migration implementations and data modeling principles.
• Knowledge of project management methodologies (Agile, PMP, etc.).

Performance Indicators

• Successful execution of data migration cutovers with minimal errors.
• Complete Data traceability and audit compliance from source to target.
• Timely delivery of ETL solutions and reports per project phases.
• Continuous improvement and reuse of ETL frameworks and standard processes.

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

WHY EMERSON 

Our Commitment to Our People

At Emerson, we are motivated by a spirit of collaboration that helps our diverse, multicultural teams across the world drive innovation that makes the world healthier, safer, smarter, and more sustainable. And we want you to join us in our bold aspiration.

We have built an engaged community of inquisitive, dedicated people who thrive knowing they are welcomed, trusted, celebrated, and empowered to solve the world’s most complex problems — for our customers, our communities, and the planet. You’ll contribute to this vital work while further developing your skills through our award-winning employee development programs. We are a proud corporate citizen in every city where we operate and are committed to our people, our communities, and the world at large. We take this responsibility seriously and strive to make a positive impact through every endeavor.

At Emerson, you’ll see firsthand that our people are at the center of everything we do. So, let’s go. Let’s think differently. Learn, collaborate, and grow. Seek opportunity. Push boundaries. Be empowered to make things better. Speed up to break through. Let’s go, together.

Accessibility Assistance or Accommodation

If you have a disability and are having difficulty accessing or using this website to apply for a position, please contact: idisability.administrator@emerson.com.

ABOUT EMERSON 

Emerson is a global leader in automation technology and software. Through our deep domain expertise and legacy of flawless execution, Emerson helps customers in critical industries like life sciences, energy, power and renewables, chemical and advanced factory automation operate more sustainably while improving productivity, energy security and reliability.

With global operations and a comprehensive portfolio of software and technology, we are helping companies implement digital transformation to measurably improve their operations, conserve valuable resources and enhance their safety.

We offer equitable opportunities, celebrate diversity, and embrace challenges with confidence that, together, we can make an impact across a broad spectrum of countries and industries. Whether you’re an established professional looking for a career change, an undergraduate student exploring possibilities, or a recent graduate with an advanced degree, you’ll find your chance to make a difference with Emerson. Join our team – let’s go!

No calls or agencies please.