RQ - Software Developer - ETL - Senior

SCOPE:

• A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution
  

DELIVERABLES:

• Provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.
  
• Establish a strong working relationship with clients interact effectively at all levels and analyses legacy data and files stored in a variety of data sources and formats.
  
• Analyze and complete data profiling and suggest any pre migration data cleansing activities.
  
• Complete data migration strategy data mapping define interfaces perform mock conversion define enhancements and perform actual conversion.
  
• Required to translate technical systems specifications into working tested applications. This includes developing detailed programming specifications writing and/or generating code compiling datadriven programs maintaining and conducting unit tests.
  
• Resolve and troubleshoot technical problems which arise during the use and operation of software packages including technical assistance in implementation conversion and migrations
  
• Work with importing files from heterogeneous platforms and coordinates data file migration.
  
• Define testing strategy plan and conducts testing to ensure data integrity and data comparisons.
  
• Perform post migration audit and data reconciliation.
  
• Generate data migration exception reporting and perform data cleansing as required.
  
• Provides pre and posteffective conversion support to business clients

Requirements

MANDATORY REQUIREMENTS:

• 7 years of experience in developing data conversion and migration
  
• Extensive experience in data migration in terms of digital transformationETL experience in migrating data from legacy applications to modernized solutions.
  
• Experience in migrating document attachments from legacy solution to a new modernized solution.
  
• Experience working in cloud DB technologies (such as Azure SQL).
  
• Experience working in ETL tools such as Azure Data Factory Informatica etc.
  
• Knowledge and experience in development of business case data migration strategy and plan.
  
• Knowledge and understanding of Information Management principles concepts policies and practices.
  
• Excellent understanding of master data and transactional data concepts and interdependencies.
  

SKILLS AND KNOWLEDGE:

• Full lifecycle data conversion experience with enterprise systems including deployment experience.
  
• Experience working with all steps of data migration activities such as data profiling data mapping developing data migration solutions data validation and audit.
  
• Proficiency in query languages such as SQL PLSQL.
  
• Familiarity with and construction of complex query statements.
  
• Knowledge of various database structures and RDMS like Oracle DB and MS SQL Server Azure SQL Database and write complex SQL queries
  
• Knowledge and understanding of mainframe data formats data types segments and nonrelational data structures
  
• Experience ensuring the data migration solution is scalable.
  
• Data analysis investigative and logic skills with high attention to detail
  
• Experience with migrating file attachments from legacy applications to new solution.
  
• Experience with data conversion scripts and various ETL tools such as Informatica Azure Data Factory etc.
  
• Experience with overseeing /completing all tasks involved in the conversion process including data extraction cleansing transformation and loading
  
• Experience liaising with teams to understand tobe migration requirements.
  
• Establish a strong working relationship with all groups interact effectively with all levels of client personnel and provide conversion support.
  
• Experience completing mapping interfaces conversion work documentation and verifying completeness and accuracy of converted data.
  
• Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
  
• Experience providing support through the cutover process
  
• A team player with a track record for meeting deadlines managing competing priorities and client relationship management experience
  
• Communication facilitation negotiation consensus building and problemsolving skills
  

Must haves:

• 7 years of experience in developing data conversion and migration
  
• Demonstrates extensive experience with the following:
  
• Data migration in terms of digital transformation ETL experience in migrating data from legacy applications to modernized solutions
  
• Experience working in ETL tools such as Azure Data Factory Informatica etc.
  
• Experience in migrating document attachments from legacy solution to a new modernized solution
  
• Experience working in cloud DB technologies (such as Azure SQL)
  
• Demonstrates knowledge and experience with the following:
  
• Development of business case data migration strategy and plan
  
• Knowledge and understanding of Information Management principles concepts policies and practices
  
• Excellent understanding of master data and transactional data concepts and interdependencies