Job Description

Role: ETL Developer
Location: Pittsburgh, PA
Hire Type: Full time

Must Have Technical/Functional Skills:

Experienced ETL Developer with strong expertise in Informatica PowerCenter, specializing in designing and developing mappings, sessions, and workflows to support enterprise data integration.
Skilled in leveraging tools such as Source Analyzer, Mapplet Designer, and Workflow Manager to build efficient data loading processes, monitor execution, and ensure performance reliability.
Proficient in SQL and database design with proven ability to troubleshoot issues, optimize queries, and implement complex transformations including Slowly Changing Dimensions (SCD), delivering accurate and scalable data solutions aligned with business requirements.

Roles & 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.

Job Tags

Full time

Similar Jobs

Refuel Market

C-Store Manager Job at Refuel Market

...Job Title: C-Store Manager Reports to : District Manager FLSA Status : Salary Exempt Role Type : Full Time Work Location : Assigned Store Working Hours : This position requires flexible availability, including evenings, weekends, and some holidays. Weekly...

Advance Concrete

Concrete Cutting Assistant Operator Job at Advance Concrete

Helping the operator perform and complete job tasked . help set up equipment that is needed to complete task Able to lift 50Lbs plus have good understanding of construction. Be clean and hard worker, willingness to learn on the job and open to be trained

Johns Hopkins Medicine

Nuclear Med Technologist Job at Johns Hopkins Medicine

...Johns Hopkins Community Physicians Heart Care in Bethesda is currently searching for a Nuclear Medicine Technologist to join our elite team. As a Nuclear Med Tech, you will perform Nuclear Stress Tests to help diagnosis and treat diseases. What Awaits You! Free...

Children's Health Council (CHC)

Clinical Program Manager - Psychologist Job at Children's Health Council (CHC)

...collaborative partnerships as requested by the Associate Director. ~ Maintain productive working relationships with schools, healthcare providers, community-based organizations, and referral partners. ~ Provide occasional trainings , workshops,...

Christ's Church of the Valley

Central Video Producer Job at Christ's Church of the Valley

...The Central Video Producer is responsible for producing, coordinating, and supporting video projects for CCVs Central Video Team. This role oversees the full life cycle of video production, partnering closely with the Teaching Team, ministry leaders, and creative...

ETL Developer Job at Siri InfoSolutions Inc, Pittsburgh, PA

WnNDVjJBdnhHVzI1aGt0VStORFBZa1NiQWc9PQ==