ETL Developer Job at Siri InfoSolutions Inc, Pittsburgh, PA

WS9wZlVHU0NsU3JkRGN6blhsZmZTbGlxV2c9PQ==
  • Siri InfoSolutions Inc
  • Pittsburgh, PA

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

RidgeLine Direct Inc.

Amazon DSP Delivery Driver- RidgeLine Direct Inc. Job at RidgeLine Direct Inc.

 ...We are a locally owned and operated Delivery Service Partner (DSP). As a DSP, we partner with Earths most customer-centric company...  ...area. Job Description Full-Time Positions delivering Amazon packages in company provided vans! No CDL required. We need... 

Broad River Rehabilitation

Area Manager Job at Broad River Rehabilitation

Area Manager - Open to PTA, COTA, PT, OT, SLP with prior leadership experience - Locations in Myrtle Beach, Pawleys Island, Charleston, SC and South Georgia. Contact: ****@*****.*** for further details The Area Manager is responsible for patient care... 

Crown Equipment Corporation

CAD Designer - Warehouse Solutions Job at Crown Equipment Corporation

 ...providing the customer with the safest, most efficient and ergonomic lift truck possible to lower their total cost of ownership. CAD Designer - Warehouse Solutions Job Duties Produce computer aided design (CAD) drawings. Collaborate with sales staff in the... 

The Brothers That Just Do Gutters

Sales Rep Job at The Brothers That Just Do Gutters

 ...Bonus based on performance~Company car~Competitive salary~Dental insurance~Flexible schedule~Free uniforms~Health insurance...  ...~Vision insuranceTake everything you ever learned about sales and throw it in the gutter! Imagine a sale where 95% of the leads... 

Confidential

General Production Worker Job at Confidential

 ...Job Title: General Production Worker Job Description The general production worker operates manufacturing equipment safely and efficiently while following standard operating procedures to support electrode and cell assembly production. This role maintains high quality...