Description

You will design, build, and maintain data integration workflows using Informatica PowerCenter, ensuring data accuracy and high availability through performance tuning and rigorous quality checks.

This role is on-site.

Responsibilities

• Design and implement ETL processes and data warehousing solutions using Informatica tools.
• Optimize ETL workflows and database storage systems for efficiency and performance.
• Troubleshoot and resolve complex issues related to data integration, quality, and debugging.
• Collaborate with business analysts and data architects to translate requirements into technical implementations.
• Create and maintain comprehensive technical documentation for all developed processes.

Required Skills

• 10+ years of experience in ETL development and data warehousing.
• Strong proficiency with Informatica PowerCenter and related products.
• Advanced SQL skills and deep understanding of database concepts.
• Scripting experience with Unix and Python.
• Proven ability in performance tuning and debugging data pipelines.
• Experience working in on-site environments in Pittsburgh, PA.

Preferred Skills

• Experience with additional Informatica cloud or on-premise products.
• Background in collaborating directly with non-technical stakeholders.

Key Skills

Education

Any Graduate