At a Glance
- Tasks: Design and support production ETL pipelines using Informatica and SQL.
- Company: Leading financial services provider in Birmingham with a strong reputation.
- Benefits: Comprehensive rewards package including time off, career development, and wellness programs.
- Why this job: Join a dynamic team and enhance your skills in a thriving industry.
- Qualifications: 8+ years of ETL experience with proficiency in Informatica and SQL.
- Other info: Opportunity for professional growth in a supportive environment.
The predicted salary is between 60000 - 84000 £ per year.
A leading financial services provider in Birmingham is seeking an experienced ETL Developer with over 8 years in designing and supporting production ETL pipelines. The ideal candidate will have strong proficiency in Informatica (PowerCenter) and SQL across MySQL and Oracle, with a solid understanding of data quality controls.
This role includes a total rewards package with benefits like time off, career development, and wellness programs.
Senior ETL & Informatica Engineer — Build Data Pipelines 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 ETL & Informatica Engineer — Build Data Pipelines in Birmingham
✨Tip Number 1
Network like a pro! Reach out to your connections in the financial services sector, especially those who work with ETL and data pipelines. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Prepare a portfolio or case studies showcasing your past ETL projects, especially those involving Informatica and SQL. This will give potential employers a clear picture of what you can bring to the table.
✨Tip Number 3
Ace the interview! Brush up on common ETL and data quality control questions. We recommend practising with a friend or using mock interviews to build your confidence and refine your answers.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive and take the initiative to connect directly with us.
We think you need these skills to ace Senior ETL & Informatica Engineer — Build Data Pipelines in Birmingham
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with ETL pipelines and Informatica. We want to see how your skills match the job description, so don’t be shy about showcasing your SQL expertise and any relevant projects you've worked on.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this role. Share specific examples of your work with data quality controls and how you’ve successfully designed ETL processes in the past.
Showcase Your Problem-Solving Skills: In your application, highlight instances where you’ve tackled challenges in data management or pipeline design. We love candidates who can think critically and come up with innovative solutions, so don’t hold back!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy – just follow the prompts and submit your materials!
How to prepare for a job interview at PNC Financial Services Group, Inc.
✨Know Your ETL Stuff
Make sure you brush up on your ETL concepts, especially around designing and supporting production pipelines. Be ready to discuss your experience with Informatica PowerCenter and SQL in detail, as this will likely come up during the interview.
✨Showcase Your Data Quality Skills
Since data quality controls are crucial for this role, prepare examples of how you've implemented these in past projects. Highlight any specific challenges you faced and how you overcame them to ensure data integrity.
✨Prepare for Technical Questions
Expect some technical questions that test your knowledge of MySQL and Oracle. Practise common SQL queries and be ready to explain your thought process when solving data-related problems.
✨Ask Insightful Questions
At the end of the interview, don’t forget to ask questions about the company’s data strategy and how they approach career development. This shows your interest in the role and helps you gauge if it’s the right fit for you.