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
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
Good experience in UI Modelling Language QML and its integration with QT for user interface. Should have experience in C++ and Object-oriented design. Added advantage on having experience in SAFe Agil
Reference
9e01f136-5686-431d-8be4-44e7b4f72efe
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
Job Title: Module Lead - Java Spring Boot / Angular Primary Skills: Java 8+, Spring Boot, AWS Secondary Skills: Java Script/Angular Job Summary: We are looking for a skilled profile with good experien
Reference
7742883c-76b2-4e6e-886a-25722acbb29c
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
Proven hands-on network engineering experience Solid understanding of the OSI or TCP/IP model Deep Hands on to understand the incident and troubleshooting with SLA. Deep understanding of networking ro
Reference
721c873f-184e-40e6-9a4b-7bd9c2d88989
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
Mandatory Skills: 1. Native Hana Developer (Table Functions , SQL script, CV, Database Procedure), with basic understanding of SLT/SDA. 2. HANA Studio/Web IDE 3. SAP ABAP, ODATA Good to have Skills:
Reference
e201c5f3-ae45-4b4b-a6e6-f8adba245f0e
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
- Minimum of 4-6 years of experience in software development, with at least 2-3 years of experience in full stack development. - Proven track record of leading teams and delivering high-quality softwa
Reference
e1ef86fe-12cb-4da9-a737-27be38230e0f
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
Software Engineer with expertise in JAVA, J2EE, Spring, Spring Boot, EXTJS Technology: JAVA, J2EE, Spring, Spring Boot, EXTJS DB: Oracle (SQL, PL-SQL) Tools: Jenkin, GitHub, DevOps CI/CD, App Scan.
Reference
f13b75bb-6147-4f78-80d1-1b0fd4556791
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
Technology: Vue3, JAVA, Spring Boot, Microservices DB: PostgreSQL Tools: Docker, Kubernetes, Jenkin, GitHub, DevOps CI/CD, App Scan Other good to have skills: Azur cloud working experience, Python, Po
Reference
05905748-bebf-46ac-b011-040fabaa6646
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
• Order Management, Procurement, I-Procurement, Inventory • Expert Knowledge on Business Processes 4-6 Plus years’ of experience with Oracle Application, at least 4 + years of experience in Oracle E
Reference
cb69143a-3282-4103-b894-bf3acf355f17
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
Job Description Manage calls, emails, chats, incidents, and alerts using the Service Now ticketing tool, ensuring all necessary details are recorded and issues are addressed promptly. Document all inc
Reference
ac4e47d2-9181-4ddc-acfc-627fe8bf95a4
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
1). Complex problem analysis, ability to diagnose, formalize, reproduce & address application issues. 2). Testing& Validation: Conduct End-to-End (E2E) testing and Business Acceptance Testing (BAT) to
Reference
6e516d16-86fa-4489-a4a5-705fc84d16ad
Expiry Date
Jan 1, 0001