RQ09299 - Sr. Software Developer - ETL
Contract 1 year 2 possible extensions
Onsite / 21 College Street Toronto
Security Level : Enhanced
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
Assignment 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 data-driven 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 migrationsWork 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 post-effective conversion support to business clientsMUST HAVES :
7 years of experience in developing data conversion and migrationExperience working in ETL tools such as A zure Data Factory Informatica etc.Proficiency in query languages such as Oracle SQL PL-SQL SQL Server etc.Nice to Have :
Knowledge and experience in development of business case data migration strategy and planKnowledge and understanding of Information Management principles concepts policies and practicesExcellent understanding of master data and transactional data concepts and interdependenciesKey Skills
SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle
Employment Type : Full Time
Experience : years
Vacancy : 1