Lead ETL Engineer: Data Warehousing & API

Fairygodboss; Farmers Branch (TX); On-site; USD 86,000 - 158,000; Full time

Job summary

PNC is seeking a Software Engineer Lead (ETL) to align business strategy with scalable data solutions. You will design and implement ETL pipelines, data warehouses, and integrations across systems, including REST/SOAP API development.

Role requires leadership, governance, and strong collaboration with stakeholders. The position supports reporting, CRM integrations, SSO, and disaster recovery, leveraging Agile and traditional practices to deliver high-quality outcomes.

Qualifications

• Proven Informatica ETL development and design experience.
• Lead complex Data Warehouse applications and data integrations.
• Experience with CA7 orchestration and large data volumes.
• Strong knowledge of Teradata/Oracle/Hadoop data platforms.
• Experience deploying code with Udeploy/Artifactory and GitHub.
• Java/Spring Boot development experience.

Responsibilities

• Create and lead the technical design and development of data solutions.
• Propose and design software to address complex business needs; prepare docs.
• Facilitate complex problem resolution and provide guidance to teammates.
• Review code, testing, and documentation to ensure quality and performance.
• Apply modern methods to advance business initiatives and capabilities.

Skills

Informatica ETL

Data Warehouse

Java/Spring Boot

REST/SOAP API

Education

Bachelor's degree

Tools

Udeploy

Artifactory

GitHub

Teradata

Oracle

Hadoop

Job description

PNC is seeking a Software Engineer Lead (ETL) to align business strategy with scalable data solutions. You will design and implement ETL pipelines, data warehouses, and integrations across systems, including REST/SOAP API development.

Role requires leadership, governance, and strong collaboration with stakeholders. The position supports reporting, CRM integrations, SSO, and disaster recovery, leveraging Agile and traditional practices to deliver high-quality outcomes.