Loading...

@

  • Software Developer - ETL - Senior Toronto
  • Maarut Inc in Toronto, , Canada
  • jobs
  • 2 weeks ago

jobs description

Scope :

Asenior Software Developer ETL is required to provide best practicemigration solutions and oversee all facilities of the data andfiles migration from legacy application to a newsolution

Deliverables :
• Providebest practice migration solutions and oversee all facilities of thedata and files migration from legacy application to a new solution.
• Establisha strong working relationship with clients interact effectively atall levels and analyses legacy data and files stored in a varietyof data sources andformats.
• Analyzeand complete data profiling and suggest any pre migration datacleansingactivities.
• Completedata migration strategy data mapping define interfaces perform mockconversion define enhancements and perform actualconversion.
• Requiredto translate technical systems specifications into working testedapplications. This includes developing detailed programmingspecifications writing and / or generating code compiling datadrivenprograms maintaining and conducting... unittests.
• Resolveand troubleshoot technical problems which arise during the use andoperation of software packages including technical assistance inimplementation conversion andmigrations
• Workwith importing files from heterogeneous platforms and coordinatesdata filemigration.
• Definetesting strategy plan and conducts testing to ensure data integrityand datacomparisons.
• Performpost migration audit and datareconciliation.
• Generatedata migration exception reporting and perform data cleansing asrequired.
• Providespre and posteffective conversion support to businessclients

Requirements

Experienceand Skill SetRequirements :

Musthaves :
• 7years of experience in developing data conversion andmigration
• Experiencein developing data conversion andmigration

Nice tohave :
• Knowledgeand experience in development of business case data migrationstrategy and plan
• Knowledgeand understanding of Information Management principles conceptspolicies andpractices.
• Excellentunderstanding of master data and transactional data concepts andinterdependencies

Skill SetRequirements :
• Fulllifecycle data conversion experience with enterprise systemsincluding deploymentexperience.
• Experienceworking with all steps of data migration activities such as dataprofiling data mapping developing data migration solutions datavalidation andaudit.
• Proficiencyin query languages such as SQLPLSQL.
• Familiaritywith and construction of complex querystatements.
• Knowledgeof various database structures and RDMS like Oracle DB and MS SQLServer Azure SQL Database and write complex SQLqueries
• Knowledgeand understanding of mainframe data formats data types segments andnonrelational datastructures
• Experienceensuring the data migration solution isscalable.
• Dataanalysis investigative and logic skills with high attention todetail
• Experiencewith migrating file attachments from legacy applications to newsolution.
• Experiencewith data conversion scripts and various ETL tools such asInformatica Azure Data Factoryetc.
• Experiencewith overseeing / completing all tasks involved in the conversionprocess including data extraction cleansing transformation andloading
• Experienceliaising with teams to understand tobe migrationrequirements.
• Establisha strong working relationship with all groups interact effectivelywith all levels of client personnel and provide conversionsupport.
• Experiencecompleting mapping interfaces conversion work documentation andverifying completeness and accuracy of converteddata.
• Experiencedelivering the required system changes and / or working with thedevelopment team or a dedicated conversion team to specify loadsprograms.
• Experienceproviding support through the cutoverprocess
• Ateam player with a track record for meeting deadlines managingcompeting priorities and client relationship managementexperience
• Communicationfacilitation negotiation consensus building and problemsolvingskills

Data KnowledgeExpertiseSkills :
• 7years of experience in developing data conversion andmigration
• Experienceworking with migrating data from different legacy platforms to anewsolution.
• Fulllifecycle data conversion experience with enterprise systemsincluding deploymentexperience.
• Knowledgeof various database structures and RDMS like Oracle DB MS SQLServer Azure SQL Database and write complex SQL queriesetc.
• Dataanalysis investigative and logicskills.
• Experiencewith overseeing / completing all tasks involved in the conversionprocess including data extraction profiling cleansing import datamanipulate data transformation andloading.
• Experienceliaising with teams to understand tobe migrationrequirements.
• Knowledgeand understanding of Information Management principles conceptspolicies andpractices.
• Experienceproviding support through the cutoverprocess.
• Knowledgeof data model of case management solutions and experience in datamigration / conversion of large case managementapplications.
• Experiencewith migrating attachment files from legacy applications to newsolution.
• Experiencewith documentmigration

TechnicalSkills :
• Proficiencyin query languages such as Oracle SQL PLSQL SQL Serveretc.
• Exceptionallevel of knowledge on relationships between tables to perform andconstruct complex query statements from multiple datasources.
• Knowledgeof various database structures and RDMS like Oracle MS SQL ServerAzure SQL Database and write complex SQL queriesetc.
• Knowledgeand understanding of mainframe data formats data types segments andnonrelational datastructures
• Dataanalysis investigative and logic skills with high attention todetails.
• Experiencewith data conversion scripts andtools.
• Experiencewith industry leading ETL tools such as Informatica Azure DataFactory and cloudtechnologies.
• Experiencewith file migration from different file storages such as Azure BLOBAzure file share SharePoint OracleBLOBs.
• Experiencecompleting mapping interfaces conversion work data exclusion andinclusion documentation and verifying completeness and accuracy ofconverted data including data dictionary development andupdates.
• Experiencedelivering the required system changes and / or working with thedevelopment team or a dedicated conversion team to specify loadsprograms.

