ETL Lead Developer - Hybrid/Remote Data Integration

System One; Pittsburgh (Allegheny County); Hybrid; USD 100,000 - 140,000; Full time

Job summary

System One in Pittsburgh, PA, is seeking an ETL Lead Developer for a permanent hybrid role (onsite and remote). You will design and code ETL processes, align data solutions with business goals, and guide teams through data integration projects.

Proficiency in SQL, Informatica, Oracle/Teradata, and Linux scripting is essential, with agile experience and clear communication. Responsibilities include ensuring documentation, reviewing deliverables, and applying current data migration architectures

Qualifications

• 6-8 years of experience in relational database design with Oracle and Teradata.
• Proficient in Informatica and ETL development.
• Strong SQL experience.
• Experience with enterprise data warehouses.
• Familiarity with DB2, Oracle, and flat files as data sources.
• Familiarity with stored procedures.

Responsibilities

• Aligns business strategy with software solutions.
• Proposes, designs & codes software solutions for complex business needs.
• Oversees technical and procedural documentation.
• Leads complex problem solving and provides guidance to colleagues.
• Displays an innovative approach to data integration practices.

Skills

SQL proficiency

Informatica

Agile/Scrum

Distributed teams communication

Shell scripting

Tools

Oracle

Teradata

Linux

Job description

System One in Pittsburgh, PA, is seeking an ETL Lead Developer for a permanent hybrid role (onsite and remote). You will design and code ETL processes, align data solutions with business goals, and guide teams through data integration projects.

Proficiency in SQL, Informatica, Oracle/Teradata, and Linux scripting is essential, with agile experience and clear communication. Responsibilities include ensuring documentation, reviewing deliverables, and applying current data migration architectures