Data Engineer Sr - Informatica ETL Expert

PNC

Farmers Branch, TX

Full Time

Senior

65k-172k

2 days ago

Job Description

About the Role

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company's success. As a Data Engineer within PNC's Technology organization, you will be based in Pittsburgh, PA; Cleveland, OH; Birmingham, AL or Dallas, TX. The position is primarily based in a PNC location. Responsibilities require time in the office or in the field on a regular basis. Some responsibilities may be performed remotely, at the manager's discretion.

Key Responsibilities

Design, Develop and maintain scalable and efficient data pipelines and ETL processes
Collaborate with analysts and stakeholders to gather requirements and implement data solutions that meet business needs
Proposes & designs data solutions to address complex business needs. Prepares technical and procedural documentation required.
Participates in code reviews & testing
Applies modern principles, methodologies, and tools to advance business initiatives and capabilities.
Develop and manage data integrations between various systems, ensuring seamless data flow and consistency
Optimize database and query performance to support analytical workloads
Monitor and troubleshoot data workflows to ensure data quality and integrity at all times
Stay current with industry trends, technologies and best practices to continuously improve our data ecosystem
Leads in developing, supporting and implementing data solutions for multiple applications to meet business objectives and user requirements
Leads data requirement analysis and the data preparation process development for targeted data solutions
Leads in designing and building data service infrastructure on multiple data platforms, according to the workflow
Oversees the development and implementation of data solutions for multiple applications to ensure scalability, availability and maintainability
Consults on data migration and transformation to ensure the accuracy and security of data solutions

Requirements

Experience with data pipelines and ETL - informatica
Experience in SQL and database management systems
Knowledge of data modelling, warehousing concepts, and ETL processes
Experience with big data technologies and frameworks such as Hadoop, Hive, Spark
Programming experience in Python or Scala
Demonstrated analytical and problem-solving skills
Familiarity with cloud platforms (e.g Azure, AWS) and their data related services
Proactive and detail oriented professional with strong sense of ownership
Creative problem solver who can tackle complex data challenges
Mentor who can guide junior engineers and contributes to team growth
Excellent problem solving, communication and collaboration skills
Ability to work in an agile environment and prioritize tasks effectively
Experience with code deployment tools such as Udeploy, Artifactory, GitHub
Roles at this level typically require a university/college degree, with 5+ years of industry-relevant experience

Nice to Have

Analytical Thinking
Competitive Advantages
Data Analytics
Data Mining
Data Science
Machine Learning

Qualifications

Bachelor's degree
No required certifications or licenses

Benefits & Perks

Medical/prescription drug coverage (with a Health Savings Account feature)
Dental and vision options
Employee and spouse/child life insurance
Short and long-term disability protection
401(k) with PNC match, pension and stock purchase plans
Dependent care reimbursement account
Back-up child/elder care
Adoption, surrogacy, and doula reimbursement
Educational assistance, including select programs fully paid
A robust wellness program with financial incentives
Paid time off including maternity and/or parental leave, up to 11 paid holidays, 8 occasional absence days, 15-25 vacation days depending on career level

Working at PNC

PNC fosters an inclusive and accessible workplace, emphasizing respect, value, and opportunity for all employees. The company values customer focus and managing risk, encouraging employees to align decisions with customer needs and enterprise risk management frameworks.

Apply Now