Lead consultant - SQL/SSIS/SSRS

Ready to build the future with AI
At Genpact we dont just keep up with technologywe set the pace. AI and digital innovation are redefining industries and were leading the charge. Genpacts AI Gigafactory our industry-first accelerator is an example of how were scaling advanced technology solutions to help global enterprises work smarter grow faster and transform at scale. From large-scale models to agentic AI our breakthrough solutions tackle companies most complex challenges.
If you thrive in a fast-moving innovation-driven environment love building and deploying cutting-edge AI solutions and want to push the boundaries of whats possible this is your moment.
Genpact (NYSE: G) is an advanced technology services and solutions company that delivers lasting value for leading enterprises globally. Through our deep business knowledge operational excellence and cutting-edge solutions we help companies across industries get ahead and stay ahead. Powered by curiosity courage and innovation our teams implement data technology and AI to create tomorrow today. Get to know us at and on LinkedIn X YouTube and Facebook.
Inviting applications for the role of Lead consultant - SQL/SSIS/SSRS!
Responsibilities
Designing and implementing robust applications.
Good knowledge in implementing SCD12 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.

Qualifications we seek in you!
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 users 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 140000 coders tech shapers and growth makers at Genpact and take your career in the only direction that matters: Up.
Lets build tomorrow together.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race color religion or belief sex age national origin citizenship status marital status military/veteran status genetic information sexual orientation gender identity physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values respect and integrity customer focus and innovation.
Furthermore please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit paying to apply or purchasing equipment or training.