Genpact

With a startup spirit and 115,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create meaningful transformation that moves us forward in our pursuit of a world that works better for people. Now, we’re calling upon the thinkers and doers, those with a natural curiosity and a hunger to keep learning, keep growing., People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual firepower. 

Welcome to the relentless pursuit of better.

Inviting applications for the role of Consultant - ETL/DWH/BI Developer

Responsibilities:

• Advanced knowledge in MS SQL Server 2017 or above. Good knowledge in MSBI (SSIS/SSRS/DWH Concepts) 2016 or above Experience delivering reporting, database, data integration and cube solutions. 
• Should have good knowledge on working with different data source system ( SQL, Oracle, Postgres SQL ) 
• Should understand the requirements and analyse, provide quality solutions catering the needs independently. 
• Should closely interact with onshore team for requirements and development activities. 
• Write T-SQL queries and have experience in DTS, SSIS, SSRS 
• Create Stored Procedure, Functions, and Triggers etc. Process data migration to SQL Server from various sources 
• Create and maintain database documentation. 
• Good interpersonal and communication skills and should have worked in a model which requires interaction with onshore IT & Business teams. 
• Optimization of exiting database & business logic source code. Design, test and deploy database schemas. 
• Database performance tuning including identifying bottlenecks with suitable workarounds.
• Performance benchmark conformance report for newly developed and altered functions. Good problem-solving abilities. 
• Need to support L3 activities and hands on experience on Migration activities. 
• Familiarity with .net technologies (prior development experience will be an advantage) Database analysis. 

Qualifications we seek in you! 

Minimum Qualifications

• B.E. / MCA / B. Tech /MCA / B. Tech Graduate 
• Relevant experience in the ETL, DWH,BI development preferably in IT Infrastructure 

Preferred Qualifications/ Skills

• Extensive work experience in SQL Server 2010 through 2016, Oracle, SSIS, SSRS, Power BI 
• Advanced level knowledge in DWH concepts 
• Hands on experience in TSQL and PLSQL 
• Good to have experience in reporting tool –Power BI 

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 diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com . Follow us on Twitter, Facebook, LinkedIn, and YouTube.

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.