CommunicationSkills :
• Communicationfacilitation negotiation consensus building and problemsolvingskills
• Provideperiodic status reports present data migration strategy andapproach to executives and otherstakeholders

Public SectorExperience :

Previousexperience working in Government or Public Sectororganizations

Experience and Skill Set Requirements : Must haves : 7+ years ofexperience in developing data conversion and migration Experiencein developing data conversion and migration Nice to have : Knowledgeand experience in development of business case, data migrationstrategy and plan Knowledge and understanding of InformationManagement principles, concepts, policies and practices.

Excellentunderstanding of master data and transactional data concepts andinterdependencies Skill Set Requirements : Full life-cycle dataconversion experience with enterprise systems, including deploymentexperience.

Experience working with all steps of data migrationactivities such as data profiling, data mapping, developing datamigration solutions, data validation and audit.

Proficiency inquery languages such as SQL, PL-SQL. Familiarity with andconstruction of complex query statements. Knowledge of variousdatabase structures and RDMS like Oracle DB and MS SQL Server,Azure SQL Database, and write complex SQL queries Knowledge andunderstanding of mainframe data formats, data types, segments andnon-relational data structures Experience ensuring the datamigration solution is scalable.

Data analysis, investigative andlogic skills with high attention to detail Experience withmigrating file attachments from legacy applications to newsolution.

Experience with data conversion scripts and various ETLtools such as Informatica, Azure Data Factory, etc. Experience withoverseeing / completing all tasks involved in the conversion processincluding data extraction, cleansing, transformation and loadingExperience liaising with teams to understand to-be migrationrequirements.

Establish a strong working relationship with allgroups, interact effectively with all levels of client personnel,and provide conversion support.

Experience completing mapping,interfaces, conversion work, documentation and verifyingcompleteness and accuracy of converted data.

Experience deliveringthe required system changes and / or working with the developmentteam or a dedicated conversion team to specify loads programs.

Experience providing support through the cutover process A teamplayer with a track record for meeting deadlines, managingcompeting priorities and client relationship management experienceCommunication, facilitation, negotiation, consensus building, andproblem-solving skills Data Knowledge Expertise Skills : 7+ years ofexperience in developing data conversion and migration Experienceworking with migrating data from different legacy platforms to anew solution.

Full life-cycle data conversion experience withenterprise systems, including deployment experience. Knowledge ofvarious database structures and RDMS like Oracle DB, MS SQL Server,Azure SQL Database, and write complex SQL queries, etc.

Dataanalysis, investigative and logic skills. Experience withoverseeing / completing all tasks involved in the conversion processincluding data extraction, profiling, cleansing, import data,manipulate data, transformation and loading.

Experience liaisingwith teams to understand to-be migration requirements. Knowledgeand understanding of Information Management principles, concepts,policies and practices.

Experience providing support through thecutover process. Knowledge of data model of case managementsolutions and experience in data migration / conversion of large casemanagement applications.

Experience with migrating attachment filesfrom legacy applications to new solution. Experience with documentmigration Technical Skills : Proficiency in query languages such asOracle SQL, PL-SQL, SQL Server, etc.

Exceptional level ofknowledge on relationships between tables to perform and constructcomplex query statements from multiple data sources.

Knowledge ofvarious database structures and RDMS like Oracle, MS SQL Server,Azure SQL Database, and write complex SQL queries, etc.

Knowledgeand understanding of mainframe data formats, data types, segmentsand non-relational data structures Data analysis, investigative andlogic skills with high attention to details.

Experience with dataconversion scripts and tools. Experience with industry leading ETLtools such as Informatica, Azure Data Factory and cloudtechnologies.

Experience with file migration from different filestorages such as Azure BLOB, Azure file share, SharePoint, OracleBLOBs.

Experience completing mapping, interfaces, conversion work,data exclusion and inclusion, documentation and verifyingcompleteness and accuracy of converted data, including datadictionary development and updates.

Experience delivering therequired system changes and / or working with the development team ora dedicated conversion team to specify loads programs.

Communication Skills : Communication, facilitation, negotiation,consensus building, and problem-solving skills Provide periodicstatus reports, present data migration strategy and approach toexecutives and other stakeholders Public Sector Experience : Previous experience working in Government or Public Sectororganizations
Toronto ON

salary-criteria

Apply - Software Developer - ETL - Senior Toronto