At a Glance
- Tasks: Lead data migration projects and build ETL/ELT pipelines using advanced tools.
- Company: Dynamic tech company in Surrey, embracing innovation and collaboration.
- Benefits: Hybrid work model, competitive pay, and opportunities for professional growth.
- Other info: Exciting 6-month contract with potential for future opportunities.
- Why this job: Join a cutting-edge team and leverage AI to transform data processes.
- Qualifications: Experience with Oracle schemas and ETL/ELT tools is essential.
The predicted salary is between 50000 - 65000 £ per year.
Role Type: Hybrid – 3 Days/Week
Location: Surrey, UK
Duration of assignment: 6 months contract Inside IR35
The Role:
- Legacy Analysis & Design
- Analyse Oracle schemas, procedures, packages, triggers, and dependencies.
- Perform source-to-target mapping and impact analysis.
- Define migration strategy (full load, delta, logical, physical).
- Document transformation logic and exceptions.
- Migration Build & Execution
- Build and maintain ETL/ELT pipelines using Data Pump, pgloader, SQL, Python/Bash, or cloud DMS tools.
- Execute full and incremental loads.
- Validate data accuracy, referential integrity, and reconciliation results.
- Maintain playbooks, runbooks, rollback plans, and technical documentation.
- AI-Enhanced Engineering
- Use AI tools to analyse PL/SQL logic, auto-generate mappings, and accelerate documentation.
- Apply AI/ML for data profiling, anomaly detection, and automated quality checks.
- Use LLM-based assistants for SQL optimisation, code conversion, and metadata extraction.
- Build AI-powered dashboards and automated reporting.
Key skills/knowledge/experience:
- Analyse Oracle schemas, procedures, packages, triggers, and dependencies.
- Perform source-to-target mapping and impact analysis.
- Define migration strategy (full load, delta, logical, physical).
- Document transformation logic and exceptions.
- Build and maintain ETL/ELT pipelines using Data Pump, pgloader, SQL, Python/Bash, or cloud DMS tools.
- Execute full and incremental loads.
- Validate data accuracy, referential integrity, and reconciliation results.
- Maintain playbooks, runbooks, rollback plans, and technical documentation.
Desirable skills/knowledge/experience:
- Analyse Oracle schemas, procedures, packages, triggers, and dependencies.
- Perform source-to-target mapping and impact analysis.
- Define migration strategy (full load, delta, logical, physical).
- Document transformation logic and exceptions.
- Build and maintain ETL/ELT pipelines using Data Pump, pgloader, SQL, Python/Bash, or cloud DMS tools.
Data Migration Lead in Guildford employer: Infoplus Technologies UK Limited
As a Data Migration Lead at our Surrey location, you will thrive in a dynamic hybrid work environment that fosters innovation and collaboration. We prioritise employee growth through continuous learning opportunities and a supportive culture that values your contributions. Enjoy the unique advantage of working with cutting-edge AI tools while being part of a team that is committed to excellence and integrity in data management.
Contact Details:
Infoplus Technologies UK Limited Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Migration Lead in Guildford
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even local tech events. You never know who might have a lead on that Data Migration Lead role you’re after.
✨Show Off Your Skills
When you get the chance to chat with potential employers, don’t hold back! Share your experience with Oracle schemas and ETL/ELT pipelines. Let them see how you can tackle their data challenges head-on.
✨Ace the Interview
Prepare for those tricky interview questions by practising your responses. Think about how you’d explain your migration strategies or how you’ve used AI tools in past projects. Confidence is key!
✨Apply Through Us
Don’t forget to check out our website for the latest job openings! Applying through us not only gives you access to great roles but also helps us support you better in your job search journey.
We think you need these skills to ace Data Migration Lead in Guildford
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Migration Lead role. Highlight your experience with Oracle schemas, ETL/ELT pipelines, and any AI tools you've used. We want to see how your skills match 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 passionate about data migration and how your background makes you the perfect fit for our team. Keep it engaging and relevant to the job description.
Showcase Your Technical Skills:Don’t forget to showcase your technical skills in your application. Mention specific tools like Data Pump, pgloader, or Python/Bash that you've worked with. We love seeing candidates who are hands-on with the tech we use!
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to keep track of your application status. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at Infoplus Technologies UK Limited
✨Know Your Tech Inside Out
Make sure you’re well-versed in the tools and technologies mentioned in the job description, like Oracle schemas, ETL/ELT pipelines, and AI tools. Brush up on your SQL and Python skills, and be ready to discuss how you've used these in past projects.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems related to data migration. Think about how you would approach legacy analysis, define migration strategies, or validate data accuracy. Practising these scenarios can help you articulate your thought process clearly.
✨Showcase Your Documentation Skills
Since maintaining playbooks and technical documentation is key, be prepared to discuss your experience with documentation. Bring examples of how you’ve documented transformation logic or created runbooks in previous roles to demonstrate your attention to detail.
✨Highlight Your AI Knowledge
With AI-enhanced engineering being a focus, be ready to talk about any experience you have with AI tools for data profiling or anomaly detection. If you’ve built AI-powered dashboards or used LLM-based assistants, share those experiences to show you’re ahead of the curve.
