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.
We are inviting applications for the role of AM, SQL Developer
Responsibilities
Writing T-SQL Queries using joins and Sub queries in MS SQL Server.
T-SQL development skills to write complex queries involving multiple tables, Joins.
Experience in Extracting, Transforming and Loading (ETL) data from MS ACCESS Database to MS SQL Server.
Creating & Modifying of tables, fields, constraints in MS SQL Server
Creating / modifying stored procedures in MS SQL Server.
Scheduling / modifying Jobs to automate in MS SQL Server.
Knowledge on creating Views / Triggers / Functions
Good / Basic knowledge on handling MS Access Database.
Knowledge of SQL Server Analysis Services (SSAS), Integration Services (SSIS) and Reporting Service (SSRS).
Qualifications we seek in you!
Minimum qualifications
B.Tech/MBA/MSc/MCA
Design and Develop QlikView Dashboards.
Knowledge on designing Data model (Star / Snowflake Schema).
KPI designing as per Business Requirements.
Preferred qualifications
Data fetching from QVD’s & creation of QVD’s.
Good knowledge on handling variables in QlikView.
Basic knowledge on Section Access