Integration Engineer

Role : Integration Engineer

Term : Full Time

Location : Mississauga, ON (Hybrid- days onsite per week)

Job Description :

We are seeking for an Integration engineer with a background in SSIS, Python, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise.

Responsibilities :

• Provide Level / support of existing ETL processes.
• Monitor and troubleshoot Scheduled ETL jobs, identify and resolve issues or bottlenecks.
• Proficient in developing ETL processes in SSIS, Python and SQL (SQL Server / Oracle)
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process.
• Build and optimize data pipelines for efficient data ingestion, transformation and loading from various sources while ensuring data quality and integrity.
• Working with structured, semi structured and unstructured data.
• Implement best practices for data management, security, and governance.
• Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.

Requirements :

Preferred, but not required :