Current jobs related to Senior ETL Developer - Toronto, Ontario - Global Applications Solutions LLC

  • Senior ETL Developer

    5 minutes ago

    Toronto, Ontario, Canada TekStaff IT Solutions Full time

    Typical Day in Role:• Involved in end-to-end ETL/ELT architectures using Talend (Studio, TAC, Data Integration, Real-Time Big Data, Data Quality).• Select integration patterns (batch, micro-batch, streaming) aligned to business SLAs and system constraints.• Establish standards for metadata management, lineage, error handling, and reusability.Hands-on...

  • Senior ETL Developer- Ministry Experience

    7 days ago

    Toronto, Ontario, Canada Huntel Global Full time

    Title:Senior ETL Developer- Ministry ExperienceLocation:Toronto, ON, Canada (Onsite)Type:Long Term ContractResponsibilities:Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.Required to translate technical systems specifications into working, tested applications. This includes...

  • Senior ETL Developer- Ministry Experience

    10 minutes ago

    Toronto, Ontario, Canada Huntel Global Full time

    Title:Senior ETL Developer- Ministry ExperienceLocation:Toronto, ON, Canada (Onsite)Type:Long Term ContractResponsibilities:Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.Required to translate technical systems specifications into working, tested applications. This includes...

  • RQ10127 - ETL Software Developer

    6 days ago

    Toronto, Ontario, Canada emergiTEL Full time

    Job Title: Software Developer – ETL (Senior)Work ArrangementOnsite (5 days per week)Role SummaryThe Senior ETL Software Developer is responsible for designing, developing, and maintaining scalable data pipelines and analytics solutions across cloud-based and enterprise data platforms. The role focuses on ETL development, data integration, data modeling,...

  • ETL Developer

    17 minutes ago

    Toronto, Ontario, Canada Apptoza Inc. Full time

    Role: IBM ETL Data Stage DeveloperLocation: Toronto, ON (Hybrid)Duration: Long TermRole Descriptions:IBM Data Stage -Focus on highlighting your technical skills| including DataStage (parallel jobs| routines)| SQL| shell scripting| and experience with various data sources like DB2| Oracle| or TeradataExperience with the full data warehousing and ETL...

  • ETL Talend Developer

    16 minutes ago

    Toronto, Ontario, Canada Galent Full time

    Role Overview:We are seeking a highly skilled Talend Developer to design, implement, and optimize ETL workflows that support our enterprise data integration needs. The ideal candidate will lead data engineering initiatives, ensure data quality, and collaborate with cross-functional teams to deliver scalable and reliable solutions.Key ResponsibilitiesETL...

  • RQ10067 - Software Developer - ETL - Senior

    6 days ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Responsibilities/Assignment Deliverables – Senior ETL DeveloperDesigns, develops, and maintains database back end and ETL applications for Data Warehouse and Business Intelligence solutions. ...

  • Software Developer – ETL

    16 minutes ago

    Toronto, Ontario, Canada Russell Tobin Full time

    Job Title: Software Developer - ETL (Senior)Location: Toronto, ON (Onsite)Duration: 61 Days with extension to 250 DaysClient: Public SectorPay Rate: C$80-C$90/hrRole Summary:The Senior Software Developer - ETL will be responsible for designing, developing, and maintaining secure, scalable ETL/ELT solutions using Microsoft Azure and Databricks technologies....

  • Sr ETL Developer

    3 minutes ago

    Toronto, Ontario, Canada Bevertec Full time

    Software Developer - ETL - SeniorStart Date ClientHealth Services ClusterEnd Date loc: Toronto, ONHybridMust Have· Designing and developing scalable Medallion Data Lakehouse architectures.· Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks.· Experience integrating structured and unstructured data sources into...

  • SQL/ETL Developer

    13 minutes ago

    Toronto, Ontario, Canada BURGEON IT SERVICES Full time

    Job Title: SQL/ETL Developer (SSIS/SSRS) – US Wire PaymentsLocation:Toronto, Canada (Hybrid – 10 days/month onsite)Job Type:12 months plus contractPlease share me the resumes atJob Description:We are looking for an experienced SQL/ETL Developer with strong hands-on skills inSSIS, SSRS, T-SQL, and experience working in theUS wire payments processing...

Senior ETL Developer

3 weeks ago

Toronto, Ontario, Canada Global Applications Solutions LLC Full time

Hope you doing well,

ETL Developer

Onsite / 21 College Street, Toronto

Contract Role

Customer is government of Canada

A Note on Assignment Type:

This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

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

Experience and Skillset Requirements

Mandatory Requirements

  • 7+ years of experience in developing data conversion and migration
  • Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
  • 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

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.
  • 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 in migrating document attachments from legacy solution to a new modernized 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

  • Experience 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.
  • 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.
  • Experience with document migration

Criteria 2: Experience with Document Migration - 35 Points

  • 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, etc., Azure SQL Database, and write complex SQL queries.
  • 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 industry leading ETL tools such as Informatica, Azure Data Factory and cloud technologies.
  • 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
  • Experience liaising with teams to understand to-be migration requirements.

Criteria 4: Public Sector Experience - 5 Points

  • Previous experience working in Government or Public Sector organizations

Knowledge Transfer

What needs to be KT

  • All documentation relating to the technology designs and technology knowledge specific to the candidate's assignment All information gathered while working with vendors and internal solutions to be shared Any best practices, work around, lessons learned must be documented

To whom

Regards

Ravi Sharma

Phone :

Altitude Technology Solutions,(ATS Inc)

Job Type: Fixed term contract

Contract length: 6 months

Pay: $47.05-$65.00 per hour