CrawlJobs Logo

SSIS Production Service Support Lead

India, Noida · Job Posted February 14, 2026
Apply Position
Job Link Share

Job Description

We are seeking a highly skilled and experienced SSIS Production Support Lead with 8-10 years of hands-on experience to join our team. In this role, you will be responsible for supporting and maintaining our SSIS (SQL Server Integration Services) and ETL (Extract, Transform, Load) processes. Your expertise will contribute to the successful implementation and optimization of data integration solutions within our organization. The ideal candidate has a solid background in SSIS development and administration, along with excellent troubleshooting and problem-solving abilities.

Job Responsibility

  • Provide technical support and troubleshooting for SSIS and ETL-related issues in a production environment
  • Collaborate with cross-functional teams to understand business requirements and translate them into effective SSIS/ETL solutions
  • Design, develop, test, and deploy SSIS packages for data extraction, transformation, and loading processes
  • Monitor and maintain the performance, availability, and integrity of SSIS and ETL jobs
  • Identify and resolve performance bottlenecks and optimize ETL workflows for efficient data processing
  • Conduct root cause analysis for production incidents and implement preventive measures
  • Develop and maintain documentation, including system specifications, data mappings, and process flow diagrams
  • Stay up to date with industry trends and best practices in SSIS, ETL, and data integration technologies
  • Collaborate with database administrators, developers, and other stakeholders to ensure data quality and consistency
  • Participate in on-call support rotations and respond to critical issues in a timely manner

Requirements

  • B.E / B.Tech
  • Minimum of 8 years of experience in SSIS development and administration
  • Strong knowledge of ETL concepts, data integration methodologies, and best practices
  • Proficient in SQL programming and query optimization
  • Experience with performance tuning and optimization of SSIS packages
  • In-depth understanding of database systems, particularly Microsoft SQL Server
  • Solid understanding of data warehousing concepts and dimensional modelling
  • Familiarity with data governance and data quality principles
  • Strong analytical and problem-solving skills
  • Excellent communication and interpersonal skills
  • Ability to work independently and collaboratively in a team environment
  • Relevant certifications in SSIS or ETL technologies are a plus

Nice to have

Relevant certifications in SSIS or ETL technologies are a plus

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

SSIS Production Service Support Lead

8 matching positions

Business Intelligence Developer-Medicaid - Level I (Remote AZ)

The Business Intelligence Developer - Medicaid role is responsible for the desig...
Location
Location
United States , Phoenix
Salary
Salary:
Not provided
azblue.com Logo
Blue Cross Blue Shield of Arizona
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2 years of experience working with data, report development, and analysis in a workplace setting
  • 1 year of experience in query design and effective reporting design structure
  • High-School Diploma or GED in general field of study
  • Intermediate proficiency in T-SQL, SSMS, SSRS, SSIS, Visual Studio, SSDT, and Redgate
  • Intermediate knowledge of Microsoft SQL Server, SQL data bases, table/view/stored procedure development, query tuning, enterprise data modeling, normalizing data, and schema management
  • Knowledge of decision support systems, business intelligence, programming, and data analysis software
  • Knowledge of business Intelligence visualization platforms (Qlik Sense, Qlik View, Tableau, Power BI)
  • Intermediate proficiency in Microsoft Excel, Power Pivot, External connections, DAX/MDX, and Visual Basic
  • Intermediate proficiency in Microsoft Office Suite (Outlook, Teams, Excel, Word, Access, PowerPoint)
  • Functional proficiency in requirement analysis and gathering, scoping, and managing projects
Job Responsibility
Job Responsibility
  • Meet timeliness and accuracy goals
  • Use sound project management methodology and demonstrate solid time management skills
  • Effectively communicate status of work assignments to stakeholders and management via department defined communication channels and policy
  • Design, develop, or maintain reporting and/or analysis of data to measure financial or clinical outcomes, network performance, care management, claims processing, operations and/or other areas of the business
  • Design, develop, or maintain reporting and/or analysis of data for medical cost reporting, categories of service, unit cost and financial utilization metrics
  • Design, develop, or maintain reporting and/or analysis of data for clinical utilization, authorization, care management, risk adjustment, and claims data to support departmental functions
  • Receives, interprets, and completes data requests from Finance and other departments as necessary
  • Responsible for technical and production support documentation in accordance with department standards and industry best practices
  • Adhere to established source control versioning policies and procedures
  • Participate in all aspects of the Systems Development Life Cycle (SDLC)
  • Fulltime
