Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Data Engineer with strong Snowflake and IICS experience, focused on building and optimizing scalable data pipelines. Collaborating with stakeholders for efficient data integration and analytics.

Responsibilities

  • Build, optimize, and support scalable data pipelines and analytics-ready data models
  • Design and develop ELT data pipelines in Snowflake
  • Build Informatica IICS mappings for batch, mass ingestion, and incremental data ingestion
  • Develop and schedule IICS Taskflows for orchestration, dependencies, retries, and error handling
  • Integrate data from Oracle Fusion Analytics (FAW) into Snowflake using IICS
  • Monitor, troubleshoot, and optimize IICS workflows and data pipelines
  • Implement CI/CD pipelines for Snowflake and IICS assets
  • Use GitHub for source control, versioning, code reviews, and deployments
  • Write, optimize, and tune complex SQL for data transformations, CDC, and analytics use cases
  • Develop Snowflake stored procedures using SQL and Python
  • Implement incremental and near-real-time data processing using Snowflake Streams and Tasks
  • Support multi-environment Snowflake deployments (Dev, QA, Prod)
  • Automate deployment of Snowflake SQL objects, stored procedures using PowerShell
  • Provide production support, root cause analysis, and performance tuning
  • Collaborate with data analysts, architects, and business stakeholders
  • Document technical designs, standards, and operational procedures

Requirements

  • 6–10+ years of experience in Data Engineering or Data Warehousing
  • Strong hands-on experience with Snowflake
  • Advanced SQL skills, including query optimization and performance tuning
  • Hands-on experience with Informatica Intelligent Cloud Services (IICS) – Mappings / Transformations / Tasks / Taskflows
  • Experience in Data integration of Oracle Fusion Analytics (FAW)
  • Experience implementing CI/CD pipelines for data platforms
  • Strong experience using GitHub for version control and deployments
  • Solid understanding of ETL and ELT design patterns
  • Experience working with structured and semi-structured data (XML/JSON/Parquet)

Benefits

  • Medical, Dental, Vision and Life Insurance package
  • HSA and 401(k) options with company matching
  • Travel insurance
  • Access to EAP and Wellness programs, including LifeSpeak and Vitality
  • Volunteer support in the community

Job type

Full Time

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

No Education Requirement

Tech skills

CloudETLInformaticaOraclePythonSQL

Location requirements

RemoteCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.