SSIS and MS SQL Developer (Development & Production Support)
__jobinformationwidget.freetext.LocationText__
Chennai, Tamil Nadu, India
- Sopra Steria
- Engineering, Development, Applications
- 3 to 5 years
- Standard
- India
This vacancy has now expired. See all jobs
About Sopra Steria
Sopra Steria, a major Tech player in Europe with 56,000 employees in nearly 30 countries, is recognized for its consulting, digital services and software development. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group provides end-to-end solutions to make large companies and organizations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a fully collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. In 2023, the Group generated revenues of €5.8 billion.
The world is how we shape it.
We are looking for an experienced SSIS and MS SQL Developer to design, develop, and support SQL Server databases and SSIS packages. The role involves working on development projects and providing production support to ensure smooth database operations and optimal performance.
- SQL Server Development:
- 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.
- SSIS Package Development:
- Design, develop, and maintain ETL (Extract, Transform, Load) processes using SSIS.
- Create, modify, and troubleshoot SSIS packages for data integration, migration, and transformation.
- Scheduling of SSIS packages.
- Production Support:
- 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.
Required Technical Skills:
- 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.
Good to have: Knowledge or work experience in SSRS, C#.net/Java, Python, Zendesk, JIRA, BizTalk, RTI, Jenkins, Splunk, CICD, New Relic, Autosys scheduler, CA7 scheduler.
Total Experience Expected: 04-06 years
- Relevant experience in database maintenance and support.
- Strong problem-solving skills and attention to detail.
- Excellent communication and teamwork abilities.
- Must be willing to work in shifts and participate in on-call support as required.
At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.
All of our positions are open to people with disabilities.
Discover what working at Sopra Steria looks like...
Are you looking for a place where you can free your creativity and take initiatives, supported by tech experts?
Join us on this adventure where every idea counts and every talent steps up.
Job offers that might interest you
Salary
Location
Noida, Uttar Pradesh, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Noida, Uttar Pradesh
Description
Description: Ideal candidate must be self-motivated with a proven track record in working on ServiceNow Platform Having an experience in ServiceNow Development from medium to complex needs. Able to Un
Reference
4af38e1c-3c6f-4d77-894d-7150538a1536
Expiry Date
Jan 1, 0001
Salary
Location
Chennai, Tamil Nadu, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Chennai, Tamil Nadu
Description
Total Experience Expected: 04-06 years Work Location: Chennai Mode of work: Hybrid (3 days to office every week) Shift: UK shift and UK holidays Must have hands-on: Mainframe (Cobol, JCL, IMS DB, V
Reference
8a6306f2-ca8e-421a-be0b-f7f7799f6929
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Noida, Uttar Pradesh
Description
Experience: 4yr to 6yr Work Location: Noida / Bangalore Mode of work: Hybrid (3 days office every week) Profound ABAP development experience and good in Performance Tuning Knowledge on all RI
Reference
48ff99e2-2b1a-4e1a-a3b8-d5abb5e83309
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Noida, Uttar Pradesh
Description
Experience: 4 to 6 years Work Location: Noida / Bangalore Mode of work: Hybrid (3 days office every week) Strong working experience on ABAP (RICEF) Objects on SAP S4 HANA system Proficient in OOABAP
Reference
02293f95-6e5c-457b-8d1a-873143b409b2
Expiry Date
Jan 1, 0001
Salary
Location
Chennai, Tamil Nadu, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Chennai, Tamil Nadu
Description
Job Summary Responsible for the entire development and support process for a software programme. • Take a business problem and come up with the technical strategy (push vs pull etc real time vs ba
Reference
2578b75d-ca1c-4dfe-9347-14f56a99c96f
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Noida, Uttar Pradesh
Description
Oracle Hyperian Essbase A knowledge of PL/SQL,VBA and PowerShell scripting. Develop Reports in Power BI/Cognos. Role is for developing, customizing, maintaining and support of Concur and Essbase as pe
Reference
581da28d-b652-47b0-9e9c-737d352e32b7
Expiry Date
Jan 1, 0001
Author
Sarah SmithAuthor
Sarah SmithSalary
Location
Noida, Uttar Pradesh, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Noida, Uttar Pradesh
Description
Support for E-Commerce Project Good working experience Manhattan Omni Active (Support + Maintenance + Configuration) Manage Order management application. Resolving tickets and monitoring the applicati
Reference
49ce1eb1-43e0-4164-bd05-e5d37d2838ed
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Noida, Uttar Pradesh
Description
Description: Ideal candidate must be self-motivated with a proven record of accomplishment in working on ServiceNow Platform. Having an experience in ServiceNow Development from medium to complex need
Reference
e23556b2-25e8-4088-98a2-793826bcd1d0
Expiry Date
Jan 1, 0001
Author
Sarah SmithAuthor
Sarah SmithSalary
Location
Noida, Uttar Pradesh, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Noida, Uttar Pradesh
Description
Experience: 4 to 6 years Strong working experience on ABAP (RICEF) Objects on SAP S4 HANA system Proficient in OOABAP, IDOC and ABAP new syntax Must have exposure to CDS View and AMDP Good to have kno
Reference
515673c6-6481-46ce-bed7-f28022f6d854
Expiry Date
Jan 1, 0001
Salary
Location
Bengaluru, Karnataka, India
Job Type
Standard
Experience Level
3 to 5 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Location
Bengaluru, Karnataka
Description
Must to have skills ○ CATIAV5 Functional Knowledge(part/Assembly/Generative shape Design) ○ CATIA V5 CAA ○ C++, Data structures and Design Patterns ○ C# and .Net ○ Geometry Concepts ○ Git Source cod
Reference
b7780fc6-1459-42aa-967d-0caa99375949
Expiry Date
Jan 1, 0001