Tech Consultant - SQL Server Integration Services (SSIS)

• NTT DATA’s Client is seeking an experienced, hands-on SQL Server / SSIS Application Engineer to support mission-critical production processes built primarily on Microsoft SQL Server, T-SQL stored procedures, SSIS, and related SQL Server technologies.
• The contractor will analyze existing production workloads, diagnose failures and performance issues, optimize complex SQL and ETL processes, and improve the reliability, maintainability, and operational supportability of critical business processes., * Troubleshoot and resolve production issues involving complex T-SQL stored procedures, SSIS packages, SQL Agent jobs, and batch processes.
• Analyze slow-running or unstable SQL workloads and identify root causes.
• Optimize stored procedures, queries, indexes, execution plans, temp-table usage, locking, blocking, and transaction handling.
• Debug and optimize SSIS packages, including data flows, control flows, transformations, error handling, restart/recovery, and performance.
• Diagnose dependencies and failures across multi-step batch and ETL workflows.
• Perform root-cause analysis of recurring production incidents and implement durable fixes rather than short-term workarounds.
• Improve logging, monitoring, exception handling, reconciliation, and operational supportability.
• Refactor legacy SQL and SSIS components where necessary while preserving critical business functionality.
• Partner with application developers, DBAs, infrastructure teams, and business SMEs to understand and improve existing processes.
• Document process flows, dependencies, failure points, recovery procedures, and technical improvements.

• Advanced T-SQL development, including complex stored procedures, functions, views, CTEs, temporary tables, and transaction management.
• Extensive experience debugging and optimizing Microsoft SQL Server production workloads.
• Strong knowledge of SQL Server execution plans, indexing strategies, query optimization, statistics, locking, blocking, and deadlocks.
• Extensive hands-on experience with SQL Server Integration Services (SSIS).
• Experience troubleshooting SQL Agent jobs, batch processing, ETL pipelines, and complex process dependencies.
• Ability to analyze unfamiliar legacy code and quickly understand complex business processing logic.
• Strong production troubleshooting and root-cause-analysis skills.
• Experience supporting high-volume, mission-critical production systems where processing accuracy and recoverability are essential.

Preferred Skills

• PowerShell and automation experience.
• SQL Server Profiler, Extended Events, Query Store, and other SQL Server diagnostic tools.
• Experience with very large databases and high-volume batch processing.
• Performance tuning of ETL and data-intensive applications.
• Git and Azure DevOps experience.
• Experience supporting financial processing, reconciliation, settlement, billing, payments, rebates, or other calculation-intensive applications.
• Experience working within production change-management and incident-management processes in a regulated financial institution.

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com