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