Software Developer ETL

Skills Required :

ETL Tools e.g. Informatica, Talend, SQL and Database Management, Data Warehousing Concepts, ETL Performance Tuning, Data Modeling Skills, Scripting Languages e.g. Python, Shell, Data Quality Assurance, Agile Methodologies, Communication and Collaboration Skills, Cloud Data Integration e.g. AWS, Azure.

HM

Note:

This hybrid contract role is three (3) days in office. Candidates' resumes must include first and last name.

• 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.
• Establish a strong working relationship with clients, interact effectively at all levels and analyze 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.
• Translate technical systems specifications into working, tested applications, including developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
• Resolve and troubleshoot technical problems arising during the use and operation of software packages, including technical assistance in implementation, conversion, and migrations.
• Work with importing files from heterogeneous platforms and coordinate data file migration.
• Define testing strategy, plan, and conduct 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.
• Provide pre- and post-effective conversion support to business clients.

• 7+ years of experience in developing data conversion and migration.
• Extensive experience in data migration in terms of digital transformation, ETL 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.

• Full life-cycle 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, PL-SQL.
• 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 non-relational 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 overseeing/completing all tasks involved in the conversion process including data extraction, cleansing, transformation, and loading.
• Experience liaising with teams to understand to-be 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 problem-solving skills.

• 7+ years of experience in developing data conversion and migration.
• At least one experience of working with migrating data from different legacy platforms to a new solution.
• Full life-cycle data conversion experience with enterprise systems, including deployment experience.
• Data analysis, investigative and logic skills, including the ability to troubleshoot and solve complex technical problems.
• Experience…