Software Engineer Sr - ETL

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

System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions 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 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.