Y
our potential, unleashed.
India s impact on the global economy has increased at an exponential rate and Deloitte presents an opportunity to unleash and realize your potential amongst cutting edge leaders, and organizations shaping the future of the region, and indeed, the world beyond.
At Deloitte, your whole self to work, every day. Combine that with our drive to propel with purpose and you have the perfect playground to collaborate, innovate, grow, and make an impact that matters.
The Team
Deloitte s Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning.
Your work profile:
We are looking for an experienced ETL and Data Migration Tester
to join our QA team. The ideal candidate will have strong experience in testing complex data pipelines, validating data transformations, and supporting large-scale data migration projects across cloud or on-premise platforms.
Key Responsibilities:
- Analyze ETL mappings, business rules, and data flow diagrams to design test strategies.
- Develop and execute
test cases
and SQL queries
to validate data transformation logic, data quality, and completeness. - Perform
source-to-target data validation
and reconciliation
between legacy and target systems. - Validate data migration from legacy systems to data warehouses or cloud platforms (e.g., Azure, AWS, GCP).
- Collaborate with ETL developers, business analysts, and data architects to ensure data accuracy and integrity.
- Conduct
smoke testing, system testing, regression testing, and UAT support
. - Work with
data profiling
and data quality tools
to identify anomalies. - Log, track, and close defects using tools like JIRA, ALM, or Azure DevOps.
- Participate in Agile/Scrum ceremonies and contribute to sprint goals and QA metrics.
Required Skills:
- 7+ years of QA experience with at least 4+ years in
ETL testing and data migration projects
. - Proficient in writing complex
SQL queries
for data validation (joins, aggregations, subqueries). - Strong understanding of
ETL tools
such as Informatica, Talend, SSIS
, or equivalent. - Experience in validating
large-scale data migration projects
(on-prem to cloud or system upgrades). - Hands-on experience in testing
data warehouse and data lake
environments. - Familiarity with
data modeling concepts (Star, Snowflake schemas)
. - Experience with
Agile methodology
and tools like JIRA, Confluence, Azure DevOps
. - Knowledge of
data profiling, data cleansing, and DQ tools
(e.g., Informatica DQ, Talend DQ) is a plus.
Good to Have:
- Knowledge of
cloud data platforms
like Azure Synapse, AWS Redshift, or Google BigQuery
. - Experience with
Python or Shell scripting
for test automation or data manipulation. - Exposure to
BI tools
such as Power BI, Tableau, or Qlik for validating reporting layers. - Understanding of
data security, PII masking
, and compliance requirements
.
Qualifications:
- Bachelor s degree in Computer Science, Engineering, or related field.
- ETL tool certifications or Data Engineering-related credentials (preferred but not mandatory).
Location and way of working:
- Hybrid is our default way of working. Each domain has customized the hybrid approach to their unique needs.
How you ll grow
Connect for impact
Our exceptional team of professionals across the globe are solving some of the world s most complex business problems, as well as directly supporting our communities, the planet, and each other. Know more in our Global Impact Report and our India Impact Report .
Empower to lead
You can be a leader irrespective of your career level. Our colleagues are characterised by their ability to inspire, support, and provide opportunities for people to deliver their best and grow both as professionals and human beings. Know more about Deloitte and our One Young World partnership.
Inclusion for all
At Deloitte, people are valued and respected for who they are and are trusted to add value to their clients, teams and communities in a way that reflects their own unique capabilities. Know more about everyday steps that you can take to be more inclusive. At Deloitte, we believe in the unique skills, attitude and potential each and every one of us brings to the table to make an impact that matters.
Drive your career
At Deloitte, you are encouraged to take ownership of your career. We recognise there is no one size fits all career path, and global, cross-business mobility and up / re-skilling are all within the range of possibilities to shape a unique and fulfilling career. Know more about Life at Deloitte.
Everyone s welcome entrust your happiness to us
Our workspaces and initiatives are geared towards your 360-degree happiness. This includes specific needs you may have in terms of accessibility, flexibility, safety and security, and caregiving. Here s a glimpse of things that are in store for you.
Interview tips
We want job seekers exploring opportunities at Deloitte to feel prepared, confident and comfortable. To help you with your interview, we suggest that you do your research, know some background about the organisation and the business area you re applying to. Check out recruiting tips from Deloitte professionals.
