Lead consultant - SQL/SSIS/SSRS

Genpact

5 - 10 years

Noida

Posted: 28/06/2025

Job Description

Responsibilities

Designing and implementing robust applications.
Good knowledge in implementing SCD1,2 and 3 on SSIS
Good to have knowledge on SSRS
Debugging applications to ensure low-latency and high-availability.
Writing optimized custom SQL queries
Integrate user-facing elements into applications
Test and debug programs for SSIS and SQL developer related
Improve functionality of existing systems
Implement security and data protection solutions
Must be capable of writing SQL queries for validating dashboard outputs
Must be able to translate visual requirements into detailed technical specifications
Good understanding and exposure on any Git, Bamboo, Confluence and Jira.
Good in Dataframes and SQL ANSI using pandas.
Team player, collaborative approach and excellent communication skills
Good to have knowledge on AWS cloud and Snowflake.

Minimum Qualifications

BE/B Tech/ MCA
Excellent written and verbal communication skills
Candidate should have experience
Understand user requirements and specifications for SSIS packages, SSRS reports and SQL Server Agent jobs to develop new and modify existing packages/reports/jobs
Should have in-depth knowledge on SSIS including data pull from multiple sources & databases, SFTP, SCD, & package optimization
Should to read and write complex queries, ability to create database objects (tables, views, stored procedures, user-defined functions)
Should have experience in creating matrix & tabular reports using SSRS including reports having multiple tabs. Should have understanding of creating Connecting Strings, DataSources, DataSets
Basics of Designing databases, create, and implement database systems based on the end user's requirements.
Good understanding and exposure on any Git, Bamboo, Confluence and Jira.
Good in Dataframes and SQL ANSI using pandas.
Team player, collaborative approach and excellent communication skills
Good to have knowledge on AWS cloud and Snowflake.

Preferred Qualifications

Creative ways of solving problems efficiently and logically
Good understanding of datawarehouse concepts.
Good to have knowledge on Python pandas
Good to have knowledge on Snowflake DWH, BI Tools (Visualization).
Knowledge on Database performance tunning.
Learning attitude & Flexible with project and timings
Good communication and presentation skills
Why join Genpact?
Lead AI-first transformation Build and scale AI solutions that redefine industries
Make an impact Drive change for global enterprises and solve business challenges that matter
Accelerate your careerGain hands-on experience, world-class training, mentorship, and AI certifications to advance your skills
Grow with the best Learn from top engineers, data scientists, and AI experts in a dynamic, fast-moving workplace
Committed to ethical AI Work in an environment where governance, transparency, and security are at the core of everything we build
Thrive in a values-driven culture Our courage, curiosity, and incisiveness - built on a foundation of integrity and inclusion - allow your ideas to fuel progress
Come join the 140,000+ coders, tech shapers, and growth makers at Genpact and take your career in the only direction that matters: Up.
Lets build tomorrow together.

About Company

Genpact is a global professional services firm that offers a wide range of digital transformation services and solutions. With a presence in over 30 countries, Genpact leverages its deep domain expertise in operations and analytics to help businesses transform their operations, improve efficiency, and enhance customer experience. The company combines digital technology, data science, and operational excellence to deliver business outcomes across various industries, including banking, insurance, manufacturing, and healthcare. Founded in 1997 as a subsidiary of GE, Genpact has grown into an independent, NYSE-listed company with a diverse workforce of over 90,000 employees globally.