Skills Required

We are seeking a skilled Data Integration Developer to join our data engineering team. You will be responsible for designing, developing, and maintaining robust data pipelines and infrastructure that ensure data quality, traceability, and compliance across our enterprise systems.

Key Responsibilities
Data Pipeline Development: Design and implement ETL (Extract, Transform, Load) solutions using industry-standard tools to move and transform data across systems
Data Lineage & Governance: Document and maintain comprehensive data lineage to track data flow from source to destination, ensuring transparency and regulatory compliance
Database Management: Write and optimize complex SQL queries (Oracle, SQL Server, PostgreSQL) and manage database operations using DDL, DML, DQL, and DCL commands
Infrastructure Automation: Develop automation scripts and tools using Python to streamline data operations and reduce manual effort
Version Control: Manage code repositories using Git/GitHub, including branching, merging,



and code review collaboration
Unix Administration: Navigate and manage Linux/Unix environments for deployment, monitoring, and troubleshooting data systems
Quality Assurance: Implement data validation checks and ensure data integrity throughout the pipeline lifecycle Required Qualifications
Proven experience with ETL tools (e.g., Informatica, Talend, Apache Airflow, or similar platforms)
Solid proficiency in Python for scripting and data processing
Hands-on experience with multiple SQL databases (Oracle, SQL Server, PostgreSQL)
Solid understanding of data lineage concepts and best practices
Competent with Git/GitHub for version control
Comfortable working in Unix/Linux settings
Knowledge of SQL DDL, DML, DQL, and DCL operations
Experience with cloud data platforms (AWS, Azure, GCP) Knowledge of data quality.

📌 Integration Consultant Toronto
🏢 Zodiac Solutions
📍 Toronto