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's innovative engineering team.
- Benefits: Hybrid work model, competitive salary, and exposure to high-profile projects.
- Other info: Collaborative environment with opportunities for professional growth.
- Why this job: Be part of a transformative project that influences critical customer data strategies.
- Qualifications: 3+ years in Oracle database development and strong API integration experience.
The predicted salary is between 60000 - 75000 € 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.
Senior Engineer, Data Engineering in Farnborough employer: Guidant Global
Join our dynamic team in Farnborough, UK, where we pride ourselves on fostering a collaborative and innovative work culture. As a Senior Engineer in Data Engineering, you will not only contribute to high-profile transformation projects for a globally recognised automotive brand but also enjoy opportunities for professional growth and development within a supportive environment. With a focus on employee well-being and a commitment to excellence, we offer a unique chance to make a meaningful impact while working with cutting-edge technologies.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Engineer, Data Engineering 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 put in a good word for you.
✨Tip Number 2
Prepare for interviews by researching the company and its projects. Understand their tech stack and be ready to discuss how your experience with Oracle PL/SQL and APIs can add value to their team. Show them you’re not just another candidate!
✨Tip Number 3
Practice your problem-solving skills! Be ready to tackle technical challenges during interviews. Brush up on your SQL queries and data migration strategies, as these will likely come up in discussions.
✨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 about their job search.
We think you need these skills to ace Senior Engineer, Data Engineering in Farnborough
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the role of Senior Engineer, Data Engineering. Highlight your experience with Oracle PL/SQL and integration projects, as well as any relevant skills in data migration and API connectivity. We want to see how your background aligns with what we're looking for!
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. Mention specific projects you've worked on that relate to customer data migration or system integration. Let us know what excites you about working with a premium automotive brand!
Showcase Your Problem-Solving Skills:In your application, don't forget to highlight your analytical and troubleshooting skills. Share examples of how you've tackled complex data issues or improved existing processes. We love seeing candidates who can think critically and come up with effective solutions!
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 gives you a chance to explore more about StudySmarter and what we stand for!
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 explain your thought process.
✨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 share how you've successfully engaged with different audiences in previous roles.
