Systems Integration Advisor

NTT DATA

6–8 yrs Mumbai Full Time Hybrid (office + remote)
NTT DATA logo
Posted : today
Actively hiring

Job description

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.

Responsibilities

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.

Qualifications

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.

Essential Skills

SQLPL/SQLDatabase TestingETL TestingData Warehouse TestingSnowflakeFunctional TestingRegression TestingTest AutomationDefect ManagementAgileScrum

Good to Have

Performance TestingQuery Optimization

Highlights

  • Actively hiring

More Details

RoleSystems Integration Advisor
IndustryIT Services and IT Consulting
DepartmentInformation Technology
Employment TypeFull Time, Hybrid (office + remote)

About the Company

NTT DATA logo

NTT DATA

IT Services and IT Consulting

Systems Integration Advisor at NTT DATA | SkillMX | SkillMX