ETL Developer

1 day ago

Toronto, Ontario, Canada Spait Infotech Private Limited Full time

Job Title: ETL Developer

Job Summary

The ETL Developer is responsible for designing, developing, and maintaining data integration solutions that enable the extraction, transformation, and loading of data from various sources into data warehouses, data lakes, or other storage systems. This role ensures data quality, consistency, and availability to support business intelligence (BI), analytics, and reporting initiatives.

Key Responsibilities

  • Design and develop ETL processes to extract data from multiple sources (databases, APIs, flat files, etc.), transform it according to business rules, and load it into target data systems (e.g., data warehouse).
  • Build and maintain data pipelines to support analytics, reporting, and data science workloads.
  • Optimize ETL workflows for performance, scalability, and reliability.
  • Perform data profiling, cleansing, and validation to ensure data accuracy and consistency.
  • Collaborate with data analysts, BI developers, and stakeholders to understand data requirements and deliver reliable datasets.
  • Monitor and troubleshoot ETL jobs to ensure timely and accurate data delivery.
  • Document ETL processes, data mappings, and data flow diagrams.
  • Implement best practices for data governance, version control, and process automation.
  • Work with cloud and on-premise data environments (e.g., AWS, Azure, Google Cloud, SQL Server, Oracle, Snowflake, etc.).

Required Skills and Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
  • 3+ years of experience in ETL development or data engineering.
  • Strong proficiency with ETL tools such as:
  • Informatica PowerCenter / Cloud Data Integration
  • Talend
  • Microsoft SSIS (SQL Server Integration Services)
  • Apache NiFi, DataStage, or similar platforms
  • Advanced SQL skills for data extraction and transformation.
  • Experience working with data warehouses (e.g., Snowflake, Redshift, BigQuery, Synapse).
  • Familiarity with scripting languages (Python, Shell, etc.) for data automation.
  • Understanding of data modeling concepts (Star/Snowflake schemas).
  • Knowledge of data governance, metadata management, and data quality principles.
  • Strong problem-solving and analytical skills.
  • Excellent communication and documentation abilities.

Job Types: Full-time, Permanent

Pay: $75,000.00-$90,000.00 per year

Benefits:

  • Work from home

  • ETL Developer

    1 week ago

    Toronto, Ontario, Canada fc71e8c5-deda-48e9-b38c-23c0611c543b Full time $70,000 - $120,000 per year

    ResponsibilitiesDesign, develop, and optimize scalable ETL workflows to extract data from various sources such as relational databases, cloud storage (AWS, Azure Data Lake), and APIs (RESTful API).Transform raw data into structured formats suitable for analysis and reporting, ensuring accuracy and consistency.Maintain and enhance existing ETL pipelines using...

  • ETL Developer

    23 hours ago

    Toronto, Ontario, Canada Source Code Full time $80,000 - $120,000 per year

    ETL Developer (ETL Azure Data Factory, Databricks, Logic App and Function App, IBM Cognos and Microsoft PowerBI, SQL Server Stored Procedure, Oracle PL/SQL)1 year contract (with possibility of renewal)Toronto (hybrid)Deliverables section:Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the...

  • ETL Java developer

    2 weeks ago

    Toronto, Ontario, Canada LTIMindtree Full time $80,000 - $120,000 per year

    Role: ETL Java developerTerm: Full TimeLocation: Toronto, ON (hybrid)Key skills: ETL developer with Java Springboot; MarkitEDM experience preferred but no mandatory; Database/MySQL knowledge and understandingRole OverviewThe ETL & Java Senior Developer will be responsible for designing, developing, and maintaining efficient data integration and management...

  • Senior ETL Developer

    2 weeks ago

    Toronto, Ontario, Canada The Code Crackers Full time $65,000 - $780,000 per year

    Position OverviewThe Office of the Public Guardian and Trustee (OPGT) seeks a Senior Software Developer – ETL to support and validate the migration of data from legacy systems to the new Dynamics 365 OPGT solution. The ideal candidate will have extensive experience in ETL development, Azure data services, and Dynamics 365 data integrations.You will play a...

  • Senior ETL Developer

    1 week ago

    Toronto, Ontario, Canada Russell Tobin Full time $96,000 - $144,000 per year

    Title:Software Developer - ETL - Senior (Onsite)Business Days:130Location:Toronto, OntarioPay Range:CAD$75-80/hr. DOEIndustry Type:Public SectorJob Description:Assignment Deliverables:As a member of the data migration team, you will be responsible for validating the quality of the data migration from the legacy application to Dynamics, in preparation for...

  • Senior ETL Developer

    1 week ago

    Toronto, Ontario, Canada BuzzClan Full time $80,000 - $120,000 per year

    Job Title:ETL DeveloperLocation:Toronto, ONDuration:ContractSeeking an experiencedETL Developerto support a critical data migration from legacy systems toDynamics 365 CE. You'll validate data quality, execute transformation logic, develop and run test cases, and ensure accurate, complete, and secure data migration using Azure cloud tools.Key Requirements:5+...

  • Senior ETL Developer

    1 week ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    RQ Software Developer - ETL – SeniorLocation:Onsite / 595 Bay Street, TorontoPeriod:  6-monthsMust-haves:·      5+ years of proven working experience in an ETL role;strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding of data pipeline...

  • Senior ETL Developer

    1 week ago

    Toronto, Ontario, Canada CARET Full time $110,000 - $113,000

    Job Details Job Location:    Toronto, ON - Toronto, Ontario Salary Range:    $ $ Salary/year DescriptionWe are looking for a highly experienced Senior ETL Developer to design, develop, and optimize enterprise-grade data and application solutions. This role requires deep expertise in ETL development, cloud platforms (Azure & AWS), and web...

  • Informatica ETL developer

    1 week ago

    Toronto, Ontario, Canada Themesoft Inc. Full time $100,000 - $120,000 per year

    Role: Informatica developerLocation: Toronto Canada…4 days work from clients Toronto office.Skill SetInformatica ETL experience 8+ YearsUnix/SQL queriesAzure cloud nice to have

  • ETL Developer

    1 week ago

    Toronto, Ontario, Canada Tekshapers Full time $120,000 - $180,000 per year

    Job Title: IDMC DesignerLocation: Toronto, ONFull TimeExperience: 10+YearsJD•Must Have Overall 10 years of expertise in Informatica PowerCenter (7 years) IDMC (3 years) and IDQ components•Must have reliability clearance (min. 5yrs of experience in Canada)•Strong SQL skills are essential for data manipulation and querying.•Expert in data warehousing,...