At a Glance
- Tasks: Develop and optimise Oracle PL/SQL code, lead data migration, and integrate enterprise systems.
- Company: Join a globally recognised premium automotive brand in a dynamic engineering team.
- Benefits: Competitive salary, hybrid work model, and opportunities for professional growth.
- Other info: Collaborative environment with exposure to complex enterprise systems.
- Why this job: Be part of a high-profile transformation project with real impact on customer data strategies.
- Qualifications: 3+ years in Oracle database development and experience with RESTful APIs.
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.
Ingegnere dei dati (f/m) in Farnborough employer: Guidant Global
Join our dynamic team in Farnborough, UK, where we offer a collaborative and innovative work culture that empowers our employees to thrive. As an Oracle PL/SQL & Integration Specialist, you will be part of a high-profile transformation project for a globally recognised automotive brand, with ample opportunities for professional growth and development. Enjoy the benefits of a hybrid working model, competitive remuneration, and the chance to influence critical data strategies within a complex enterprise environment.
StudySmarter Expert Advice🤫
We think this is how you could land Ingegnere dei dati (f/m) in Farnborough
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage on platforms like LinkedIn. 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 and scenarios related to Oracle PL/SQL and integration. We recommend doing mock interviews with friends or using online resources to boost your confidence.
✨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 directly through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows your enthusiasm for the role and the company.
We think you need these skills to ace Ingegnere dei dati (f/m) in Farnborough
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to highlight your experience with Oracle PL/SQL and integration projects. We want to see how your skills match the job description, so don’t be shy about showcasing 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 past work that align with the responsibilities listed in the job description. We love a good story!
Showcase Your Technical Skills:Since this role involves a lot of technical work, make sure to highlight your expertise in Oracle SQL, PL/SQL, and API integrations. We want to see your problem-solving skills in action, so include any relevant achievements or challenges you've overcome.
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates. Plus, it’s super easy!
How to prepare for a job interview at Guidant Global
✨Know Your Oracle Inside Out
Make sure you brush up on your Oracle PL/SQL and SQL skills. Be ready to discuss your experience with complex queries, interfaces, and stored procedures. Prepare examples of how you've tackled data migration and integration challenges in the past.
✨Showcase Your API Knowledge
Familiarise yourself with RESTful APIs and be prepared to talk about your experience using tools like Postman. Highlight any specific projects where you’ve performed CRUD operations and how you ensured data integrity during integrations.
✨Demonstrate Problem-Solving Skills
Be ready to discuss how you've approached troubleshooting and improving existing PL/SQL routines. Think of specific instances where you identified integration gaps or implemented data validation checks, and be prepared to share those stories.
✨Communicate Clearly with Stakeholders
Since this role involves collaboration with both technical teams and business stakeholders, practice explaining complex technical concepts in simple terms. Prepare to present your past solutions and findings in a way that resonates with non-technical audiences.
