Return to jobs

RQ06016 - SA Data Platform-Bus. Intelligence Specialist(ETL Developer)

Ref: CA_EN_6_919740_1512788

Posted on 14 September 2023
Toronto, Ontario
Contract Type

Company Overview:

Our government client is seeking an experienced ETL Developer to join their dynamic data team and play a key role in transforming raw data into actionable insights.

Position Overview:

You will be responsible for designing, developing, and maintaining ETL processes to extract data from various sources, transform it into a suitable format, and load it into our data warehouse. You will work closely with data analysts, data engineers, and other stakeholders to ensure the availability and accuracy of data for analytical purposes.


Data Extraction: Design and implement ETL processes to extract data from diverse sources, such as databases, APIs, flat files, and external systems.

Data Transformation: Cleanse, transform, and enrich raw data to ensure it meets quality and consistency standards. Create and maintain data mappings, transformations, and business rules.

Data Loading: Load processed data into the data warehouse or target databases using ETL tools and technologies.

ETL Development: Develop and maintain ETL scripts, workflows, and pipelines using tools like Talend, Informatica, or custom scripts as required.

Data Quality Assurance:  Implement data quality checks and validation procedures to identify and resolve data anomalies and discrepancies.

Performance Optimization:  Monitor and optimize ETL processes for efficiency and scalability.  Troubleshoot and resolve ETL-related issues in a timely manner. 

Documentation:  Maintain comprehensive documentation of ETL processes, including data lineage, transformations, and job scheduling.

Collaboration:  Collaborate with cross-functional teams to understand data requirements and ensure ETL solutions align with business needs.

Security and Compliance:  Ensure data security and compliance with data protection regulations (e.g., GDPR, PIPEDA).


·       Bachelor's degree in Computer Science, Information Technology, or related field.

·       Proven experience as an ETL Developer or similar role.

·       Proficiency in ETL tools and technologies such as Talend, Informatica, Apache Nifi, or similar.

·       Strong SQL skills for data manipulation and querying.

·       Familiarity with data warehousing concepts and data modeling.

·       Knowledge of data integration best practices and methodologies.

·       Experience with scripting languages (e.g., Python, Java) is a plus.

·       Excellent problem-solving skills and attention to detail.

·       Strong communication and teamwork abilities.

If you are a skilled ETL Developer with a passion for turning data into valuable insights and want to be part of a forward-thinking organization, we encourage you to apply for this position. 

Find your local office.

Find your local office. Modis has over 100 offices in the United States, Canada and Europe. With both industry and location-specific expertise, our people know their area and their labor market and can find the right position for you.