Job Title: Data Integration Developer
Location: Toronto, Ontario (ON)
Work Arrangement: Onsite 4 Days
Job Type: Full Time
Job Summary
We are seeking an experienced Data Integration Developer to design, develop, and maintain robust data pipelines and infrastructure across enterprise systems. The ideal candidate will have strong expertise in ETL, Python, SQL, data lineage, data governance, automation, and cloud data platforms.
Key Responsibilities
- Design and develop ETL (Extract, Transform, Load) solutions to move and transform data across enterprise systems
- Build and maintain scalable and reliable data pipelines
- Document and maintain end-to-end data lineage from source to destination
- Ensure data flows meet enterprise data governance, quality, traceability, and compliance requirements
- Write and optimize complex SQL queries across Oracle, SQL Server, and PostgreSQL
- Perform database operations using Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), and Data Control Language (DCL)
- Develop Python scripts and automation tools to streamline data operations and reduce manual effort
- Manage source code repositories using Git and GitHub
- Participate in branching, merging, pull requests, and code reviews
- Work in Linux/Unix environments for deployment, monitoring, and troubleshooting
- Implement data validation and quality checks throughout the data pipeline lifecycle
- Troubleshoot data integration issues and perform root cause analysis
- Support cloud-based data platforms and enterprise data integration initiatives
Required Qualifications
- Proven experience with ETL tools such as Informatica, Talend, Apache Airflow, or similar platforms
- Strong proficiency in Python for scripting and data processing
- Hands-on experience with Oracle, SQL Server, and PostgreSQL
- Strong understanding of data lineage and data governance concepts
- Experience with Git/GitHub and version control practices
- Strong knowledge of Unix/Linux environments
- Good understanding of SQL DDL, DML, DQL, and DCL
- Experience with cloud data platforms such as AWS, Azure, or Google Cloud Platform (GCP)
- Knowledge of data quality, validation, and integrity practices
- Strong analytical and troubleshooting skills
Key Skills
Data Integration, ETL, Informatica, Talend, Apache Airflow, Python, SQL, Oracle, SQL Server, PostgreSQL, Data Lineage, Data Governance, Git, GitHub, Unix, Linux, AWS, Azure, GCP, Data Quality, Data Pipelines, Automation
Job Type: Full Time