Informatica Developer (IDMC | Snowflake)

Pacific Data Integrators; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

A leading company in IT Services and Consulting is seeking a highly experienced Senior Informatica Developer. The ideal candidate will design and maintain data integration solutions with a focus on Snowflake, leveraging over 5 years of ETL expertise using Informatica. This remote position offers competitive compensation and the opportunity to work on innovative data projects.

Qualifications

• Bachelor’s degree in Computer Science or related field.
• Minimum 5 years of ETL development experience using Informatica.
• Proven experience with Snowflake integration, including performance tuning.

Responsibilities

• Design and develop ETL processes using Informatica to load data into Snowflake.
• Collaborate with stakeholders to translate business requirements into technical solutions.
• Monitor and optimize ETL job performance for scalability.

Skills

Communication

Problem Solving

Data Warehousing

SQL

Data Integration

Education

Bachelor’s degree in Computer Science

Tools

Informatica PowerCenter

Intelligent Data Management Cloud (IDMC)

Snowflake

Job description

Get AI-powered advice on this job and more exclusive features.

We are seeking a highly experienced Senior Informatica Developer with a strong background in integrating data with Snowflake. The ideal candidate will have a minimum of 5 years of reputable experience in ETL development using Informatica PowerCenter, Intelligent Data Management Cloud (IDMC, formerly IICS), or equivalent platforms, and will be responsible for designing, developing, and maintaining efficient data extraction and loading solutions involving Snowflake.

The successful candidate must demonstrate strong communication skills, a deep understanding of data warehousing principles, and a proactive approach to problem-solving and collaboration.

Key Responsibilities

• Design, develop, and optimize ETL/ELT processes using Informatica to extract data from diverse source systems and load it into Snowflake.
• Collaborate with data architects and stakeholders to understand business requirements and translate them into technical solutions.
• Implement data transformations, quality checks, and validation logic to ensure high data accuracy and consistency.
• Monitor, troubleshoot, and tune ETL jobs for performance, scalability, and reliability.
• Document technical specifications, data mappings, and process flows in alignment with data governance standards.
• Work closely with QA, DevOps, and data engineering teams to support deployment, testing, and production support.
• Maintain best practices for secure, scalable, and reusable data integration components.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Minimum 5 years of hands-on experience developing ETL solutions using Informatica (PowerCenter and/or IDMC).
• Proven experience with data integration into Snowflake, including performance tuning and cost optimization.
• Strong expertise in writing SQL and working with structured and semi-structured data (JSON, XML, etc.).
• Familiarity with cloud ecosystems (AWS, Azure, or GCP) and related services for data storage and processing.
• Excellent verbal and written communication skills, with the ability to interact effectively with both technical and non-technical stakeholders.
• Experience in Agile/Scrum environments and participation in code reviews, sprint planning, and backlog grooming.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Pacific Data Integrators by 2x

Get notified about new Informatica Developer jobs in United States.

Senior Informatica Developer with expertise in IICS - Remote

Greater Minneapolis-St. Paul Area $40.00-$50.00 3 weeks ago

UI Developer - Front End Engineer - 100% REMOTE W2 Only

Canton, MA $105,840.00-$245,000.00 1 day ago

United States $90,000.00-$110,000.00 3 days ago

United States $125,000.00-$130,000.00 1 week ago

ETL Tools/ Informatica/ Hadoop Developer full time or contract

Senior ETL Developer Lead with Guidewire Experience - Remote

Remote Role - SSIS ETL Developer with State of Louisiana

Freelance GenAI Developer - Prompt Engineering & Data Workflows

Freelance GenAI Developer - Prompt Engineering & Data Workflows

North Carolina, United States 7 hours ago

United States $150,000.00-$185,000.00 1 week ago

Beaverton, OR $90,000.00-$180,000.00 2 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.