hireejobs
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

ETL Technical Lead

3.00 to 10.00 Years   Kolkata   13 Apr, 2021
Job LocationKolkata
EducationNot Mentioned
SalaryNot Disclosed
IndustryManufacturing
Functional AreaGeneral / Other Software
EmploymentTypeFull-time

Job Description

*Position ProfileAs 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., *Responsibilities

  • 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
Required Qualifications:
  • 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%
Personality Traits
    • 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
    • strong accountability

Keyskills :
javaenvironmentsql serversqlcustomer relationsline of sightmaster dataaudit traildata qualitydata migrationdata cleansinglegacy systemsdata managementdata extractiondata enrichmentglobal services

ETL Technical Lead Related Jobs

© 2019 Hireejobs All Rights Reserved