ETL Informatica Developer

Role Description
ETL Informatica Developer
Lead II - Software Engineering
Who We Are
Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world.

UST is a mission-driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live.

With us, you'll create a boundless impact that transforms your career—and the lives of people across the world.

Visit us at

You Are
The ideal candidate should be a strong ETL/SQL Developer capable of working with both on-premise and cloud-based data integration tools. They should have solid experience in Informatica, good working knowledge of modern data warehousing (Snowflake), and familiarity with transformation frameworks like DBT.

The Opportunity

• Design, develop, and maintain ETL workflows using Informatica PowerCenter or Informatica Cloud (IICS/IDMC).
• Build complex data mappings, transformations, and workflows to support data integration, migration, and data warehousing initiatives.
• Optimize and tune ETL jobs for performance, scalability, and reliability.
• Troubleshoot ETL failures, debug workflow issues, and ensure data quality, accuracy, and integrity across systems.
• Collaborate with data architects and business analysts to translate requirements into efficient ETL solutions.
• Write, optimize, and maintain complex SQL queries, stored procedures, functions, and scripts for data processing and validation.
• Provide production support, identify root causes of issues, and drive continuous improvement in data pipelines.

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

What You Need

• Strong hands-on experience with Informatica PowerCenter or Informatica Cloud (IICS/IDMC) for building, maintaining, and optimizing ETL workflows.
• Ability to design and implement complex data mappings, transformations, and workflows to support data integration, data migration, and data warehousing initiatives.
• Proficiency in troubleshooting ETL performance issues, debugging workflows, and ensuring data accuracy and integrity.
• Expert-level SQL programming skills with the ability to write complex queries, stored procedures, functions, and performance-tuned database code.
• Solid understanding of relational database concepts, schema design, query optimization, indexing strategies, and data modeling.
• Comfortable working with large datasets and performing data analysis or data validation using SQL.
• Additional Technical Skills
• Good understanding of Snowflake architecture, including virtual warehouses, micro-partitioning, stages, and data sharing.
• Ability to build ELT pipelines in Snowflake, write optimized SQL specific to Snowflake, and work with Snowflake features like Streams, Tasks, and Time Travel.
• Understanding of cloud platforms (AWS/Azure/GCP) as they relate to Snowflake deployment.
• Experience building data transformations using DBT models, tests, documentation, and project structure.
• Knowledge of version-controlled SQL-based transformations and modular data modeling practices.
• Understanding of CI/CD practices as they relate to DBT pipelines.

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below.

Role Location: Remote-Canada
Compensation Range
: $104,000-$130,000

Benefits
Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year), paid holidays, and are eligible for paid bereavement leave and jury duty. They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Full-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year). They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Part-time regular and temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year).

All Canadian employees who work in a province, territory or locality with more generous paid sick leave benefits than specified here will receive the benefit of those sick leave laws.

What We Believe
We proudly embrace the values that have shaped UST since day one. We build our culture of Humility, Humanity, and Integrity. These values inspire us to nurture a people-first, human centric culture that fosters diversity, prioritizes sustainable solutions, and keeps our people and clients at the forefront of all decisions.

Humility
We will listen, learn, be empathetic and help selflessly in our interactions with everyone.

Humanity
Through business, we will better the lives of those less fortunate than ourselves.

Integrity
We honor our commitments and act with responsibility in all our relationships.

An Equal Opportunity Workplace, Free of Discrimination and Harassment
At UST, we strive to provide a work environment free of discrimination and harassment. We are an equal opportunity employer and employment decisions are based on merit and business needs. Our Human Rights Policy further illustrates our stand on this. We are committed to following fair employment practices that provide equal opportunities to all employees. We do not discriminate or allow harassment on the basis of race, color, religion, disability, gender, national origin, sexual orientation, gender identity, gender expression, age, genetic information, military status, or any other legally protected status. At UST, we value diversity and believe that a diverse workplace builds a competitive advantage.

Un lieu de travail à égalité des chances, sans Discrimination et harcèlement
Chez UST, nous nous efforçons de fournir un environnement de travail exempt de discrimination et harcèlement. Nous sommes un employeur garantissant l'égalité des chances et des décisions en matière d'emploi sont basés sur le mérite et les besoins de l'entreprise. Notre politique en matière de droits de l'homme illustre notre position à ce sujet. Nous nous engageons à respecter un emploi équitable des pratiques qui offrent des chances égales à tous les employés. Nous ne faisons pas discriminer ou permettre le harcèlement sur la base de la race, de la couleur, de la religion, du handicap, genre, origine nationale, orientation sexuelle, identité de genre, expression de genre, âge, informations génétiques, statut militaire ou tout autre statut légalement protégé. Chez UST, nous valorisons la diversité et pensons qu'un lieu de travail diversifié crée un avantage compétitif.

UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.

Skills
Etl,Sql,Snowflake,DBT