Lead ETL Engineer for Regulatory Risk & Compliance

Habitat For Humanity Of Durham; United States; Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical/prescription coverage

401(k) with company match

Paid holidays

Wellness program

Job summary

PNC is seeking an ETL Lead within Regulatory Risk and Compliance Reporting to design and lead data intensive ETL solutions. You will collaborate across teams, optimize mappings, and ensure robust deployment practices.

The role emphasizes strong communication, project leadership, and hands-on development with Informatica PowerCenter and Oracle SQL/PLSQL, in an in-office Pittsburgh setting.

Qualifications

• 5+ years of development experience.
• Experience with ETL design and data modeling.
• Proficient in PL/SQL development and debugging.
• Strong communication and collaboration skills.
• Experience with DevOps for ETL deployments.
• Knowledge of UNIX shell scripting is a plus.

Responsibilities

• Create and lead the technical design and development of ETL solutions.
• Propose & design software solutions to address complex business needs; prepare documentation.
• Facilitate complex problem resolution across teams.
• Provide technical guidance and review coding, testing, and documentation.
• Apply modern principles, methodologies and tools to advance initiatives.

Skills

Informatica PowerCenter

Oracle SQL/PLSQL

ETL Development

DevOps for ETL deployments

UNIX shell scripting

CA7 job scheduler

Data modeling

Performance tuning

SCD mappings

SQL debugging

Education

Bachelor's degree

Tools

Informatica PowerCenter

Oracle SQL/PLSQL

CA7

Unix shell

Job description

PNC is seeking an ETL Lead within Regulatory Risk and Compliance Reporting to design and lead data intensive ETL solutions. You will collaborate across teams, optimize mappings, and ensure robust deployment practices.

The role emphasizes strong communication, project leadership, and hands-on development with Informatica PowerCenter and Oracle SQL/PLSQL, in an in-office Pittsburgh setting.