Senior Data Engineer – ELT & Data Platforms

Goldenpick Technologies

Job Location:

Pittsburgh, PA - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Job title - Senior Data Engineer ELT & Data Platforms

Location: Pittsburgh PA

Work Mode : Hybrid - 3 days in office

Duration: Contract to Hire Years Of Exp

Required: 10 Years Industry Background: Banking/Finance

Job Responsibilities:

This role requires senior-level enterprise engineering expertise with strong hands-on experience in designing and developing scalable high-performance ELT data pipelines using modern data integration platforms such as Informatica (PowerCenter / IDMC).

The candidate must possess deep knowledge of data ingestion transformation and large-scale data processing with a strong emphasis on ELT patterns in complex enterprise environments.

The role demands proven experience in handling high-volume batch and near real-time data pipelines including data staging transformation pushdown and optimization within database or cloud platforms.

The individual should have a solid understanding of data warehousing concepts data modeling and reconciliation frameworks ensuring data accuracy consistency and integrity across systems.

In addition the position requires strong experience in production support within mission-critical data platforms including monitoring troubleshooting root cause analysis and performance tuning to ensure reliability and stability of data pipelines.

The candidate should be comfortable working in distributed and event-driven ecosystems with a focus on scalability fault tolerance and resiliency.

The role also requires:

Hands-on experience in designing and implementing ELT pipelines leveraging database or cloud processing capabilities

Strong expertise in SQL and data transformation techniques including performance tuning and query optimization

Experience working with data platforms (RDBMS cloud data warehouses big data ecosystems)

Familiarity with data orchestration tools (Airflow or similar) and scheduling frameworks

Exposure to data quality validation reconciliation and audit frameworks

Knowledge of DevOps practices CI/CD pipelines and version control for ETL/ELT deployments

Ability to own end-to-end delivery from design and development to deployment and production support

Strong collaboration skills to work with business data and downstream systems teams to deliver scalable enterprise-grade data solutions

Required Skills

1. Designing and implementing ELT pipelines (Informatica)

2. SQL and data transformation techniques

3. data platforms (RDBMS cloud data warehouses big data ecosystems)

4. data orchestration tools (Airflow or similar) and scheduling frameworks

5. data quality validation reconciliation and audit frameworks

6. DevOps practices CI/CD pipelines and version control for ETL/ELT deployments

7. Ability to own end-to-end delivery from design and development to deployment and production support Flex

Job title - Senior Data Engineer ELT & Data Platforms Location: Pittsburgh PA Work Mode : Hybrid - 3 days in office Duration: Contract to Hire Years Of Exp Required: 10 Years Industry Background: Banking/Finance Job Responsibilities: This role requires senior-level enterprise engineeri...