7+ years of experience in ETL development and documentation for data migration projects.
Extensive experience with data migration planning for digital transformation initiatives.
Proficient in relational databases like Oracle, MS SQL Server, and Azure SQL Database.
Strong skills in complex SQL development, data analysis, and technical problem resolution.
Experience with ETL tools such as Azure Data Factory and Informatica.
Responsibilities
Provide best practice migration solutions for data and file migration.
Establish strong client relationships and analyze legacy data across various formats.
Conduct data profiling and recommend pre-migration data cleansing activities.
Develop data migration strategies, mappings, and perform mock conversions.
Translate technical specifications into tested applications and conduct unit tests.
Troubleshoot technical issues during software operation and migration processes.
Define testing strategies to ensure data integrity and perform post-migration audits.
Benefits
Pre- and post-conversion support to business clients.
Opportunity to work with cutting-edge cloud technologies.
Engagement in full life-cycle data conversion projects.
Collaboration with diverse teams and stakeholders.
Potential for professional growth in digital transformation initiatives.
Full Job Description
Job Description Scope:
Asenior Software Developer ETL is required to provide best practicemigration solutions and oversee all facilities of the data and filesmigration from legacy application to a new solution
Assignment Deliverables:
Providebest practice migration solutions and oversee all facilities of the dataand files migration from legacy application to a new solution.
Establisha strong working relationship with clients, interact effectively at alllevels and analyses legacy data and files stored in a variety of datasources and formats.
Analyzeand complete data profiling and suggest any pre migration data cleansingactivities.
Completedata migration strategy, data mapping, define interfaces, perform mockconversion, define enhancements and perform actual conversion.
Requiredto translate technical systems specifications into working, testedapplications. This includes developing detailed programmingspecifications, writing and/or generating code, compiling data-drivenprograms, maintaining, and conducting unit tests.
Resolveand troubleshoot technical problems which arise during the use andoperation of software packages, including technical assistance inimplementation, conversion and migrations
Workwith importing files from heterogeneous platforms and coordinates datafile migration.
Definetesting strategy, plan and conducts testing to ensure data integrity anddata comparisons.
Performpost migration audit and data reconciliation.
Generatedata migration exception reporting and perform data cleansing as required.
Providespre- and post-effective conversion support to business clients
Requirements
Experience and Skill Set Requirements:
Must Haves:
7+ years of experience developing and documenting ETL processes for data conversion and migration projects.
Extensive experience with:
Data migration and migration planning for digital transformation initiatives.
Migrating data from legacy applications to modernized solutions using ETL methodologies.
Relational databases such as Oracle, MS SQL Server, and Azure SQL Database.
Complex SQL development, data analysis, data validation, and technical problem resolution.
Experience with:
Migrating document attachments from legacy systems to modernized solutions.
Cloud database technologies (e.g., Azure SQL).
ETL tools such as Azure Data Factory, Informatica, or similar technologies.
Developing ETL and data migration documentation, including:
ETL mappings
Data dictionaries
Business cases
Data migration strategies and plans
Skill Set Requirements:
Mandatory Requirements:
7+years of experience in developing and documenting ETL for data conversionand migration
Extensiveexperience in data migration and migration planning in terms of digitaltransformation, ETL experience in migrating data from legacy applicationsto modernized solutions.
Extensiveexperience with various database structures and RDMS like Oracle, MS SQLServer, Azure SQL Database, and write complex SQL queries, conduct dataanalysis, data validation, and solve complex technical problems
Experiencein migrating document attachments from legacy solution to a new modernizedsolution.
Experienceworking in cloud DB technologies (such as Azure SQL).
Experienceworking with ETL tools such as Azure Data Factory, Informatica, etc.
Experiencein development of documentation such as ETL mappings, data dictionaries,business case, data migration strategy and plan.
Knowledgeand understanding of Information Management principles, concepts, policiesand practices.
Excellentunderstanding of master data and transactional data concepts andinterdependencies.
Desired Skills and Experience:
Fulllife-cycle data conversion experience with enterprise systems, includingdeployment experience.
Experienceworking with all steps of data migration activities such as dataprofiling, data mapping, developing data migration solutions, datavalidation and audit.
Proficiencyin query languages such as SQL, PL-SQL.
Familiaritywith and construction of complex query statements.
Knowledgeof various database structures and RDMS like Oracle DB and MS SQL Server,Azure SQL Database, and write complex SQL queries
Knowledgeand understanding of mainframe data formats, data types, segments andnon-relational data structures
Experienceensuring the data migration solution is scalable.
Dataanalysis, investigative and logic skills with high attention to detail
Experiencewith migrating file attachments from legacy applications to new solution.
Experiencewith data conversion scripts and various ETL tools such as Informatica,Azure Data Factory, etc.
Experiencewith overseeing /completing all tasks involved in the conversion processincluding data extraction, cleansing, transformation and loading
Experienceliaising with teams to understand to-be migration requirements.
Establisha strong working relationship with all groups, interact effectively withall levels of client personnel, and provide conversion support.
Experiencecompleting mapping, interfaces, conversion work, documentation andverifying completeness and accuracy of converted data.
Experiencedelivering the required system changes and/or working with the developmentteam or a dedicated conversion team to specify loads programs.
Experienceproviding support through the cutover process
Ateam player with a track record for meeting deadlines, managing competingpriorities and client relationship management experience
Communication,facilitation, negotiation, consensus building, and problem-solving skills
Data Knowledge Expertise Skills:
7+years of experience in developing data conversion and migration
Atleast one experience of working with migrating data from different legacyplatforms to a new solution.
Fulllife-cycle data conversion experience with enterprise systems, includingdeployment experience.
Dataanalysis, investigative and logic skills, including the ability totroubleshoot and solve complex technical problems.
Experiencewith overseeing /completing all tasks involved in the conversion processincluding data extraction, profiling, cleansing, import data, manipulatedata, transformation and loading.
Experienceliaising with teams to understand to-be migration requirements.
Knowledgeand understanding of Information Management principles, concepts, policiesand practices.
Experienceproviding support through the cutover process.
Knowledgeof data model of case management solutions and experience in datamigration/conversion of large case management applications.
Experiencewith migrating attachment files from legacy applications to new solution.
Technical Skills:
Experiencewith industry leading ETL tools such as Informatica, Azure Data Factoryand cloud technologies.
Proficiencyin query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
Exceptionallevel of knowledge on relationships between tables to perform andconstruct complex query statements from multiple data sources.
Knowledgeof various database structures and RDMS like Oracle, MS SQL Server, AzureSQL Database, and write complex SQL queries, etc.,
Knowledgeand understanding of mainframe data formats, data types, segments andnon-relational data structures
Dataanalysis, investigative and logic skills with high attention to details,including ability to troubleshoot and solve complex technical problems.
Experiencewith data conversion scripts and tools.
Experiencewith file migration from different file storages such as Azure BLOB, Azurefile share, SharePoint, Oracle BLOBs.
Experiencecompleting mapping, interfaces, conversion work, data exclusion andinclusion, documentation and verifying completeness and accuracy ofconverted data, including data dictionary development and updates.
Experiencedelivering the required system changes and/or working with the developmentteam or a dedicated conversion team to specify loads programs.
Communication Skills:
Communication,facilitation, negotiation, consensus building, and problem-solving skills
Provideperiodic status reports, present data migration strategy and approach toexecutives and other stakeholders
Public Sector Experience:
Previousexperience working in Government or Public Sector organizations
