Informatica Developer

Job Title: Senior ETL Informatica Developer

Location:
Remote, Canada

ob Summary

We are looking for a
Senior ETL Informatica Developer
with strong expertise in building and optimizing enterprise data integration solutions. The ideal candidate will have deep hands-on experience with
ETL/Informatica
and a solid foundational background as a
SQL Developer
. Experience with modern cloud-based data platforms such as
Snowflake
,
DBT
, and
IDMC
(Informatica Data Management Cloud) is highly desirable as the environment is transitioning to cloud-native technologies.

Primary Responsibilities

• Design, develop, and maintain ETL workflows using
  Informatica
  .
• Write complex SQL queries, stored procedures, functions, and performance-optimized scripts.
• Support data integration and transformation processes across multiple systems.
• Contribute to the modernization of the enterprise data platform, including migration to
  IDMC
  and
  Snowflake
  .
• Work closely with data architects, analysts, and platform engineers to ensure high-quality data delivery.
• Troubleshoot ETL failures, performance bottlenecks, and data quality issues.
• Collaborate with the data modeling team; one of the developers may support modeling work using
  erwin Data Modeler
  (experience not required but ability to learn is expected).
• Produce clear and concise documentation and communicate effectively with technical and business teams.

Must-Have Skills

• Strong, hands-on experience with
  ETL/Informatica
  .
• Solid foundational knowledge and experience as a
  SQL Developer
  .
• Excellent verbal and written communication skills.
• Strong understanding of data warehousing concepts and best practices.

Nice-to-Have Skills

• Experience with
  IDMC (Informatica Data Management Cloud)
  — formerly IICS.
• Working knowledge of
  Snowflake
  and
  DBT
  .
• Understanding of
  Talend
  ,
  SSIS
  ,
  SSRS
  — legacy tools that add value for knowledge transition.
• Exposure to
  erwin Data Modeler
  (not required, but ability to learn quickly is expected).

Soft Skills

• Strong analytical and problem-solving abilities.
• Ability to quickly learn new tools and evolving cloud technologies.
• Collaborative mindset with ability to work effectively in a remote team environment.