Systems Integration Advisor

NTT DATA

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

Job description

Join NTT DATA, a global leader in IT services, as a Systems Integration Advisor in Mumbai. We are looking for innovative and passionate individuals to contribute to our forward-thinking organization. This role involves designing and developing robust data solutions, leveraging Snowflake and advanced SQL techniques to meet complex business needs.

As part of our dynamic team, you will work with large datasets, implement efficient data processing, and collaborate closely with stakeholders in an Agile environment. We offer a unique opportunity to grow your career with a company committed to client success and societal impact.

Responsibilities

Key responsibilities include designing, developing, and maintaining data solutions and pipelines within Snowflake. You will craft optimized SQL queries, stored procedures, and views, while also performing data analysis and profiling.

Furthermore, you will engineer ETL/ELT processes for seamless data integration from various sources. Optimizing SQL and Snowflake queries for performance and efficiency is crucial. Developing and maintaining Unix/Shell scripts for automation and monitoring, along with troubleshooting data issues and production incidents, are core duties.

You will also be involved in data validation and reconciliation, ensuring data accuracy. Collaboration with business analysts and other engineers to understand requirements and deliver solutions is key. Active participation in Scrum ceremonies and supporting continuous improvement activities are expected.

Qualifications

We require a Systems Integration Advisor with over 5 years of experience in data/database development, specifically with extensive hands-on Snowflake experience. A strong command of Advanced SQL, including complex joins, CTEs, subqueries, window functions, and aggregations, is essential.

Proficiency in SQL query performance tuning and optimization is a must, alongside hands-on experience with Snowflake database objects. Solid understanding of ETL/ELT concepts and data integration principles is required. Experience with Unix/Linux and Shell scripting is also necessary.

Candidates should possess strong data analysis, troubleshooting, analytical, and problem-solving skills, with a good grasp of data warehousing concepts and data modeling. The ability to translate complex data requirements into technical solutions is vital. Experience in an Agile/Scrum environment and excellent communication and collaboration skills are expected.

Essential Skills

SnowflakeSQLETLELTUnix/Shell ScriptingData AnalysisData WarehousingAgile/ScrumData PipelinesStored ProceduresData TransformationQuery OptimizationProblem-Solving

Highlights

  • Actively hiring

More Details

RoleSystems Integration Advisor
IndustryInformation Technology & Services
DepartmentData Science
Employment TypeFull Time, Hybrid (office + remote)

About the Company

NTT DATA logo

NTT DATA

Information Technology & Services