Rq09299

RQ 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 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 post-effective conversion support to business clients

MUST HAVES:

• 7+ years of experience in developing data conversion and migration
• Experience working in ETL tools such as Azure 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 plan
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Excellent understanding of master data and transactional data concepts and interdependencies