At a Glance
- Tasks: Join our team to develop and optimise Oracle PL/SQL solutions for a premium automotive brand.
- Company: Work with a globally recognised automotive brand in a collaborative engineering environment.
- Benefits: Enjoy a competitive salary, hybrid work model, and opportunities for professional growth.
- Other info: Dynamic role with exposure to enterprise-scale systems and innovative technologies.
- Why this job: Make an impact on critical customer data and integration strategies in a high-profile project.
- Qualifications: 3+ years of Oracle database development and strong API integration experience required.
The predicted salary is between 50000 - 65000 € per year.
Contract: 7 months
Location: Farnborough, UK (Hybrid)
Working shifts: Full-time (Monday to Friday)
Role Overview
We are seeking an experienced Oracle PL/SQL & Integration Specialist to join our Software Engineering team supporting the client Enablement project. This role offers the opportunity to work within a complex enterprise system landscape for a globally recognised premium automotive brand. The successful candidate will play a key role in customer data migration, system integration, data synchronisation, and API connectivity across multiple business-critical platforms. You will collaborate closely with technical teams, business stakeholders, and external partners to analyse, design, develop, and optimise integrated solutions while ensuring data quality, integrity, and compliance.
Key Responsibilities
- Oracle Database & SQL Development
- Develop, maintain, and enhance Oracle PL/SQL code, interfaces, packages, and stored procedures containing complex business logic.
- Write and optimise complex Oracle SQL queries for data aggregation, analysis, reconciliation, and reporting.
- Create Oracle table schemas and populate them using external data files and database links.
- Analyse, troubleshoot, fix, and improve existing PL/SQL routines and database processes.
- Implement data validation checks and balancing mechanisms to ensure data accuracy and prevent duplication or data loss.
- Data Migration & Synchronisation
- Lead and support large-scale customer data migration activities between enterprise systems.
- Identify integration gaps by comparing customer data and related objects across multiple integrated platforms.
- Design and implement data cleansing and synchronisation routines.
- Ensure high levels of data integrity, consistency, and quality throughout migration and transformation processes.
- Support end-to-end reconciliation and validation activities post-migration.
- API & Systems Integration
- Work with RESTful APIs to integrate enterprise systems and perform CRUD operations.
- Connect to and consume APIs using tools such as Postman and Oracle PL/SQL.
- Interpret and work with API documentation to understand existing integrations and services.
- Apply authentication and security principles related to RESTful APIs.
- Work extensively with JSON and XML data structures within integration workflows.
- System Analysis & Solution Design
- Analyse complex end-to-end system landscapes and customer data flows across multiple business functions.
- Understand and document business processes, data transformations, and integration dependencies.
- Design scalable and efficient integration and synchronisation strategies.
- Provide technical guidance and recommendations to business stakeholders and project teams.
- Present technical solutions, findings, and recommendations clearly to both technical and non-technical audiences.
Required Skills & Experience
- Essential
- Minimum 3 years of hands-on Oracle database development experience.
- Strong expertise in Oracle SQL with the ability to create and optimise complex queries.
- Minimum 3 years of experience in Oracle PL/SQL development, including:
- Interfaces
- Packages
- Stored Procedures
- Complex business logic implementation
- Proven experience migrating large volumes of customer data between systems.
- Strong understanding of data quality management, reconciliation, and duplicate prevention techniques.
- Minimum 2 years of experience working with RESTful APIs in enterprise integration projects.
- Experience performing CRUD operations against remote systems using APIs.
- Strong understanding of:
- JSON
- XML
- API authentication and security
- Experience using tools such as Postman for API testing and integration validation.
- Excellent system analysis and troubleshooting skills.
- Strong understanding of CRM and customer data management principles.
- Minimum 5 years of experience working within complex integrated enterprise IT ecosystems.
- Ability to independently scope, design, and deliver technical solutions.
- Strong stakeholder management and communication skills.
- Desirable
- Experience with AWS Cloud databases and services.
- Knowledge of Kafka data streaming technologies.
- Experience working within automotive or enterprise-scale environments.
Personal Attributes
- Analytical and detail-oriented problem solver.
- Self-sufficient and capable of working with minimal supervision.
- Strong collaboration and stakeholder engagement skills.
- Ability to work effectively across technical and business teams.
- Comfortable operating within complex and fast-paced enterprise environments.
Why Join?
- Opportunity to work with a high-profile transformation project.
- Exposure to enterprise-scale systems and integrations.
- Collaborative and innovative engineering environment.
- Opportunity to influence critical customer data and integration strategies across complex platforms.
Locations
Data Engineer in Farnborough, Hampshire employer: Guidant Global
Join a dynamic and innovative team as a Data Engineer in Farnborough, UK, where you'll have the chance to work on high-profile transformation projects for a globally recognised premium automotive brand. Our collaborative work culture fosters creativity and growth, providing you with opportunities to enhance your skills in Oracle PL/SQL and API integration while ensuring data quality and integrity across complex enterprise systems. With a focus on employee development and a supportive environment, we are committed to helping you thrive in your career.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer in Farnborough, Hampshire
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join online forums. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common questions related to Oracle PL/SQL and data integration. We recommend doing mock interviews with friends or using online platforms to get comfortable with your responses.
✨Tip Number 3
Showcase your skills through personal projects or contributions to open-source. This not only demonstrates your expertise but also gives you something tangible to discuss during interviews.
✨Tip Number 4
Apply through our website for the best chance of landing that role! We love seeing candidates who take the initiative to connect directly with us. Plus, it shows you're genuinely interested in joining our team.
We think you need these skills to ace Data Engineer in Farnborough, Hampshire
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Engineer role. Highlight your experience with Oracle PL/SQL and any relevant projects you've worked on. We want to see how your skills match what we're looking for!
Showcase Your Projects:Include specific examples of your work, especially those involving data migration and API integration. We love seeing real-world applications of your skills, so don’t hold back on the details!
Be Clear and Concise:When writing your application, keep it clear and to the point. Use bullet points where possible to make it easy for us to read through your experience and skills. We appreciate a well-structured application!
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!
How to prepare for a job interview at Guidant Global
✨Know Your PL/SQL Inside Out
Make sure you brush up on your Oracle PL/SQL skills before the interview. Be ready to discuss your experience with writing and optimising complex queries, as well as any specific projects where you've implemented business logic. Practising coding challenges can also help you feel more confident.
✨Showcase Your Data Migration Experience
Prepare to talk about your past experiences with data migration and synchronisation. Have examples ready that highlight how you identified integration gaps and ensured data integrity during these processes. This will demonstrate your hands-on experience and problem-solving skills.
✨Familiarise Yourself with APIs
Since the role involves working with RESTful APIs, make sure you understand how to perform CRUD operations and are comfortable using tools like Postman. Be prepared to discuss any previous projects where you’ve integrated systems using APIs, and how you handled authentication and security.
✨Communicate Clearly with Stakeholders
Strong communication skills are key for this role. Practice explaining technical concepts in simple terms, as you'll need to present findings to both technical and non-technical audiences. Think of examples where you've successfully collaborated with stakeholders to deliver solutions.
