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 to 15 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