Jobs
>
Toronto

    Senior ETL Developer - Toronto, Canada - GTT, LLC

    GTT, LLC
    GTT, LLC Toronto, Canada

    Found in: Talent CA C2 - 3 weeks ago

    Default job background
    Full time
    Description

    Senior ETL Developer

    Job Responsibilities
    Design, develop, and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL. Used tools are:
    Azure Data Factory (expert knowledge) to maintain the pipeline from Oracle to Azure Data Lake
    Azure Synapse to build stored procedures and read data from the data lake
    Review the requirements, database tables, and database relationships - Identify gaps and inefficiencies in the current production reporting environment and provide recommendations to address them in the new platform.
    Continue to evolve and design ingesting framework and CDC
    Prepare design artifacts
    Analysis of data - physical model mapping from data source to reporting destination.
    Understand the requirements. Recommend changes to the Physical model.
    Develop the scripts of a physical model, and create DB.
    Access Oracle DB environments, use SSIS, SQL Server, and other development tools for developing solutions.
    Proactively communicate with business on any changes required to conceptual, logical, and Physical models, and communicate and review dependencies and risks.
    Development of ETL strategy and solution based on different sets of modules
    Understand the Tables and Relationships.
    Create low-level design documents and unit test cases.
    Create the workflows of package design
    Development and testing of data with Incremental and Full Load.
    Develop high-quality ETL mappings/scripts/jobs
    ETL data from Applications to Data Warehouse
    ETL data from Data Warehouse to Data Mart
    Perform unit tests.
    Performance Review, data Consistency checks
    Troubleshoot performance issues, ETL Load issues, log activity for each Individual package and transformation.
    Review Performance of ETL Overall.
    End to end Integrated testing for Full Load and Incremental Load
    Plan for Go Live, Production Deployment.
    Create production deployment steps.
    Configure parameters, and scripts for go live. Test and review the instructions.
    Create release documents and help build and deploy code across servers.
    Go Live Support and Review after Go Live.
    Review existing ETL processes, and tools and provide recommendations on improving performance and reducing ETL timelines.
    Review Infrastructure and any pain points for overall process improvement
    Knowledge Transfer to Ministry staff, development of documentation on the work completed.
    Document share and work on the ETL end-to-end working knowledge, Troubleshooting steps, configuration, and script review.
    Transfer documents, scripts, and review of documents.

    Must-Have:
    Experience of 7+ years of working with SQL Server, ADF, and T-SQL Development
    Experience working with building Databases, Data Warehouse, and Data Mart and working with delta / incremental and full loads.
    Experience with any ETL tools such as SQL Server, ADF, Cloud tools
    Experience working with MSSQL Seon-premise mise and within Azure Environment
    7+ years in ETL tools such as Microsoft SSIS, stored procedures
    2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines

    Nice to Have:
    2+ years Python
    Databricks
    Synapse
    Ability to present technical requirements to the business

    Evaluation Criteria:
    Design Documentation and Analysis Skills
    Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
    Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises, and reviews.
    Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
    Work with the Client & Developer(s) assigned to refine/confirm Business Requirements
    Participate in defect fixing, testing support and development activities for the ETL tool. Assist with defect fixing and testing support for Power BI reports.
    Analyze and document solution complexity and interdependencies by function including providing support for data validation.

    Development, Database, and ETL experience
    Demonstrated experience in Microsoft-specific software development and a number of years of practical experience (minimum 7+ years)
    Proven experience in developing in Azure DevOps
    Experience in application mapping to populate data vault and dimensional data mart schemas
    Demonstrated experience in Extract, Transform & Load and Extract, Load and Transforms software development and a number of years of practical experience (minimum 7+ years)
    Experience in providing ongoing support on Azure pipeline/configuration and SSIS development
    Experience building data ingesting and change data capture using Golden Gate (an asset but not mandatory)
    Assist in the development of the pre-defined and ad-hoc reports and meet the coding and accessibility requirements.
    Demonstrated experience with Oracle and Microsoft interfaces
    Proficient in SQL and Azure DevOps
    Implementing logical and physical data models

    Knowledge Transfer
    The Developer must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. The resource must develop learning activities using the review-watch-do methodology & demonstrate the ability to prepare and present.
    Development of documentation and materials as part of a review and knowledge transfer to other members
    Development and facilitation of classroom-based, or virtual instructor demo-led sessions for Developers
    Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed

    Notes:
    Hybrid Role- 30 days per on-site required.

  • Maarut Inc

    ETL Developer

    Found in: Zoho Direct Apply - 17 hours ago

    Maarut Inc Toronto, Canada

    Job Deliverables: · Work with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support of Azure Cloud data technologies such as Azure Data Factory, Databricks, Azure Synapse and/or SQL Data ...

  • Maarut Inc

    ETL BI Developer

    Found in: Zoho Direct Apply - 1 day ago

    Maarut Inc Toronto, Canada

    Resource Profile · This requirement is for a ETL and BI Developer to work with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and ...

  • Maarut Inc

    RQ07429 - Software Developer - ETL - Senior

    Found in: Zoho Direct Apply - 5 days ago

    Maarut Inc Toronto, Canada

    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 · DELIVERABLES: · Provide best practice migration solutions and oversee all facil ...

  • AMISEQ

    ETL Developer

    Found in: Appcast CA C2 A - 21 hours ago

    AMISEQ Toronto, Canada

    MANDATORY REQUIREMENTS: · 7+ years of experience in developing data conversion and migration · Extensive experience in data migration in terms of digital transformation,ETL experience in migrating data from legacy applications to modernized solutions. · Experience in migrating do ...

  • Maarut Inc

    RQ07422 - Software Developer - ETL - Senior

    Found in: Zoho Direct Apply - 5 days ago

    Maarut Inc Toronto, Canada

    Responsibilities: · Assist with the design and configuration of the cloud infrastructure to optimally support IDMC. · Mentor and support our ETL developers in their transition to IDMC. · Help with the ETL code conversion from legacy Informatica PowerCenter to IDMC; · Help with ET ...

  • Tata Consultancy Services

    ETL Developer

    Found in: Appcast CA C2 A - 21 hours ago

    Tata Consultancy Services Toronto, Canada

    About TCS · TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to ha ...

  • Lorven Technologies

    Senior ETL Developer

    Found in: Talent CA C2 - 2 days ago

    Lorven Technologies Toronto, Canada

    Job Title: Senior ETL Developer · Job Location: Toronto, Canada (onsite) · Job Type: Contract 12+ Months (T4/ Incorporated) · Skills · Must have · Bachelor's degree in Computer Science, Information Systems, or a related field. · Proven experience working with ETL tools (Dat ...

  • CB Canada

    ETL Cloud Developer

    Found in: Talent CA 2 C2 - 15 hours ago

    CB Canada Toronto, Canada

    The opportunity · Reporting to the Vice President of Enterprise Applications and working on the integration team, we are looking for an ETL Cloud Developer. You will play a vital role in designing, developing and supporting a new real estate cloud-based data platform that support ...

  • Global Pharma Tek

    Software Developer ETL

    Found in: Talent CA C2 - 5 days ago

    Global Pharma Tek Toronto, Canada Contract

    Title: Software Developer - ETL Senior · Location: Toronto, ON (Hybrid) · Duration: Business Days + Possible extension · Job Description: Full life-cycle data conversion experience with enterprise systems, including deployment experience. · Experience working with all steps o ...

  • Tata Consultancy Services

    IBM Datastage/ETL Developer

    Found in: Appcast CA C2 A - 21 hours ago

    Tata Consultancy Services Toronto, Canada

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity ...

  • Foilcon

    ETL Developer 7422-0114

    Found in: Talent CA C2 - 5 days ago

    Foilcon Toronto, Canada Contract Corp-to-Corp

    HM Note: This hybrid role is three (3) days in office · Responsibilities: · Assist with the design and configuration of the cloud infrastructure to optimally support IDMC. · Mentor and support our ETL developers in their transition to IDMC. · Help with the ETL code conversion fro ...

  • NR Consulting

    Senior ETL Software Developer

    Found in: Talent CA C2 - 5 days ago

    NR Consulting Toronto, Canada

    Title :: Senior ETL Software Developer (- Days Onsite/Hybrid) · Location :: Toronto, ON, Canada · Duration : Contract · SCOPE: · A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migrat ...

  • GTT, LLC

    Senior Software Developer ETL

    Found in: Talent CA C2 - 5 days ago

    GTT, LLC Toronto, Canada Contract

    Senior Software Developer ETLContract Duration 2+ years · 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 · Deliverables: · Provi ...

  • GTT, LLC

    Senior Informatica ETL Developer

    Found in: Talent CA C2 - 5 days ago

    GTT, LLC Toronto, Canada Contract

    Senior Informatica ETL Developer /Senior Software Developer (ETL)Contract Duration 18+ Months · Job Overview:The Senior Software Developer (ETL) with strong experience using IDMC will: · mentor and support our ETL developers in their transition to IDMC · help with the ETL code co ...

  • NR Consulting

    Sr. ETL Software Developer

    Found in: Talent CA C2 - 1 day ago

    NR Consulting Toronto, Canada

    Title :- Sr. ETL Software Developer - ( - Days Onsite/Hybrid) · Location :- Toronto, ON, Canada · Mode :- Contract · Description · Responsibilities: · • Support the branch in developing and implementing the technical solutions needed as well as providing operational sup ...

  • dentalcorp

    Intern, Junior ETL Developer

    Found in: beBee S2 CA - 1 week ago

    dentalcorp Toronto, Canada TEMPORARY

    This is a full time short-term internship opportunity starting May 2024 until August 2024. · Application Deadline is April 16th, 2024 · Who you are · You are a service-oriented individual who is excited to be a part of a fast-growing organization that enables the best to be even ...

  • Foilcon

    ETL Software Developer 7429-0112

    Found in: Talent CA C2 - 5 days ago

    Foilcon Toronto, Canada Contract Corp-to-Corp

    HM Note: This hybrid role is three (3) days in office · Description: · • 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 · DELIVERABLES: ...

  • Novo Nordisk A/S

    Senior ETL Developer

    Found in: Talent CA C2 - 2 days ago

    Novo Nordisk A/S Mississauga, Canada

    PURPOSE OF THE JOB · The primary purpose of the Senior Extract Transform Load (ETL) Developer is to help develop and deploy data warehouse BI solutions, data analytics and data integrations that support business processes and reporting needs of the organization and provide opera ...

  • Novo Nordisk

    Senior ETL Developer

    Found in: Talent CA C2 - 2 days ago

    Novo Nordisk Mississauga, Canada

    PURPOSE OF THE JOB · The primary purpose of the Senior Extract Transform Load (ETL) Developer is to help develop and deploy data warehouse BI solutions, data analytics and data integrations that support business processes and reporting needs of the organization and provide operat ...

  • Maarut Inc

    RQ06212 - Specialized IT Consultant - Intermediate

    Found in: Zoho Direct Apply - 3 days ago

    Maarut Inc Toronto, Canada

    Responsibilities: · Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organization's I&IT systems. · The I&IT Consultant may be used to provid ...