At a Glance
- Tasks: Design and support production ETL pipelines using Informatica and SQL.
- Company: Join a leading financial services company with a focus on innovation.
- Benefits: Enjoy time off, wellness programs, and career development opportunities.
- Why this job: Make an impact in a regulated environment while enhancing your technical skills.
- Qualifications: 8+ years of ETL experience and strong SQL proficiency required.
- Other info: Dynamic workplace with a commitment to employee growth and recognition.
The predicted salary is between 60000 - 80000 £ per year.
8+ years of experience designing, scheduling, and supporting production ETL pipelines.
Proficiency developing ETL jobs in Informatica (PowerCenter) in a production environment.
Strong SQL querying proficiency in both MySQL and Oracle (joins, windowing/analytics, performance awareness).
Experience troubleshooting data issues using SQL across MySQL and Oracle source/target systems.
Demonstrated ownership of ETL schedules and SLA‐driven execution.
Strong understanding of data quality controls, reconciliation, and audit requirements.
Experience in payments, financial services, or other regulated environments.
Knowledge of CDC, incremental loading strategies, and file‐based integrations.
Experience with job orchestration/dependency management tooling.
Senior Software Engineer - ETL/Informatica in Birmingham employer: PNC Financial Services Group, Inc.
Contact Detail:
PNC Financial Services Group, Inc. Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Software Engineer - ETL/Informatica in Birmingham
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at PNC or similar companies. A friendly chat can lead to insider info about job openings and even referrals.
✨Tip Number 2
Show off your skills! Prepare a portfolio or a GitHub repository showcasing your ETL projects and SQL prowess. This gives potential employers a taste of what you can do beyond just a CV.
✨Tip Number 3
Ace the interview! Research common interview questions for Senior Software Engineers, especially around ETL and Informatica. Practise your answers and be ready to discuss your experience with data quality controls and troubleshooting.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in joining the team at PNC. Don’t miss out on that chance!
We think you need these skills to ace Senior Software Engineer - ETL/Informatica in Birmingham
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your 8+ years of experience in designing and supporting ETL pipelines. We want to see your proficiency with Informatica and SQL, so don’t hold back on showcasing those skills!
Showcase Your Projects: Include specific examples of ETL jobs you've developed and any troubleshooting you've done with SQL. We love seeing real-world applications of your skills, especially in payments or financial services.
Highlight Ownership and Accountability: Demonstrate how you've taken ownership of ETL schedules and ensured SLA-driven execution. We value candidates who can show they’ve managed their responsibilities effectively.
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and get you into our system quickly. Plus, it shows you’re keen on joining our team!
How to prepare for a job interview at PNC Financial Services Group, Inc.
✨Know Your ETL Inside Out
Make sure you can talk confidently about your experience with ETL pipelines, especially in Informatica. Be ready to discuss specific projects where you designed or supported production ETL jobs, and highlight any challenges you faced and how you overcame them.
✨SQL Skills on Display
Brush up on your SQL querying skills, particularly in MySQL and Oracle. Prepare to answer questions that test your knowledge of joins, windowing functions, and performance optimisation. You might even be asked to write a query on the spot, so practice makes perfect!
✨Demonstrate Ownership and Accountability
Be prepared to share examples of how you've taken ownership of ETL schedules and ensured SLA-driven execution. Discuss how you manage your time and priorities, especially in high-pressure situations, to show that you can handle the responsibilities of the role.
✨Understand the Bigger Picture
Familiarise yourself with data quality controls, reconciliation, and audit requirements. Be ready to discuss how these elements play a role in your work, especially in regulated environments like financial services. This shows that you understand the importance of compliance and data integrity.