Job Description :

Role: ETL Developer

Location: Kantana, Ottawa

Job Type - Contract

Key Job Functions:

• Provide Level 2/3 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.

Required Skills:

• 5+ years SSIS development experience
• 5+ years Python coding experience.
• 5+ years SQL Server based development of large datasets

Additional Skills:

• Experience in Financial Services industry
• Experience with Enterprise Schedulers / Orchestration platforms such as Tidal, Airflow.
• Experience in any cloud data warehouse like Snowflake.
• Experience in Data warehousing - OLTP, Dimensions, Facts, and Data modeling.
• Experience with Cloud based data architectures, messaging, and analytics.
• Experience with developing and deploying ETL pipelines using Databricks Pyspark.