As an integral part of the Autosol IT team, the ETL Technical Lead is responsible for the design, Installation, development, management, upgrades and support of mission- critical enterprise Extract, Transform, Load (ETL) processes and environments. ETL Technical lead governs the data migration, conversion projects and data quality projects.
The ETL Technical Lead is a technical expert responsible for developing globally consistent processes in data migration during Oracle and SAP implementations and ensuring that an auditable and monitored process is in place for managing data migration activities.
The ETL Technical Lead is skilled in data migration tools and techniques throughout the lifecycle of an implementation, from pre-implementation planning to go-live and post-go live data and archival.
As a key element of any ERP project, the ETL Technical Lead provides global services in the areas of data extraction from legacy source systems into data staging areas, design of target schemas, and build transformation framework, develop interfaces and workflows for data cleansing, monitoring of data migration and cleanup progress as well as supporting of go live data loading. In the post-go live environment, the ETL Technical Lead provides ongoing monitoring of data creation/change to ensure quality of business processes. He/she also supports large scale data extracts and loads as required by the business on an ongoing basis for routine master data maintenance and support the design and construction of data quality reports as prescribed by the business to manage data quality.
The ETL Technical Lead is expected to be technically competent in scripting, and programming with knowledge of SQL, Data structure and processes. Guide ETL Developers in executing their responsibilities in development of scripts to analyze data and in analytical techniques for interrogating legacy system data. Review work quality and ensure overall quality of deliverables.
ETL Technical Lead is responsible for designing, installing and creating the data staging area and all related extraction, transformation and load of data functions in Emerson.
ETL Technical Lead ensures the system runs smoothly. Carry Performance analysis and tune the ETL framework.
Masters Data tools such as data migration servers and Syniti DSP software, ensuring ongoing technology changes and best practices are continually evaluated and incorporated into the Emerson s ETL portfolio.
Connect to legacy ERP environments implementing ODBC, OleDB, or DB connections
Ensure audit trail is in place for data migration and migrated data is traceable back to the cleanup / data enrichment activities and a clear line of sight to the source legacy systems.
Manage a long-term archiving strategy and solution for legacy ERP data to allow legacy ERP systems to be permanently decommissioned
Work closely with ERP implementation teams to ensure blueprint is effectively understood and translated into data migration requirements / data concept documents.
Creation and use of ETL tools
ERP Implementation specific data tasks:
Help define testing & quality assurance measures for data migration projects
Support project specific data migration activities in a rollout or conversion project
Definition of data load plans and alignment with cutover-plans
Definition of data migration templates for each data migration object
Source system data structure and fields analysis
Extract data from legacy systems (database dumps)
Import data from legacy systems into a mapping tool
Creation of data migration blueprints (migration concepts, transformation rules, mappings, selection criteria)
Implementation / programming / configuration of transformation rules, structure/field/value-mapping
Monitor progress and quality of data migration, status reporting
Conduct Data loads for different testing phases and go live
Mass uploads / carry out manual migration steps
Generation of error logs that are meaningful to the business
A Bachelor s degree in computer science / information technology or another discipline
5 to 10 years experience in Development with at least 3 years in ETL Development
Exposure in 5 or more Projects as Team Member
Experience with focus on data management and SAP and/or Oracle functional knowledge. Prior experience with ERP implementations is a requirement.
Technically capable with some of the coding languages commonly used in ETL development like SQL, any programming languages like .Net
Knowledge of Project Management Methodologies and principles
Proficiency in Syniti s DSP Tools, Demonstrated ability with ETL Tools
Able to travel at least 30%
Strong analytical capability, process oriented and ability to manage complexity
good set of communication skills
listen to and interpret what the business side wants to see accomplished
discuss details in an easy-to-understand way, and then translate it all into nuts-and-bolts technical output
strong personal initiative, drive, motivated to learn
Department:General / Other SoftwareIndustry:ManufacturingSkills:java, environment, sql server, sql, customer relations, line of sight, master data, audit trail, data quality, data migration, data cleansing, legacy systems, data management, data extraction, data enrichment, global servicesEducationGraduation
Recruiter detailsCompany Name: EMERSON INNOVATION CENTER