Genpact global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients.

Genpact inviting applications for the role of Software Developer – SQL Developer Support.

Job Designation : Software SQL Developer

Qualification : BE/BTech/MTech

Experience : Freshers/Experienced

Skill Set :

1. Proficient in SQL programming, Debugging, Performance tuning, Database Design, Table schema.
2. Good knowledge on Azure Data Factory, Azure SQL.
3. Strong knowledge of Relational Databases Management Systems (RDBMS) concepts.
4. Strong Knowledge of creating packages, stored procedures, cursors, triggers, functions, joins, replication and modifying SQL scripts in Oracle.
5. Basic knowledge of database administration, database design, data modeling, and data warehousing.
6. Expertise with database design, data modeling, and data warehousing.
7. Strong knowledge in handling cloud hosted DB Model and schema.
8. Strong knowledge in Normalization, Data Model (Logical, Physical).
9. Strong knowledge of PL/SQL is a must.
10. Should have basic knowledge ofUNIX environment.
11. Knowledge of ETL processes and tools will be an added advantage.
12. Strong analytical and problem-solving skills.
13. Ability to work independently and in a team environment.
14. Excellent communication skills to effectively interface with Client.

Job Description :

SQL Developer Support primary responsible for supporting and enhancing web application.

1. Responsible for resolving technical issues for consumers, partners, clients, or internal stakeholders by addressing issues assigned to them through the ticketing systems using process specifications following operating procedures.
2. Collaborate with our data analysts and other stakeholders to understand business requirements and work to troubleshoot/enhance database structures and queries.
3. Write and optimize complex SQL queries.
4. Manage SQL code in a source control system.
5. Contribute to continual improvement by suggesting improvements/Automation or new technologies.
6. Responsible for Debugging and implementing database performance monitoring and tuning.
7. Manage and resolve production incidents. Covers system outages, job failures, system defects, data defects and end user support.
8. Execute and manage day-to-day operations via ticketing tools and processes.
9. Ensure appropriate tool is updated in accordance with SLA specifications with case notes, status updates and case closure information.
10. Responsible to test the application features.
11. Lead/participate in SQL code reviews.
12. Provide technical support, including troubleshooting and resolving data-related issues.
13. Stay current with database and technologies and the direction of the general database industry.
14. Provide technical mentoring and coaching for junior and mid-level developers.

Location : Hyderabad, Telangana, India