Senior Platform Developer

Klick; Toronto; On-site; CAD 100,000 - 120,000; Full time

Job summary

The Klick Group is seeking a hands‑on Intermediate Platform (Integration) Developer to build and maintain scalable data pipelines across databases, data lakes, data warehouses, and CRM ecosystems. You will evaluate tools to select the best fit for each use case and ensure security and reliability in end‑to‑end data flows.

Ideal candidates bring 5–7 years of integration experience, strong Informatica IDMC skills, and hands‑on experience with cloud data platforms and API integrations.

Qualifications

• 5–7 years of experience in data integration and platform development, with strong hands‑on expertise in Informatica IDMC (CDI and CAI modules).
• Working knowledge of Workato for integration and automation workflows.
• Hands‑on experience with integration and data enablement across secure file systems, databases, data warehouses/lakehouses, and CRM systems.
• Experience with cloud data warehouse/lakehouse platforms such as Databricks, Microsoft Fabric, PostgreSQL, Redshift, and/or Synapse.
• Hands‑on experience with REST/SOAP API integrations, parameterized mappings, and taskflows.
• Solid understanding of data modeling, data warehousing/lakehouse architecture, and ETL/ELT best practices.
• Experience working with Salesforce objects, metadata, and integration patterns.

Responsibilities

• Design, develop, test, and deploy robust integration mappings, tasks, and processes using Informatica IDMC (CDI and CAI modules), Workato, or similar platforms.
• Build scalable integrations between file systems, databases/data lakes, data warehouses/lakehouses, CRM platforms (Salesforce, Veeva), and downstream systems.
• Design and support data pipelines and models across modern data warehouse/lakehouse platforms such as Databricks, Microsoft Fabric, PostgreSQL, Redshift, and Synapse.
• Collaborate with Solution Architects, Developers, and Business Analysts to translate data and integration requirements into functional, well‑architected pipelines.
• Apply a solution‑oriented mindset to evaluate trade‑offs between integration and data platform tools, recommending the best‑fit approach for each use case.
• Implement data quality checks, error handling, and performance tuning in pipelines.
• Support UAT, deployment, and operational handover of developed assets.
• Maintain documentation for developed solutions and contribute to data cataloging efforts.
• Participate in scope planning, code reviews, and team retrospectives as part of the end‑to‑end delivery.
• Assist in monitoring and troubleshooting existing integration pipelines and resolve issues in a timely manner.

Skills

Informatica IDMC

Workato

SQL

Python

Shell scripting

REST/SOAP APIs

Data modeling

Cloud data platforms

Tools

Databricks

Microsoft Fabric

PostgreSQL

Redshift

Snowflake

Job description

The Klick Group

—comprising Klick Health (including Klick Katalyst and btwelve), Klick Media Group, Klick Applied Sciences (including Klick Labs), Klick Consulting, and Klick Ventures is an ecosystem dedicated to realizing the full potential of our people and clients in life sciences. Founded in 1997, we have offices in New York, Philadelphia, Saratoga Springs, Toronto, London, São Paulo, and Singapore. Consistently named a Best Managed Company, Most Admired Corporate Culture, and Great Place to Work, Klick is committed to fostering a high-performance, people-first culture with creativity, collaboration, innovation, and impact across everything we do.

About Our Technology Craft

Our Technology Craft powers Klick’s innovation through platforms, products, and emerging technologies. This craft enables scale, efficiency, and experimentation across the business. Technology teams transform ideas into functional, future-ready solutions. Their work supports both client delivery and internal growth.

Job Description

We are seeking a hands‑on, detail‑oriented Intermediate Platform (Integration) Developer to join our team. In this role, you will be responsible for building and maintaining integration and data pipelines that enable scalable and secure data flows across databases, data warehouses/lakehouses, file systems, and CRM ecosystems (such as Salesforce Data Cloud, SFMC, Acoustic, Veeva Vault CRM, etc.). You will bring a solution‑oriented mindset to every engagement, evaluating the right tool and pattern for the problem at hand across our integration and data platform toolkit.

What You’ll Do

• Design, develop, test, and deploy robust integration mappings, tasks, and processes using Informatica IDMC (Cloud Data Integration/CDI and Cloud Application Integration/CAI), Workato, or similar platforms.
• Build scalable integrations between file systems, databases/data lakes, data warehouses/lakehouses, CRM platforms (Salesforce, Veeva), and downstream systems.
• Design and support data pipelines and models across modern data warehouse/lakehouse platforms such as Databricks, Microsoft Fabric, PostgreSQL, Redshift, and Synapse.
• Collaborate with Solution Architects, Developers, and Business Analysts to translate data and integration requirements into functional, well‑architected pipelines.
• Apply a solution‑oriented mindset to evaluate trade‑offs between integration and data platform tools, recommending the best‑fit approach for each use case.
• Implement data quality checks, error handling, and performance tuning in pipelines.
• Support UAT, deployment, and operational handover of developed assets.
• Maintain documentation for developed solutions and contribute to data cataloging efforts.
• Participate in scope planning, code reviews, and team retrospectives as part of the end‑to‑end delivery.
• Assist in monitoring and troubleshooting existing integration pipelines and resolve issues in a timely manner.

Qualifications

Required

• 5–7 years of experience in data integration and platform development, with strong hands‑on expertise in Informatica IDMC (CDI and CAI modules).
• Working knowledge of Workato for integration and automation workflows.
• Hands‑on experience with integration and data enablement across secure file systems, databases, data warehouses/lakehouses, and CRM systems.
• Experience with cloud data warehouse/lakehouse platforms such as Databricks, Microsoft Fabric, PostgreSQL, Redshift, and/or Synapse.
• Hands‑on experience with REST/SOAP API integrations, parameterized mappings, and taskflows.
• Solid understanding of data modeling, data warehousing/lakehouse architecture, and ETL/ELT best practices.
• Experience working with Salesforce objects, metadata, and integration patterns.
• Familiarity with cloud platforms (AWS, Azure, or GCP) and data security concepts.
• A solution‑oriented mindset with strong problem‑solving, debugging, and communication skills.
• Hands‑on experience writing SQL and shell/Python scripts.

Desired

• Knowledge of Salesforce Sales Cloud, Data Cloud, and Marketing Cloud.
• Additional experience with SQL and databases, including Microsoft Fabric, Snowflake, and other relational or analytical data stores.
• Knowledge of other ETL/integration platforms such as MuleSoft.
• Experience in the life sciences or healthcare domain.
• Certifications in Informatica IDMC and/or Workato.

Additional Information

This role is for a backfill at Klick. The base salary range for this position is between CAD $100,000 - $120,000. The final amount offered will be determined based on several factors such as a candidate's work location, their unique skill set, education, and prior work experience. This posting is for an existing vacancy at Klick.

Our Commitment to Inclusion

Klick is consciously creating a culture where everyone can thrive and grow in their careers. We believe that our best work comes from our diverse backgrounds, perspectives, and skills. We strongly encourage members of historically underrepresented communities to apply, including Black people, Indigenous peoples, and other people of color, people with disabilities, people from gender and sexually diverse communities and people with intersectional identities. We're also committed to developing an inclusive, barrier‑free recruitment process and work environment. Should you require any accommodation, please contact us at [e-mail] and we will work with you to meet your accessibility needs and ensure you have a positive experience.