Read More
Arrow Right
New

Assistant Manager (J+)- Regulatory Reporting

Location
Location
Pakistan , Lahore, Karachi, Islamabad
Salary
Salary:
Not provided
10pearls.com Logo
10Pearls
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 8 to 10 years of experience in Regulatory Reporting, with a deep understanding of finance and banking
  • Proficiency in PL/SQL and T-SQL, including experience with performance tuning of functions and procedures
  • Proficiency in Informatica Power Center 10.x or SSIS
  • Experience with data modeling and tools such as ERWIN or equivalent for handling complex data models
  • Experience engaging with business users for requirement gathering and documentation
  • Clear understanding of SIT/UAT processes and their importance in project success
  • Knowledge of finance and regulatory reporting processes is highly desirable
  • Proven ability to manage the complete lifecycle of software development, including experience in large enterprises with stringent management processes
  • Capability to independently lead projects and deliver high-quality results
  • Excellent analytical and problem-solving skills, with strong banking knowledge and troubleshooting abilities
Job Responsibility
Job Responsibility
  • Manage and administer the Finance Regulatory and Reporting Analytical platform, ensuring its reliability, performance, and alignment with business needs
  • Design, develop, and maintain complex data models with multiple subject areas to support advanced analytics and reporting capabilities
  • Engage with business users to gather requirements, document functional and technical specifications, and translate them into effective technical solutions
  • Manage all stages of the software development lifecycle, from planning and development to testing, deployment, and post-production support, adhering to enterprise-level change management processes
  • Facilitate and manage SIT and UAT phases to ensure smooth project implementation and delivery
  • Provide robust post-production support, addressing issues promptly and implementing performance optimizations to ensure system stability
  • Explore and implement opportunities to leverage cloud services and drive cloud migration initiatives where beneficial
  • Develop comprehensive documentation for solution architecture, technical designs, and project details
  • provide training and knowledge sharing to system users and team members
  • Lead projects independently, ensuring timely delivery of key milestones while collaborating effectively with cross-functional teams and country finance stakeholders
  • Fulltime
Read More
Arrow Right
New

.Net Developer

We are seeking a highly skilled Senior Software Developer with 10+ Yrs. Of deep ...
Location
Location
Costa Rica , Heredia
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 7+ years of professional object-oriented programming experience heavily focused on C# and VB.NET
  • 5+ years of experience working in discrete or continuous manufacturing environments
  • Deep understanding of MES workflows, batch processing, and industry standards
  • Expert-level capability with MS SQL Server, SSIS, SSRS, and/or Oracle databases
  • Hands-on experience with OPC DA/UA, REST/SOAP APIs, message queues (MSMQ), and connecting MES platforms to ERP systems
  • Experience with Visual Studio, Git, and Azure DevOps for CI/CD environments
  • Bachelor's degree in Computer Science, Software Engineering, or a related Engineering discipline
Job Responsibility
Job Responsibility
  • Architect and build advanced MES modules using C# and .NET
  • Safely modernize and migrate legacy, factory-critical VB.NET and ASP applications into modern .NET frameworks
  • Design robust integration layers connecting the MES layer with ERP (SAP/Oracle), SCADA, PLCs, and WMS (Warehouse Management Systems) using APIs and Web Services
  • Develop software that interacts with hardware controls, machine interfaces, and OPC servers to automate real-time data collection on the factory floor
  • Architect and optimize complex T-SQL queries, stored procedures, and triggers using MS SQL Server and/or Oracle databases to ensure high data integrity
  • Act as the technical lead on MES projects, reviewing code, writing technical specifications, and mentoring junior developers on engineering best practices
  • Provide tier-3, on-call support for critical production issues, minimizing equipment downtime and ensuring 24/7 system reliability
  • Fulltime
Read More
Arrow Right
New

Assistant Vice President, Applications Support Sr Analyst

We are seeking an experienced and highly motivated Assistant Vice President to j...
Location
Location
Singapore , Singapore
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s or master’s degree in computer science, Information Technology, Engineering, or a related field
  • 8+ Years of experience in application or production support with 2+ years at a lead level
  • Strong hands-on experience with Unix/Linus [ scripting, file manipulation, job control]
  • SQL is a must [ MSSQL/Oracle or similar, Stored proc, SSIS, SSRS ]
  • Big Data technologies [ Hadoop, Hive, Spark ]
  • Job Schedulers like Autosys
  • Log analysis tools
  • Solid understanding of financial instruments and trade lifecycle [ Equities, Fixed incomes, Secured Financing, Derivatives, Liquidity management ]
  • Familiarity with CUSIP, ISINs and other instrument identifiers
  • Knowledge of front office/back office and reporting workflows and operations
