Job Title

Senior Software Developer (Contract Position)Number of Positions: 1 Duration: 6 months initial contractLocation: Toronto, ON, CAMust be eligible to work in CanadaHybrid position, 2-3d/w onsite in Toronto, 7hr/d billing, no exceptions Roles and responsibilities We are seeking a highly technical, hands-on Senior Software Developer to join our client's team for a critical ETL migration project. This role focuses on the transition from on-premises Informatica environments to Snowflake and modern Lakehouse architectures.The ideal candidate is an execution-focused developer who thrives on redesigning legacy pipelines for cloud-native performance and translating complex ETL logic into optimized SQL.Key ResponsibilitiesETL Migration: Lead the migration of legacy Informatica workflows to Snowflake using an ELT model.Lakehouse Implementation: Implement and support Apache Iceberg tables within a Lakehouse architecture.Redesign & Optimization: Analyze existing on-prem pipelines to redesign them for high-performance cloud execution.Data Ingestion: Work with S3 (or similar object storage) for staging and ingestion.SQL Development: Convert complex ETL logic into highly optimized SQL transformations.Validation & Testing: Perform rigorous data validation, reconciliation, and manage parallel run testing to ensure data integrity.Performance Tuning: Troubleshoot and optimize pipeline performance within the Snowflake environment.Reporting Support: Support downstream analytics and reporting via Power BI.Must have skills/experience/qualificationsExperience: 7+ years in Data Engineering or ETL Development.Informatica Mastery: Proven expertise in Informatica PowerCenter or IICS.Migration Background: Hands-on experience in at least one major on-prem-to-cloud ETL migration project.Snowflake Expertise: Direct experience with Snowflake data loading, ELT transformations, and performance tuning.Object Storage: Working knowledge of S3 or equivalent file systems.Advanced SQL: Exceptional skills in writing complex transformations and performance optimization.Reporting: Hands-on experience building reports and dashboards in Power BI.Modern Data Formats: Exposure to Apache Iceberg and familiarity with Parquet/Avro file formats.Nice to have /additional qualificationsStrong understanding of ETL ELT conversion patterns.Basic proficiency in Python or general scripting.Experience working within an Agile project delivery framework.Excellent communication skills in English (written and verbal).Proven ability to collaborate with cross-functional teams including BAs, QAs, and Architects.