CrawlJobs Logo

SSIS Production Service Support Lead

https://www.soprasteria.com Logo

Sopra Steria

Location Icon

Location:
India , Noida

Category Icon

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

Not provided

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

Additional Information:

Job Posted:
February 14, 2026

Job Link Share:

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for SSIS Production Service Support Lead

Microsoft SQL Server Analysis Services (SSAS) Module Lead

Microsoft SQL Server Analysis Services (SSAS) Module Lead position at Sopra Ster...
Location
Location
India , Chennai
Salary
Salary:
Not provided
https://www.soprasteria.com Logo
Sopra Steria
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 4+ Years with Retail Knowledge and Application
  • should be experienced in SSAS and Cube Reports
  • Quickly understand Business process and enable to onboard Application Support ASAP
  • Work with an experienced product and architecture team to build IT solutions that support merchandising processes
  • Be an expert on certain functions, processes, or tools
  • Use SSAS and SSIS for reporting and able to write complex Queries in SQL
  • Strong SQL skills
  • experience with data warehousing concepts
  • proficiency in the respective toolset (SSAS for data modeling and analysis
  • SSIS for data extraction, transformation, and loading)
Job Responsibility
Job Responsibility
  • Work with an experienced product and architecture team to build IT solutions that support merchandising processes
  • Be an expert on certain functions, processes, or tools
  • Use SSAS and SSIS for reporting and able to write complex Queries in SQL
What we offer
What we offer
  • inclusive and respectful work environment
  • positions open to people with disabilities
  • Fulltime
Read More
Arrow Right

SQL Developer Module Lead

We are looking for an experienced SSIS and MS SQL Developer to design, develop, ...
Location
Location
India , Chennai
Salary
Salary:
Not provided
https://www.soprasteria.com Logo
Sopra Steria
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Hands-on experience with MS SQL Server
  • Proficiency in T-SQL programming (queries, stored procedures, functions, triggers)
  • Strong experience with SQL Server Integration Services (SSIS) for ETL processes
  • Experience in query optimization, indexing, and performance tuning
  • Relevant experience in database maintenance and support
  • Strong problem-solving skills and attention to detail
  • Excellent communication and teamwork abilities
Job Responsibility
Job Responsibility
  • Design and develop complex T-SQL queries, stored procedures, views, functions, and triggers
  • Optimize database queries for improved performance and efficiency
  • Develop scripts for data migration, import/export, and transformation tasks
  • Design, develop, and maintain ETL processes using SSIS
  • Create, modify, and troubleshoot SSIS packages for data integration, migration, and transformation
  • Monitor and support production databases to ensure high availability and performance
  • Troubleshoot and resolve database-related issues in production environments
  • Identify and optimize long-running queries, deadlocks, and other performance bottlenecks
  • Provide 24/7 production support as part of an on-call rotation for critical issues
  • Perform root cause analysis and provide resolutions for database incidents and outages
What we offer
What we offer
  • Inclusive and respectful work environment
  • Commitment to fighting against discrimination
  • Open to people with disabilities
  • Fulltime
Read More
Arrow Right

Solutions Architect

