Software Engineer Sr - ETL

System One

Pittsburgh, PA

Apply

JOB DETAILS

SKILLS

Big Data, Candidate Pipeline, Cloud Computing, Continuous Deployment/Delivery, Continuous Integration, Data Management, Data Processing, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Database Optimization, DevOps, Ecosystems, Identify Issues, Informatica, Performance Tuning/Optimization, Process Capability, Production Support, Query Optimization, Reconciliation, Relational Databases (RDBMS), Root Cause Analysis, SQL (Structured Query Language), Scalable System Development, Software Engineering, Source Code/Configuration Management (SCM), Team Player

LOCATION

Pittsburgh, PA

POSTED

6 days ago

Title: Software Engineer Sr - ETL
Location: Pittsburgh, PA

Roles and 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

Must Have Technical 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

Ref: #404-IT Pittsburgh

About the Company

System One

Every day, System One focuses on services and solutions that require a high degree of specialization, in-demand technical skills, and large-scale operational expertise. We are essential partners to those on the front lines of our nation’s most critical infrastructure, technology, and life sciences initiatives.

Founded more than 40 years ago as a staffing partner to the engineering industry, today System One is a diversified organization operating in over 50 locations and putting more than 9,000 people to work in the United States, Canada, and the United Kingdom.

COMPANY SIZE

2,500 to 4,999 employees

INDUSTRY

Staffing/Employment Agencies

WEBSITE

https://systemone.com

Resume Resources

Free Resume Templates Free Resume Builder