Software Engineer Sr - ETL

System One • Pittsburgh, PA • 2h 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:

designing and implementing ELT pipelines (Informatica)

SQL and data transformation techniques

data platforms (RDBMS, cloud data warehouses, big data ecosystems)

data orchestration tools (Airflow or similar) and scheduling frameworks 5. data quality validation, reconciliation, and audit frameworks

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

Ref: #404-IT Pittsburgh

System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Similar Jobs

Software Engineer Principal

System One • Pittsburgh, PA • 2h ago

IT & Engineering

Tittle: Software Engineer Principal Location : Pittsburgh, PA or Cleveland OH or Birmingham AL or Dallas, TX or Phoenix AZ Work Mode : Onsite 5 days a week Duration: Contract to Hire Years Of Exp Required: 15+ Years Func...

2h ago

Go to Apply

Manufacturing Engineer

Fortive Corporation • Pittsburgh, PA • 3h ago

IT & Engineering

Role Overview This position supports New Product Development Engineering teams by developing manufacturing processes, fixtures, and equipment used to build and test electronic products and assemblies. The role focuses on...

3h ago

Go to Apply

Reactor Vessel Internals- Engineer

Westinghouse Electric Company • Cranberry Township, PA • 17h ago

IT & Engineering

Are you interested in being part of an innovative team that supports Westinghouse's mission to provide clean energy solutions? At Westinghouse, we recognize that our employees are our most valuable asset and we seek to i...

17h ago

Go to Apply

Piping Engineer

Jacobs • Pittsburgh, PA • 17h ago

IT & Engineering

At Jacobs, we drive to make a positive impact on people's lives everywhere by bringing solutions and adding value to our communities and society as a whole. Grow your career with Jacobs, a company that inspires and empow...

17h ago

Go to Apply

Adobe Workfront & Fusion Developer

System One • Pittsburgh, PA • 22h ago

IT & Engineering

Job Title: Adobe Workfront & Fusion Developer Location: Pittsburgh, Pennsylvania Type: Direct Hire Compensation: $0.00 Contractor Work Model: Onsite - onsite Hours: 40.0 Security Clearance: Not specified Overview Res...

22h ago

Go to Apply