Informatica Developer

Siri InfoSolutions Inc; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

Siri InfoSolutions Inc. is seeking an Informatica Developer in Pittsburgh to design, build, test, and maintain ETL workflows using Informatica PowerCenter. The role emphasizes data quality, performance tuning, and collaboration with analysts and architects.

Responsibilities include ensuring data integrity, troubleshooting issues, and documenting processes for future maintenance. Strong SQL, Unix/Python scripting, and data warehousing knowledge are required.

Qualifications

• Proficiency with Informatica PowerCenter or similar Informatica products.
• Strong knowledge of ETL processes and data integration.
• Solid understanding of SQL and database concepts.
• Scripting experience in Unix and Python for automation and data processing.
• Ability to troubleshoot and debug ETL workflows and data issues.
• Understanding of data warehousing principles and concepts.

Responsibilities

• ETL development: Design, build, test, and maintain data integration workflows using Informatica PowerCenter or other Informatica products.
• Data integrity and accuracy: Ensure data is accurate, consistent, and reliable by implementing quality checks and troubleshooting issues.
• Performance tuning: Optimize ETL processes and data storage systems for efficiency and high availability.
• Collaboration: Work closely with business analysts, data architects, and other stakeholders to understand and implement data requirements.
• Documentation: Create and maintain technical documentation for all developed processes.
• Problem-solving: Troubleshoot and resolve issues related to data integration, data quality, and performance

Skills

ETL development

SQL

Data warehousing concepts

Troubleshooting & debugging

Unix scripting

Python scripting

Tools

Informatica PowerCenter

Job description

Job Description

Skill: Informatica Developer

Must Have Technical/Functional Skills:

• Proficiency with Informatica tools (e.g., PowerCenter)
• Strong knowledge of ETL processes
• SQL and database concepts
• Scripting (Unix, Python)
• Troubleshooting and debugging
• Data warehousing principles

Roles & Responsibilities

• ETL development: Design, build, test, and maintain data integration workflows using Informatica PowerCenter or other Informatica products.
• Data integrity and accuracy: Ensure data is accurate, consistent, and reliable by implementing quality checks and troubleshooting issues.
• Performance tuning: Optimize ETL processes and data storage systems for efficiency and high availability.
• Collaboration: Work closely with business analysts, data architects, and other stakeholders to understand and implement data requirements.
• Documentation: Create and maintain technical documentation for all developed processes.
• Problem-solving: Troubleshoot and resolve issues related to data integration, data quality, and performance