Genpact off-campus drive

 

Role                             :-  Business Analyst - SQL Developer

Salary                         :-   5 - 6 LPA (expected)

Experience                 :-  Freshers / Experienced

Qualification              :-  B.Tech, B.Sc, M.Tech, MSc, MCA

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).

Skills Required : 

•   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

Application Link : Click here to apply