ETL Engineer – Informatica Specialist

Hatch Pros, Inc.; San Francisco (CA); Hybrid; USD 160,000 - 210,000; Full time

Job summary

A technology company in the Bay Area is looking for an ETL Engineer. The role involves developing ETL workflows using Informatica PowerCenter and IICS to effectively manage large data sets. Candidates should have significant experience in ETL development and an understanding of data warehousing principles.

Qualifications

• 5+ years of experience in ETL development.
• Experience with Informatica PowerCenter, IICS and IDMC.
• Strong understanding of data warehousing concepts.

Responsibilities

• Design, develop, and maintain ETL workflows and data pipelines.
• Collaborate with stakeholders to understand data integration needs.
• Optimize performance of ETL processes and troubleshoot issues.

Skills

ETL development

Data warehousing

SQL

Performance tuning

Agile methodology

Tools

Informatica PowerCenter

Informatica IICS

Informatica IDMC

Job description

1 week ago Be among the first 25 applicants

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

We are currently seeking a highly skilled ETL Engineer to join our client’s team based in the Bay Area. This is a hybrid opportunity, requiring 3 days per week onsite. The ideal candidate will bring robust hands-on experience with Informatica PowerCenter, IICS (Informatica Intelligent Cloud Services), and IDMC (Informatica Data Management Cloud) in enterprise-scale environments.

Key Responsibilities:

• Design, develop, and maintain ETL workflows and data pipelines using Informatica PowerCenter, IICS, and IDMC.
• Collaborate with business analysts, data architects, and stakeholders to understand data integration needs.
• Optimize performance of ETL processes and ensure scalability across complex data ecosystems.
• Monitor and troubleshoot ETL jobs, resolving issues in a timely manner.
• Document technical processes and maintain best practices for data quality and governance.

Required Skills & Experience:

• 5+ years of hands-on experience in ETL development using Informatica PowerCenter.
• Proven experience with Informatica IICS and IDMC in cloud-based or hybrid environments.
• Strong understanding of data warehousing concepts, SQL, and performance tuning.
• Experience working in agile teams and with enterprise data strategies.
• Excellent communication skills and the ability to work cross-functionally.

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 Hatch Pros by 2x

Get notified about new ETL Developer jobs in San Francisco Bay Area.

San Francisco, CA $160,000.00-$180,000.00 5 days ago

San Francisco, CA $147,000.00-$210,000.00 4 days ago

Software Engineer - Data Acquisition / Web Crawling

San Francisco, CA $50.00-$61.71 3 weeks ago

San Francisco, CA $180,000.00-$250,000.00 3 months ago

Software Engineer - Data Acquisition / Web Crawling

Software Engineer - Data Infrastructure (Pretraining Data)

San Jose, CA $113,400.00-$206,300.00 1 week ago

San Francisco, CA $178,000.00-$195,800.00 7 months ago

San Francisco, CA $200,000.00-$220,000.00 1 day ago

Internship, Data Engineer, Applications Engineering (Fall 2025)

Senior Database Developer - Two Positions!

San Francisco, CA $112,597.33-$152,810.66 1 month ago

Fremont, CA $114,000.00-$171,000.00 2 weeks ago

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