At a Glance
- Tasks: Join us as a Data Engineer, focusing on Informatica and SQL to optimise data workflows.
- Company: Work with a leading public sector organisation, making a real impact in data management.
- Benefits: Enjoy a flexible contract with potential for extension and competitive day rates.
- Why this job: Be part of a dynamic team, enhancing your skills while contributing to meaningful projects.
- Qualifications: 4-6 years of experience with Informatica and advanced SQL skills required.
- Other info: Must hold active SC clearance and be willing to work onsite 2 days a week.
The predicted salary is between 45000 - 63000 £ per year.
Role: Data Engineer
Job Type: Contract
Duration: 6 Months + likely to be extended
Work Location: ideally commutable to London, Bristol, or Manchester office
Position: 1
Start date: July '24
Please look for Security Cleared candidate.
Role Responsibilities
- Data Engineer having technical expertise in Informatica tool (4-6 years of Informatica experience).
- Must have used Informatica with Oracle as target database.
- Must have advanced SQL skills (ability to write complex SQL queries).
- Should have done Informatica workflow/session performance tuning as newly developed Informatica ETL jobs have to complete within a defined SLA (Data refresh window).
SC Cleared Data Engineer employer: Axiom Software Solutions Limited
Contact Detail:
Axiom Software Solutions Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SC Cleared Data Engineer
✨Tip Number 1
Make sure to highlight your experience with Informatica and Oracle in any conversations or networking opportunities. This will show that you have the specific skills they are looking for and can help you stand out.
✨Tip Number 2
If you have worked with public sector clients like Defra, be prepared to discuss your experiences and how they relate to the role. This can demonstrate your understanding of the sector and its unique challenges.
✨Tip Number 3
Brush up on your advanced SQL skills before interviews. Being able to confidently discuss complex queries and performance tuning will be crucial in showcasing your technical expertise.
✨Tip Number 4
Since this role requires SC clearance, ensure you have all your clearance details ready to share. Being proactive about your SC status can give you an edge over other candidates.
We think you need these skills to ace SC Cleared Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Informatica and Oracle, as well as your advanced SQL skills. Use specific examples to demonstrate your expertise in performance tuning and meeting SLAs.
Highlight Security Clearance: Clearly state your SC status in your application. Include details such as the issuing authority, date of issue, and expiry. This is crucial for the role, so make it prominent.
Detail Relevant Experience: If you have worked with Defra or in the public sector, provide context about your role and why you left. This information can be important for the employer to understand your background.
Be Clear on Availability: Indicate your notice period and confirm your willingness to work onsite as required. Also, mention any upcoming holidays or other commitments that may affect your availability for interviews.
How to prepare for a job interview at Axiom Software Solutions Limited
✨Know Your Informatica Inside Out
Make sure you brush up on your Informatica skills, especially if you've got 4-6 years of experience. Be ready to discuss specific projects where you've used Informatica with Oracle as the target database, and be prepared to explain how you approached performance tuning for ETL jobs.
✨Show Off Your SQL Skills
Since advanced SQL skills are a must, practice writing complex SQL queries before the interview. You might be asked to solve a problem on the spot, so being able to demonstrate your SQL prowess will definitely give you an edge.
✨Understand the Security Clearance Process
As this role requires SC clearance, be prepared to discuss your current SC status and any relevant details. Familiarise yourself with the security clearance process and be ready to explain your experience with it, especially if you've worked in the public sector.
✨Be Ready for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving abilities and technical expertise. Think of examples from your past work where you had to troubleshoot issues or optimise workflows, and be ready to walk the interviewer through your thought process.