Informatica PowerCenter ETL Developer

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

Job summary

Siri InfoSolutions Inc in Pittsburgh, PA seeks an experienced ETL Developer to design and implement data integration pipelines using Informatica PowerCenter. You will build mappings, sessions, and workflows to load data into DB2 Data Marts and ensure reliable, scalable performance.

Ideal candidates will demonstrate strong SQL skills, experience with SCDs, and ability to translate business requirements into robust ETL solutions.

Qualifications

• Extensive experience with Informatica PowerCenter.
• Proficient in SQL and database design; experience with DB2.
• Ability to design and optimize ETL mappings, sessions, and workflows.

Responsibilities

• ETL Methodologies: Extensively applied ETL concepts to support data extraction, transformation, and loading processes using Informatica PowerCenter.
• ETL Job Design: Designed and developed PowerCenter ETL jobs to extract data from heterogeneous source systems and load into DB2 Data Marts.
• Business Requirement Analysis: Collaborated with business analysts to understand processes and translate user requirements into optimized Data Mart solutions.
• Transformations Expertise: Implemented complex data manipulations using Filter, Expression, Lookup, Aggregator, Joiner, Router, Rank, Sorter, Update Strategy, and Slowly Changing Dimensions (SCD).
• Data Integration: Processed data from multiple source systems including relational databases and flat files, ensuring seamless integration.
• SCD Type Implementation: Designed and implemented Slowly Changing Dimension Type methodology to maintain historical data accuracy.
• ETL Mapping & Workflow Design: Created and optimized mappings in Informatica PowerCenter Designer using Source Analyzer, Mapplet Designer, and Mapping Designer; developed sessions and workflows in Workflow Manager to enable seamless data loading and monitored execution in Workflow Monitor for performance and reliability.
• SQL & Database Expertise: Demonstrated strong proficiency in SQL queries, database design, and development; performed data processing, identified issues, and implemented solutions to ensure accuracy and efficiency across relational databases.

Skills

Informatica PowerCenter

SQL

DB2

ETL Design

Performance Tuning

Tools

Source Analyzer

Mapplet Designer

Workflow Manager

Job description

Siri InfoSolutions Inc in Pittsburgh, PA seeks an experienced ETL Developer to design and implement data integration pipelines using Informatica PowerCenter. You will build mappings, sessions, and workflows to load data into DB2 Data Marts and ensure reliable, scalable performance.

Ideal candidates will demonstrate strong SQL skills, experience with SCDs, and ability to translate business requirements into robust ETL solutions.