₹11L – ₹25L a year estimatetypical for IT Jobs in India, 903 posts
Posted 8 days ago Last checked 20 hr ago
Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Log, categorize, prioritize, analyze, and track L1 support tickets and operational alerts.
Perform functional analysis and initial root-cause investigation of application incidents and data inconsistencies using application…
Provide L1 application support, leveraging functional and application expertise to troubleshoot, diagnose, and resolve incidents within the…
Experience
4–8 years
Education
Bachelor's degree
Must-have skills
Data AnalysisSDLCSQL
Work mode
Hybrid
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Noida, Uttar Pradesh, , India Department: Information Technology
Job Description
Total Experience: 04–08 Years
Mandatory Requirements
Fluent in French (Read, Speak, and Write) with working proficiency in English.
IT/Computer Science background or relevant experience in software development, application support, or other IT-related fields.
Good understanding of SDLC, software concepts, and IT processes.
Hands-on experience in SQL for data analysis, validation, and troubleshooting.
Strong analytical, problem-solving, and troubleshooting skills.
High learning agility and ability to work independently.
Desirable Requirements
Knowledge of Retail and Supply Chain business processes.
Familiarity with IT support concepts and ticketing tools such as Jira or ServiceNow.
Understanding of application logs, technical runbooks, and SOPs.
Key Responsibilities
Log, categorize, prioritize, analyze, and track L1 support tickets and operational alerts.
Perform functional analysis and initial root-cause investigation of application incidents and data inconsistencies using application knowledge, SQL, logs, and existing runbooks.
Provide L1 application support, leveraging functional and application expertise to troubleshoot, diagnose, and resolve incidents within the defined scope.
Escalate complex issues to L2/L3 teams with appropriate diagnostic findings and functional impact assessments.
Coordinate with French-speaking stakeholders and technical teams for incident resolution.
Maintain and update SOPs, technical documentation, and knowledge base articles.
Qualifications
Any Graduate ( preferable in IT/ Comp Sc)
Additional Information
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.
Company Description
About Sopra Steria
Sopra Steria, a major Tech player in Europe with 51,000 employees in nearly 30 countries, is recognised for its consulting, digital services and solutions. 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 organisations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a 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 2025, the Group generated revenues of €5.6 billion. The world is how we shape it.
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