Ampa (home of Shakespeare Martineau, Mayo Wynne Baxter, Marrons and further bran...
Location
Location
United Kingdom , Flexible
Salary
Salary:
Not provided
ampa.co.uk Logo
Ampa - Legal & Professional Services
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • A minimum of 3 years demonstrable track record of successful solution design and delivery of complex technical and service solutions
  • Experience of solutions architecture is essential
  • Certified in and experienced with one or more Architecture Frameworks
  • Evaluating technical opportunities and providing innovative solutions
  • A demonstrable track record in the successful design and delivery of complex solutions
  • Working with various roles, capabilities and skills within an organisation providing the delivery capability needed to ensure successful business outcomes
  • The ability to drive through innovations and best practices from concept to implementation
  • Development techniques
  • Domain-driven design, Scrum/Agile, API Design Principles
  • Significant previous experience with Microsoft Power Platform
Job Responsibility
Job Responsibility
  • Ensures the effective design & delivery of solutions and systems both on-prem and in the cloud, ensuring high-level analysis of requirements and existing solutions
  • Working closely with Enterprise Architecture and technical SME, the Solutions Architect stays informed of current and emerging technologies ensuring innovative solutions
  • The Technology Solutions Architect will form part of a wider architecture landscape working collaboratively with teams across Technology, Data, Security and Business domains
  • Owning the Solutions roadmap, the Solutions Architect is pivotal in supporting change initiatives and plays a key role as part of the Technical Design Authority
  • Commensurate with this responsibility, this role is responsible for the assurance of and where necessary the production of solution design documentation whether this be internal or through partner suppliers
  • Having responsibility for the architecture of all solutions delivered to the business, both from internal and external suppliers
  • Facilitating the handover from development and pilot into supported production, ensuring that appropriate documentation and support models are in place
  • Own architectural blueprint for our solutions
  • Defining and monitoring solutions to ensure benefits are realised
  • Having responsibility for leading key strategic changes and influencing the business
What we offer
What we offer
  • Agile working
  • Blended approach to where and how we work
  • Genuine flexibility
  • Award-winning development
  • Multi-brand experiences
  • Diverse expertise
  • Modern tech
  • Culture that encourages you to think boldly, be yourself, and shape a career that excites you
  • Fulltime
Read More
Arrow Right

IT Applications Specialist III - HRIS

Under the supervision of the Director, Enterprise Applications, the IT Applicati...
Location
Location
United States , Denver
Salary
Salary:
86800.00 - 112900.00 USD / Year
innovage.com Logo
InnovAge
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Information Systems Management, Accounting/Finance, Engineering or a related field from an accredited college/university
  • Minimum of 8 years of experience providing applications support, systems integration and system administration
  • Experience in supporting business related systems
  • Experience with and understanding relational databases, Active Directory and Microsoft Office Suite
  • Understanding of Human Resources principles depending on role
  • Understanding of IT General Controls and how to operate within said controls
  • Experience with Tier II and Enterprise level systems
  • Ability to analyze situations/problems and determine a plan on how to address without a playbook using strong critical thinking skills
  • Strong understanding of business/operational transactions and process flow as it relates to various types of Business Systems and related transactions
  • Install and configure application components
Job Responsibility
Job Responsibility
  • Installs applications in the development and system test environments for Development and UAT testing
  • Performs system administration by writing utilities and monitoring information technology services
  • Provides technical support and maintenance of installed applications software
  • Assists with implementation, configuration and testing of new product versions with end users
  • Interacts with end users and software vendors in order to troubleshoot installation and implementation issues
  • Develops and maintains detailed technical knowledge of the specifications, operation, and diagnostic of products
  • Organizes, produces, and reports on the progress of ongoing testing, trials, and evaluation of new products and services
  • Conducts orientation to new users regarding applications of software
  • Functions as a key point of user contact and customer service for business systems and is accountable for user satisfaction
  • Assists in the execution of large and small IT projects
What we offer
What we offer
  • Medical/dental/vision insurance
  • Short and long-term disability
  • Life insurance and AD&D
  • Supplemental life insurance
  • Flexible spending accounts
  • 401(k) savings
  • Paid time off
  • Company-paid holidays
  • 401(k) plan with company match
  • Fulltime
Read More
Arrow Right

Management Information (MI) Developer

DAC Beachcroft’s Claims Solutions Data Analytics team provides products to both ...
Location
Location
United Kingdom , Birmingham
Salary
Salary:
Not provided
dacbeachcroft.com Logo
DAC Beachcroft
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Degree level qualification in maths, science, business or computing
  • 3+ years’ experience in a data/analytical role, ideally within Legal, Finance or other regulated industries
  • Advanced knowledge of T-SQL, SSRS, SSIS, GIT
  • Strong experience of data extraction, migration, reporting, quality checks and / or analytical projects, together with usage of source control products such as GIT
  • Solid communication, including the ability to define and document technical requirements, describe data analytics models outputs and methods clearly, and convey the related benefits to peers, customers and stakeholders as required
  • Demonstrates alignment with the Firm’s Cultural Principles (Clear, Creative, Determined and Supportive)
Job Responsibility
Job Responsibility
  • Development and delivery of both new and existing Management Information (MI) reports
  • analysis
  • testing and troubleshooting of the MI Estate typically using T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
  • MI design and production responsibility
  • Ensure the design, development and delivery of analytical models and / or contractual reporting and related tasks within agreed timescales, whilst conforming to the development and change process
  • Ability to work on a broad portfolio of delivery, ad hoc requests, and data requirements that support broader business activity, managing their own work through the agreed systems
  • Work with line management and key stakeholders within MI, IT and the wider business to establish robust MI specification
  • Leading the regular review and audit of the existing portfolio of MI reports, identifying, and implementing continuous improvement in both service delivery, process reengineering, and product quality
  • Ability to represent the MI function in dialogue with the business
What we offer
What we offer
  • High levels of flexibility and a great work life balance
  • A well-rounded remuneration package (which includes private medical insurance, income protection insurance and discounted gym membership, amongst many other benefits)
  • Opportunities for growth and progression including professional funding
  • In person and remote social events
  • Opportunity to get involved in a range of Environmental, Social and Governance (ESG) activities
Read More
Arrow Right

Management Information (MI) Developer

We are now recruiting for an Management Information (MI) Developer to join the t...
Location
Location
United Kingdom , Newport
Salary
Salary:
Not provided
dacbeachcroft.com Logo
DAC Beachcroft
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Degree level qualification in maths, science, business or computing
  • 3+ years experience in a data/analytical role, ideally within Legal, Finance or other regulated industries
  • Advanced knowledge of T-SQL, SSRS, SSIS, GIT
  • Strong experience of data extraction, migration, reporting, quality checks and / or analytical projects, together with usage of source control products such as GIT
  • Solid communication, including the ability to define and document technical requirements, describe data analytics models outputs and methods clearly, and convey the related benefits to peers, customers and stakeholders as required
  • Demonstrates alignment with the Firm's Cultural Principles (Clear, Creative, Determined and Supportive)
Job Responsibility
Job Responsibility
  • Development and delivery of both new and existing Management Information (MI) reports
  • analysis
  • testing and troubleshooting of the MI Estate typically using T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
  • MI design and production responsibility
  • Ensure the design, development and delivery of analytical models and / or contractual reporting and related tasks within agreed timescales, whilst conforming to the development and change process
  • Ability to work on a broad portfolio of delivery, ad hoc requests, and data requirements that support broader business activity, managing their own work through the agreed systems
  • Work with line management and key stakeholders within MI, IT and the wider business to establish robust MI specification
  • Leading the regular review and audit of the existing portfolio of MI reports, identifying, and implementing continuous improvement in both service delivery, process reengineering, and product quality
  • Ability to represent the MI function in dialogue with the business
What we offer
What we offer
  • High levels of flexibility and a great work life balance
  • private medical insurance
  • income protection insurance
  • discounted gym membership
  • opportunities for growth and progression including professional funding
  • in person and remote social events
  • opportunity to get involved in a range of Environmental, Social and Governance (ESG) activities
  • Fulltime
Read More
Arrow Right

.NET Full Stack Technical Lead

The .NET Full Stack Technical Lead will be responsible for maintaining and enhan...
Location
Location
United States , Parispanny, New Jersey
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience in GCP Platform - Firebase Firestore and NoSQL
  • Strong development experience with C# and .NET Core (or later)
  • Proficient in front-end technologies: HTML, CSS, JavaScript, TypeScript, and Angular (modern versions)
  • Experience with web services: SOAP and REST APIs
  • SQL experience: Microsoft SQL Server and familiarity with SSIS packages
  • Experience with background services and Windows Server hosted apps
  • Familiar with CI/CD tooling: Azure DevOps (ADO) pipelines, Git-based source control
  • Familiarity with static analysis and security tooling: SonarQube, web vulnerability scanners (e.g., Netsparker / Invicti)
  • Knowledge of logging and artifact management (e.g., JFrog or equivalent)
  • Ability to work with cloud platforms and cloud-native patterns (either GCP or Azure experience preferred)
Job Responsibility
Job Responsibility
  • Maintain and support multiple web applications and backend services (enrollment, account management, rate-quoting, customer events repository, contact-center backup)
  • Provide tier 2/3 technical support for application issues, perform incident troubleshooting and root cause analysis
  • Deliver development tasks and backlog items (bug fixes, enhancements, integration work)
  • Participate in DevOps/CI-CD activities to improve release pipelines, automation, and test coverage
  • Execute security vulnerability remediation and respond to automated scan findings
  • Support disaster recovery (DR) planning and exercises, including failover and temporary operations in alternate datacenters/cloud regions
  • Coordinate with infrastructure teams on patching, OS/DB upgrades, and certificate management
  • Migrate legacy interfaces to modern APIs (e.g., SOAP → REST, or legacy web services → modern service endpoints)
  • Perform yearly password rotations across databases, Linux jobs, cloud services, and API credentials
  • Participate in scheduled DR exercises
Read More
Arrow Right

MI Developer

DAC Beachcroft’s Claims Solutions Data Analytics team provides products to both ...
Location
Location
United Kingdom , Newport
Salary
Salary:
Not provided
dacbeachcroft.com Logo
DAC Beachcroft
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Degree level qualification in maths, science, business or computing
  • 3+ years’ experience in a data/analytical role, ideally within Legal, Finance or other regulated industries
  • Advanced knowledge of T-SQL, SSRS, SSIS, GIT
  • Strong experience of data extraction, migration, reporting, quality checks and / or analytical projects, together with usage of source control products such as GIT
  • Solid communication, including the ability to define and document technical requirements, describe data analytics models outputs and methods clearly, and convey the related benefits to peers, customers and stakeholders as required
  • Demonstrates alignment with the Firm’s Cultural Principles (Clear, Creative, Determined and Supportive)
Job Responsibility
Job Responsibility
  • Development and delivery of both new and existing Management Information (MI) reports
  • analysis
  • testing and troubleshooting of the MI Estate typically using T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
  • Ensure the design, development and delivery of analytical models and / or contractual reporting and related tasks within agreed timescales, whilst conforming to the development and change process
  • Ability to work on a broad portfolio of delivery, ad hoc requests, and data requirements that support broader business activity, managing their own work through the agreed systems
  • Work with line management and key stakeholders within MI, IT and the wider business to establish robust MI specification
  • Leading the regular review and audit of the existing portfolio of MI reports, identifying, and implementing continuous improvement in both service delivery, process reengineering, and product quality
  • Ability to represent the MI function in dialogue with the business
What we offer
What we offer
  • High levels of flexibility and a great work life balance
  • A well-rounded remuneration package (which includes private medical insurance, income protection insurance and discounted gym membership, amongst many other benefits)
  • Opportunities for growth and progression including professional funding
  • In person and remote social events
  • Opportunity to get involved in a range of Environmental, Social and Governance (ESG) activities
Read More
Arrow Right