Lead Consultant, SQL Developer

Genpact (NYSE : G) is a 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. Powered by our purpose – the relentless pursuit of a world that works better for people – we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.

Inviting applications for the role of (Lead Consultant), (SQL Developer)!

In this role, Must be fluent in the manipulation of data, ETL concepts, and query optimization.

Responsibilities

Designing database tables and structures.

Creating views, functions and stored procedures.

Writing optimized SQL queries for integration with other applications.

Creating database triggers for use in automation.

Maintaining data quality and overseeing database security.

Perform regular and timely health check for system and process alike Monitor and escalate

Can be able to handle client calls and initiate outage call when required

Excel VBA or knows enough excel beyond basics

Qualifications we seek in you!

Minimum Qualifications / Skills

Experience with B.Tech / B.E / MCA

Excellent written and verbal communication skills

Preferred Qualifications / Skills

Expert is SQL with knowledge of RDBMS

Strong Analytical skill.

SQL performance tuning.

SQL design skills.

Hands on experience in writing complex SQL queries and creating DB objects like Stored Procedures, Triggers, Functions, views and materialized views etc.

Developing Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL / SQL