Senior Platform Developer

United States Digital Space LLC; Toronto; On-site; CAD 100,000 - 120,000; Full time

Job summary

The Klick Group in Toronto is seeking an experienced Intermediate Platform (Integration) Developer to design, build, and maintain integration and data pipelines across databases, data warehouses/lakehouses, file systems, and CRM ecosystems.

You will work with Informatica IDMC, Workato, and cloud platforms (Databricks, Microsoft Fabric, PostgreSQL, Redshift, Synapse) to deliver scalable, secure data flows and support end-to-end delivery with a focus on data quality and documentation.

Qualifications

• 5-7 years of data integration and platform development experience with Informatica IDMC (CDI/CAI).
• Hands-on with Workato for integration and automation workflows.
• Experience across secure file systems, databases, data warehouses/lakehouses, and CRM systems.
• Experience with Databricks, Microsoft Fabric, PostgreSQL, Redshift, and Synapse.
• REST/SOAP API integrations and parameterized mappings.
• Familiarity with Salesforce objects/integration patterns and cloud platforms (AWS/Azure/GCP).
• Proven SQL and Python/shell scripting skills.

Responsibilities

• Design, develop, test, and deploy robust integration mappings and processes using Informatica IDMC (CDI/CAI) or similar platforms.
• Build scalable integrations between file systems, databases/data lakes, data warehouses/lakehouses, and CRM platforms.
• Design and support data pipelines across Databricks, Microsoft Fabric, PostgreSQL, Redshift, and Synapse.
• Collaborate with architects, developers, and analysts to translate data and integration requirements into pipelines.
• Evaluate trade-offs between tools and recommend best-fit approaches for each use case.
• Implement data quality checks, error handling, and performance tuning in pipelines.
• Support UAT, deployment, and handover of developed assets.
• Maintain documentation and contribute to data cataloging.
• Participate in scope planning, code reviews, and team retrospectives.
• Monitor and troubleshoot existing integration pipelines and resolve issues promptly.

Skills

Informatica IDMC

Workato

SQL

Python

Shell scripting

REST API

SOAP API

Salesforce integration

Data modeling

Problem solving

Tools

Databricks

Microsoft Fabric

PostgreSQL

Redshift

Synapse

Salesforce

Veeva Vault CRM

Job description

Company Description

The Klick Group - comprising the company (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.

#LI-TH1 #LI-Hybrid

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.