Artificial Intelligence & Engineering
AI & Engineering leverages cutting-edge engineering capabilities to help build, deploy, and operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These insights are powered by engineering for business advantage, helping transform mission-critical operations.
Join our AI & Engineering team to help transform technology platforms, driving innovation, and help make a significant impact on our clients' achievements. You’ll work alongside talented professionals reimagining and re-engineering operations and processes that could be critical to businesses.
Position Summary
Level: Consultant
As an experienced Consultant at Deloitte Consulting, you will be responsible for individually delivering high quality work products within due timelines. Need-basis you will be mentoring and/or directing junior team members/liaising with onsite/offshore teams to understand the functional requirements.
As a ETL/ DW Tester, you will be responsible to analyze nonfunctional requirements, design test scenarios/cases/scripts, RTM, perform test execution, document defects, triage defects, document results and attain sign-off of the design & results.
Work you’ll do:
Apply industry knowledge to requirements gathering and analysis, ensuring alignment with sector needs. Demonstrate expertise across the entire software development lifecycle, from design and coding to deployment and defect resolution, collaborating with stakeholders for effective delivery. Conduct peer and team reviews to maintain quality standards. Actively engage in Agile practices, including sprint planning, retrospectives, and effort estimation. Build and share business process knowledge, supporting project knowledge management and team training. Proactively recommend process improvements, track efficiency gains, and contribute to automation and innovation, all aimed at enhancing project outcomes and delivering greater value to clients.
- Participating in business requirements discussions with client, onshore or offshore teams and attaining any clarifications to design test scenarios/cases/scripts
- Designing clean, efficient, and well-documented ETL and integration test scenarios/ scripts and maintaining industry & client standards, based on business requirement analysis.
- Able to understand Data mapping and able to create Data mappings.
- Provisioning the test data required to perform test execution.
- Performing Integration/ ETL/ Data migration test execution, logging defects, tracking and triaging defects to closure, and documenting test results
- Creating performance test results/reports
- Tracking and resolving dependencies that impact test activities
- Reporting and escalating any risks/issues which are blocking test activities
The Team:
Engineering as a Service provides complete design, implementation, and technology operations, leveraging our core engineering expertise. We transform engineering teams, modernize technology, and deliver complex programs with a product engineering approach. Our flexible delivery models—traditional teams, pools, or pods—are tailored to each client’s needs, offering engineering-led advisory, implementation, and operational capabilities to accelerate innovation.
Qualifications
Must Have Skills / Project Experience:
- 3-6 years of hands-on experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes.
- Hands-on experience on Cloud platform like AWS, Azure, GCP etc.
- Hands On experience and strong knowledge of complex SQL queries including aggregation logic.
- An understanding of big data engineering tools and how they can be used strategically (e.g. Spark, Hive, Hadoop, Dask).
- Experience in analyzing Data Mappings, Functional requirements and converting them into test scenarios / cases.
- Experience in different test phases with standardized QA Processes
- Experience with QA specific tools for test management, test execution progress, defect tracking and triaging.
- Experience in different SDLC/STLC lifecycles and methodologies.
- Understanding of Test Strategy & Test Planning
- Experience in defect logging, tracking, and closing defects
- Experience in test status reporting and managing a small team of 2-3 members (for tenured consultants)
- Strong understanding of different software development life cycles (Agile, waterfall) and contemporary software quality assurance processes and automated tools
- Knowledge and 3+ year experience with modern testing development practices and integrated testing products such as Pyspark based automation, Market tools like (QuerySerge, Talend, ETL Validator etc.) and their integration with tools such as Gitlab, etc.
- Experience with scripting languages like Unix Shell or Python for automating ETL testing.
- Hands-on experience on data modelling and data profiling tool.
- Perform analysis of data migration from various sources to target system in Cloud platform/ On prem environment.
- Flexibility to adapt and apply innovation to varied business domain and apply technical solutioning and learnings to use cases across business domains and industries
Good to Have:
- 2+ yrs. of experience in API testing (JSON,XML), API automation, creation of virtualized services, service virtualization testing using any of the industry tools like CA Dev Test/Parasoft/ CA Lisa
- Ability to perform estimation of test activities using quantitative methods
- Knowledge and experience working with Microsoft Office tool
- Experience on analyzing slow performing database queries / execution plan analysis.
- 3–6 years of experience working with ETL testing and Data migration testing.
Education:
· B.E./B. Tech/M.C.A./M.Sc. (CS) degree or equivalent from accredited university
Location:
· Hyderabad/Bengaluru