Job Responsibility
Job Responsibility
  • Provide L2/L3 production support for mission critical liquidity reporting and financial applications, ensuring high availability and performance
  • Monitor and resolve incidents related to trade capture, batch failures, position keeping, market data, pricing, risk and liquidity reporting
  • Engage with operations, traders, quants, development teams to understand and resolve production outages/issues
  • Proactively manage alerts, logs and jobs using Autosys, Unix tools, and monitoring platforms [ ITRS/AWP ]
  • Execute advance SQL queries and scripts for data analysis, validation, and issue resolution
  • Support multiple applications build on stored proc, SSIS, SSRS, Big data ecosystems [ hive, spark, Hadoop] and troubleshoot data pipeline issues
  • Maintain and improve knowledge bases, SOPs, and runbooks for production support
  • Participate in change management and release activities, including deployment validations
  • Lead root cause analysis [ RCA] , conduct post incident reviews, and drive permanent resolutions
  • Collaborate with infrastructure teams on capacity, performance, and system resilience initiatives
  • Fulltime
Read More
Arrow Right

Senior Software Developer

We are seeking a Senior Software Developer with over 8 years of experience to jo...
Location
Location
Canada , Toronto
Salary
Salary:
546.97 - 582.68 USD / Day
https://www.randstad.com Logo
Randstad
Expiration Date
July 13, 2026
Flip Icon
Requirements
Requirements
  • Over 8 years of experience
  • deep mastery of the Microsoft .NET Framework
  • proven track record in building secure, scalable B2B and B2C web applications within client/server architectures
Job Responsibility
Job Responsibility
  • Design and develop Web and Windows applications using C#, .NET Core, and the .NET Framework (4.0/5.0+)
  • Lead the installation, configuration, and customization of cloud-based services, including deployment and production support
  • Build and optimize complex database systems using MS SQL Server, including the development of advanced stored procedures and Entity Relationship Diagrams (ERDs)
  • Translate complex functional specifications into detailed technical designs, providing accurate effort estimations for development tasks
  • Develop client-side scripts using JavaScript and jQuery, and customize web forms to enhance user interaction
  • Manage the integration of modern digital platforms with various internal and external systems
  • Execute data migration and reporting tasks using tools such as SSIS, SSRS, and LINQ
  • Provide senior-level technical support for applications hosted on IIS, resolving issues related to performance and scalability
  • Fulltime
!
Read More
Arrow Right

Software Development Advisor

We are currently seeking a Software Development Advisor to join our team in CDMX...
Location
Location
Mexico , CDMX
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 10+ years of deep expertise in .NET, C#, VB.NET
  • Bachelor's degree in Computer Science, Software Engineering, or a related Engineering discipline
  • 7+ years of professional object-oriented programming experience heavily focused on C# and VB.NET
  • 5+ years of experience working in discrete or continuous manufacturing environments
  • Deep understanding of MES workflows, batch processing, and industry standards
  • Expert-level capability with MS SQL Server, SSIS, SSRS, and/or Oracle databases
  • Hands-on experience with OPC DA/UA, REST/SOAP APIs, message queues (MSMQ), and connecting MES platforms to ERP systems
  • Experience with Visual Studio, Git, and Azure DevOps for CI/CD environments
Job Responsibility
Job Responsibility
  • Architect and build advanced MES modules using C# and .NET
  • Safely modernize and migrate legacy, factory-critical VB.NET and ASP applications into modern .NET frameworks
  • Design robust integration layers connecting the MES layer with ERP (SAP/Oracle), SCADA, PLCs, and WMS (Warehouse Management Systems) using APIs and Web Services
  • Develop software that interacts with hardware controls, machine interfaces, and OPC servers to automate real-time data collection on the factory floor
  • Architect and optimize complex T-SQL queries, stored procedures, and triggers using MS SQL Server and/or Oracle databases to ensure high data integrity
  • Act as the technical lead on MES projects, reviewing code, writing technical specifications, and mentoring junior developers on engineering best practices
  • Provide tier-3, on-call support for critical production issues, minimizing equipment downtime and ensuring 24/7 system reliability
  • Fulltime
Read More
Arrow Right

Senior Software Development .NET C# VB.NET

