Systems Integration Advisor
NTT DATA
NTT DATA
NTT DATA seeks a dedicated Systems Integration Advisor to join our dynamic team in Mumbai, India. We are looking for innovative and passionate individuals eager to contribute to our growth in an inclusive and forward-thinking organization.
This role involves ensuring data integrity and accuracy through comprehensive testing of databases and Snowflake environments. You will play a crucial part in validating complex data transformations and backend processes, contributing to the overall quality of our data solutions.
Perform end-to-end testing for databases and Snowflake, ensuring data accuracy, completeness, and integrity. Develop and execute sophisticated SQL and PL/SQL queries for backend validation and reconciliation. Validate database objects such as tables, views, stored procedures, and triggers. Execute functional, regression, integration, automation, and performance testing for database applications. Validate data transformations and ensure adherence to business rules across different systems.
Conduct source-to-target data validation, reconciliation, and quality checks. Test complex PL/SQL procedures and database transactions. Validate Snowflake data loads and transformations. Perform database and SQL performance testing, identifying bottlenecks and supporting query optimization. Develop automated test scripts and frameworks for database validation. Analyze test failures, perform root-cause analysis, and collaborate with developers for defect resolution. Drive defect triage, prioritization, and track them to closure, communicating status to stakeholders.
Requires 6–8 years of experience in Database, ETL, or Data Warehouse Testing. Strong proficiency in SQL and PL/SQL, including complex queries, joins, and analytical functions. Solid understanding of database concepts like triggers, indexes, and stored procedures. Hands-on experience with Snowflake/Database testing and functional/regression testing. Experience in test automation for database/data validation is preferred. Good knowledge of database performance testing and query analysis. Proven experience in defect management, debugging, and root-cause analysis.
Excellent analytical and problem-solving skills. Ability to independently lead defect triage discussions. Experience working within an Agile/Scrum framework, actively participating in ceremonies. Strong written and verbal communication skills are essential for effective collaboration with development and business teams.
NTT DATA
IT Services and IT Consulting