At a Glance
- Tasks: Ensure smooth data migration from Teradata to Snowflake with thorough validation and automation.
- Company: Join a leading AI-driven digital engineering firm with a global presence.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Work in a fast-paced environment with a focus on innovation and client success.
- Why this job: Be part of a dynamic team transforming industries with innovative technology solutions.
- Qualifications: Strong SQL skills and experience in data migration processes.
The predicted salary is between 45000 - 55000 £ per year.
About the Company
We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem. Our disruptor’s mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation, leadership, and inclusion. We have delivered 21 sequential quarters of growth with $389.7M in Q1 FY26 revenue, up 3.9% Q-o-Q and 18.8% Y-o-Y growth. Our 25,000+ global team members, located in 18 countries, have been instrumental in helping the market leaders transform their industries. We have been named the fastest-growing Indian IT services brand in the “Brand Finance India 100” 2025 report. We were also cited as a Leader in the ISG Provider Lens™ 2025 for Digital Engineering Services 2025 and the Everest Group Talent Readiness for Next-generation Application Services PEAK Matrix® Assessment 2025.
Role Purpose
Ensure accurate and complete migration of data from Teradata to Snowflake through end-to-end validation and automation.
Key Responsibilities
- Validate data migration (schema, counts, data accuracy, CDC loads)
- Perform end-to-end pipeline testing across all layers
- Verify transformation logic and SQL equivalence
- Execute automated data comparison and reconciliation
- Support regression testing across releases/waves
- Validate performance, security, and data governance controls
- Manage defects, RCA, and test reporting
- Provide test status and Go/No-Go sign-offs
Skills Required
- Strong SQL (Teradata / Snowflake)
- Data migration
Test Engineer- Corporate Lakehouse employer: Persistent Systems
At Persistent, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration. Our commitment to employee growth is evident through continuous learning opportunities and a supportive environment that encourages professional development. Located in a vibrant corporate setting, our team members enjoy the benefits of working with industry leaders while contributing to transformative projects that make a real impact.
StudySmarter Expert Advice🤫
We think this is how you could land Test Engineer- Corporate Lakehouse
✨Tip Number 1
Network like a pro! Reach out to folks in your industry on LinkedIn or at events. We all know that sometimes it’s not just what you know, but who you know that can help you land that Test Engineer role.
✨Tip Number 2
Prepare for those interviews by practising common questions and scenarios related to data migration and SQL. We recommend doing mock interviews with friends or using online platforms to get comfortable with the process.
✨Tip Number 3
Showcase your skills! Create a portfolio or GitHub repository with examples of your work, especially any projects involving Teradata or Snowflake. This gives potential employers a tangible look at what you can do.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Test Engineer- Corporate Lakehouse
Some tips for your application 🫡
Show Off Your SQL Skills:Make sure to highlight your strong SQL skills in your application. We want to see how you can handle data migration and validation, so don’t hold back on showcasing your experience with Teradata and Snowflake!
Be Clear and Concise:When writing your application, keep it clear and to the point. We appreciate straightforward communication, so make sure your experience and skills shine through without any fluff.
Tailor Your Application:Take a moment to tailor your application to the role. Mention specific experiences that relate to data migration and testing, as this will show us you’re genuinely interested in the Test Engineer position.
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Persistent Systems
✨Know Your SQL Inside Out
Since the role requires strong SQL skills, make sure you brush up on your Teradata and Snowflake knowledge. Be prepared to answer technical questions or even solve problems on the spot. Practising common SQL queries and understanding data migration concepts will give you a solid edge.
✨Understand the Migration Process
Familiarise yourself with the end-to-end data migration process, especially focusing on validation techniques. Be ready to discuss how you would approach validating schema, counts, and data accuracy. Showing that you can think critically about these processes will impress your interviewers.
✨Showcase Your Automation Skills
Automation is key in this role, so be prepared to talk about any tools or frameworks you've used for automated testing. If you have experience with data comparison and reconciliation automation, share specific examples of how you implemented these in past projects.
✨Communicate Clearly and Confidently
During the interview, articulate your thoughts clearly and confidently. Practice explaining complex concepts in simple terms, as this demonstrates your understanding and ability to communicate effectively with both technical and non-technical stakeholders.
