DescriptionJob 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 implementationsprimarily Oracle EBS and SAP ECCby 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 perspectivesbecause 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
Required Experience:
Senior IC