Sql dba • north york on
Job Title: RQ10575 - Software Developer (ETL) Senior.Organization: Justice Technology Services.Location: Toronto ON , Onsite 5 days a week.A senior Software Developer ETL is required to provide bes... Show more
Business Analyst / Researcher / Operations Specialist.Business Analysts, Researchers, and Operations Specialists.No prior AI experience is required.Analyze business scenarios, decisions, and trade-... Show more
TEHORA est présentement à la recherche d’un(e).Sans être exhaustifs, voici les services et livrables que devra fournir la personne retenue :.Administrer les bases de données;.Assurer la performance... Show more
Database administration, On-premises and On-cloud (Azure).Microsoft Dynamics - Great plains (GP ).Migration of on-premises Databases to cloud.Hands on experience with Database Administration specia... Show more
RQ11711 - Software Developer - Senior.Duration: 1 Year (250 Business Days)+ 1 Extension .Location: 25 Morton Shulman Ave.GeoTalent, including working within the GeoTalent development environment (T... Show more
Python, PySpark, SQL, Snowflake & API Integration.Python, PySpark, SQL, Snowflake, and API integrations to build scalable data pipelines and cloud-based data solutions.Design, develop, and opti... Show more
Database administration, On-premises and On-cloud (Azure).Microsoft Dynamics - Great plains (GP ).Microsoft Certified: Azure Database Administrator Associate.Microsoft SQL Server certifications.Mic... Show more
Data Business Analyst - PL/SQL, T-SQL & Data Warehousing.Hybrid (2 days per week in-person at Toronto office preferred).Business Analysis, Solution and Functional Architect (SAFA), Data Analyti... Show more
Headquartered in Toronto, CMiC is a software company focused on the Construction industry.We have built a comprehensive platform for construction companies to manage their most important workflows.... Show more
CoreFactor is searching for an ETL Tester on a contract basis for a Financial Services client in the GTA.This position is hybrid and will require the successful incumbent to go into the office four... Show more
We are looking for an experienced.Java Developer with 5+ years of hands-on experience.The ideal candidate should have strong expertise in.Core Java, Spring Boot, Microservices, REST APIs, SQL, and ... Show more
Role - Oracle DBA </b></p> <p style="text-align:start; text-indent:0px; -webkit-text-stroke-width:0px"><b>Location - Toronto, ON (Hybrid)</b></p> <p... Show more
Headquartered in San Francisco, our investors include.Applied Business & Commerce Benchmark Specialist.Author original business questions that test deep conceptual understanding in.Ensure quest... Show more
Software Developer (ERP/CRM/Platforms) – Junior.We are seeking a motivated Junior Software Developer to support the development, customization, integration, and maintenance of enterprise applicatio... Show more
We are seeking an experienced Intermediate Database Administrator with strong senior-level DBA expertise to oversee both on-premises and cloud-based (Azure) database environments.In this role, you ... Show more
Title:</b> Database Administrator - Intermediate</p> <div><b>Location:</b> Toronto, ON.Hands on experience with Microsoft Dynamics Great plain and finance systems, Mic... Show more
APEX, integrating call center telephony and quality data from the Genesys A3S Snowflake database and Verint Workforce Management (WFM) feeds.The role will focus on building a scalable, reliable, an... Show more
Job Title:</b> Software Developer - Senior</p> <p><b>Location:</b> Toronto</p> <p><b>Work Model:</b> Onsite</p> <p><b>Dura... Show more
Job Title: RQ10575 - Software Developer (ETL) Senior
Organization: Justice Technology Services
Location: Toronto ON , Onsite 5 days a week
Pay Rate:95-101/hr incorp
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
Skills
Experience and Skill Set Requirements
A Note on the VOR Master Service Agreement:
The VOR Master Service Agreement expires on April 5, 2027, and includes a six (6)-month survival clause, allowing the Statement of Work (SOW) to continue, if operationally required, until October 5, 2027. Extension(s) are only allowed using unused days and/or funds remaining on the contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW. JTS may exercise its option(s) to extend the SOW beyond April 5, 2027, in accordance with the survival clause.
The start date is subject to change based on security clearances and contract signing timelines.
Experience and Skillset Requirements
Mandatory Requirements
7+ years of experience in developing and documenting ETL for data conversion and migration
Extensive experience in data migration and migration planning in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.
Extensive experience with various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, conduct data analysis, data validation, and solve complex technical problems
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 with ETL tools such as Azure Data Factory, Informatica, etc.
Experience in development of documentation such as ETL mappings, data dictionaries, 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.
Desired Skills and Experience
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 with 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
Resumes Evaluation/Criteria:
Criteria 1: Data Knowledge Expertise Skills - 35 Points
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 with overseeing /completing all tasks involved in the conversion process including data extraction, profiling, cleansing, import data, manipulate data, transformation and loading.
Experience liaising with teams to understand to-be migration requirements.
Knowledge and understanding of Information Management principles, concepts, policies and practices.
Experience providing support through the cutover process.
Knowledge of data model of case management solutions and experience in data migration/conversion of large case management applications.
Experience with migrating attachment files from legacy applications to new solution.
Criteria 2: Technical Skills - 35 Points
Experience with industry leading ETL tools such as Informatica, Azure Data Factory and cloud technologies.
Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
Exceptional level of knowledge on relationships between tables to perform and construct complex query statements from multiple data sources.
Knowledge of various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, etc.,
Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
Data analysis, investigative and logic skills with high attention to details, including ability to troubleshoot and solve complex technical problems.
Experience with data conversion scripts and tools.
Experience with file migration from different file storages such as Azure BLOB, Azure file share, SharePoint, Oracle BLOBs.
Experience completing mapping, interfaces, conversion work, data exclusion and inclusion, documentation and verifying completeness and accuracy of converted data, including data dictionary development and updates.
Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
Criteria 3: Communication Skills - 25 Points
Communication, facilitation, negotiation, consensus building, and problem-solving skills
Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders
Criteria 4: Public Sector Experience - 5 Points
Previous experience working in Government or Public Sector organizations
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