We are currently seeking a Senior Software Development- .NET, C#, VB.NET to join...
Location
Location
Mexico , Guadalajara
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Software Engineering, or a related Engineering discipline
  • 7+ years of professional object-oriented programming experience heavily focused on C# and VB.NET
  • 5+ years of experience working in discrete or continuous manufacturing environments
  • Deep understanding of MES workflows, batch processing, and industry standards
  • Expert-level capability with MS SQL Server, SSIS, SSRS, and/or Oracle databases
  • Hands-on experience with OPC DA/UA, REST/SOAP APIs, message queues (MSMQ), and connecting MES platforms to ERP systems
  • Experience with Visual Studio, Git, and Azure DevOps for CI/CD environments
Job Responsibility
Job Responsibility
  • MES Development & Modernization: Architect and build advanced MES modules using C# and .NET. Safely modernize and migrate legacy, factory-critical VB.NET and ASP applications into modern .NET frameworks
  • System Integration: Design robust integration layers connecting the MES layer with ERP (SAP/Oracle), SCADA, PLCs, and WMS (Warehouse Management Systems) using APIs and Web Services
  • OT/IT Convergence: Develop software that interacts with hardware controls, machine interfaces, and OPC servers to automate real-time data collection on the factory floor
  • Database & Reporting: Architect and optimize complex T-SQL queries, stored procedures, and triggers using MS SQL Server and/or Oracle databases to ensure high data integrity
  • Technical Leadership & Mentorship: Act as the technical lead on MES projects, reviewing code, writing technical specifications, and mentoring junior developers on engineering best practices
  • Support & Maintenance: Provide tier-3, on-call support for critical production issues, minimizing equipment downtime and ensuring 24/7 system reliability
Read More
Arrow Right

L2 Application Support Analyst – Financial Systems

Join Citi's Production and Application Support team, where you will keep mission...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6 or more years of experience in application or production support, with at least 2 years operating at an advanced level in a financial services environment
  • Hands-on capability with Unix/Linux, including scripting, file manipulation, and job control, combined with advanced SQL skills across platforms such as MSSQL or Oracle, including stored procedures, SSIS, and SSRS
  • Practical experience working with Big Data technologies — Hadoop, Hive, and Spark — and job scheduling tools such as Autosys, including log analysis and pipeline troubleshooting
  • Solid knowledge of financial instruments and trade lifecycle operations, covering Equities, Fixed Income, Secured Financing, Derivatives, and Liquidity Management
  • Familiarity with front office and back office workflows, including reporting operations and the systems that support them
  • Demonstrated ability to analyse complex, time-sensitive issues systematically and communicate findings clearly to both technical and business audiences
  • Working knowledge of ITIL practices, including incident management, problem management, and change management processes
  • Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience
Job Responsibility
Job Responsibility
  • Deliver L2 production support for mission-critical liquidity reporting and financial applications, maintaining high availability and consistent performance across the trading lifecycle
  • Monitor, triage, and resolve production incidents related to trade capture, batch processing failures, position keeping, market data, pricing, and risk and liquidity reporting
  • Manage scheduled jobs, alerts, and system logs using job scheduling tools and Unix-based monitoring platforms to prevent and contain service disruptions
  • Execute advanced SQL queries and scripts to analyse data, validate outputs, and resolve data integrity issues across multiple application layers
  • Troubleshoot data pipeline failures across applications built on stored procedures, reporting services, and Big Data ecosystems including Hadoop, Hive, and Spark
  • Lead root cause analysis for major incidents, coordinate post-incident reviews, and implement permanent fixes to prevent recurrence
  • Coordinate change management and release activities, including deployment validations and post-release checks, to maintain production stability
  • Maintain and improve operational knowledge bases, standard operating procedures, and runbooks to support team effectiveness and knowledge continuity
What we offer
What we offer
  • Hybrid working model — 3 days in the office and 2 days working remotely, giving you flexibility alongside meaningful in-person collaboration
  • Exposure to complex, high-stakes financial systems spanning multiple asset classes and trading workflows, deepening both your technical and domain expertise
  • Access to learning and development opportunities that support your growth across production support, financial technology, and service management disciplines
  • The opportunity to work across global teams, collaborating with infrastructure, development, and business stakeholders on initiatives that improve system resilience and service quality
  • A supportive environment that values work-life balance, wellbeing, and long-term career development within one of the world's leading financial institutions
  • Fulltime
Read More
Arrow Right