Lead ETL Engineer – Data Warehouse & API Solutions

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

Benefits offered by this job

Medical coverage

Dental & vision

401(k) plan

Paid time off

Parental leave

Job summary

PNC is seeking a Software Engineer Lead (ETL) to align business strategy with scalable data solutions. Based in Pittsburgh, Strongsville, or Dallas, you will design and implement ETL pipelines, data warehousing, and integrations across internal systems, while mentoring teams and ensuring data quality and governance.

You will lead architecture, API development, and cross-functional collaboration, leveraging Agile and traditional methods to deliver reliable outcomes and support reporting, CRM

Qualifications

• Experience with Informatica ETL development and design.
• Leading complex Data Warehouse applications experience.
• Experience with CA7 orchestration.
• Data Warehouse experience with large data volumes.
• Proficiency with Teradata, Oracle and Hadoop ecosystems.
• Experience designing new data integrations.
• Experience with deployment tools such as Udeploy, Artifactory and GitHub.
• Proficiency in Java/Spring Boot.

Responsibilities

• Create and lead the technical design and development of software solutions.
• Propose and design software solutions to address complex business needs and document them.
• Facilitate complex problem resolution.
• Provide technical guidance and reviews of code, testing, and documentation.

Skills

Informatica ETL

Data Warehouse

CA7 Orchestration

Teradata

Oracle

Hadoop

Data integrations

Java/Spring Boot

Education

Bachelor's degree

Tools

Udeploy

Artifactory

GitHub

Job description

PNC is seeking a Software Engineer Lead (ETL) to align business strategy with scalable data solutions. Based in Pittsburgh, Strongsville, or Dallas, you will design and implement ETL pipelines, data warehousing, and integrations across internal systems, while mentoring teams and ensuring data quality and governance.

You will lead architecture, API development, and cross-functional collaboration, leveraging Agile and traditional methods to deliver reliable outcomes and support reporting, CRM