Send me more jobs like this

Sorry, This job is expired.

Consultant - MSBI, P&C Insurance

Keywords / Skills : Consultant , MSBI, P&C Insurance, Stored procedure, OLTP , Data warehousing, Design concepts, Database SQL development , Performance Tuning , SSIS, SSAS, SSRS

4 - 8 years
Posted: 2019-08-26

Industry
ITES/BPO
IT/Computers - Software
Function
IT
Role
Software Engineer/ Programmer
ERP, CRM - Functional Consultant
Posted On
26th Aug 2019
Job Ref code
ITO027054
Job Description
Job Description :

With a startup spirit and 80,000+ curious and courageous minds, we have the expertise to go deep with the world\u2019s biggest brands\u2014and we have fun doing it. Now, we\u2019re calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us.

Inviting applications for the role of Consultant -MSBI, P&C Insurance

In this role, you would be responsible to contribute to the full development lifecycle of reporting, database, data integration, cube and data warehousing solutions. Working with Microsoft SQL Server and the full Microsoft BI Stack (SSIS, SSAS, SSRS), you will be working on large scale BI projects.

Responsibilities
Experience in Analysis, Design and Implementation of BI Solutions with Microsoft SQL server 2008R2/2012/2014/2016
Expertise in writing T-SQL Queries, stored procedure, functions in MS SQL Server.
Hands on experience on SSIS, SSAS, SSRS
Data Loading Experience in SQL Server using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, CSV to MS SQL Server by using BCP utility, DTS and SSIS services.
Experience in Performance Tuning and Query Optimization
Experience in writing expressions in SSRS and Expert in fine-tuning the reports

Qualifications
Minimum qualifications
BCA, B.Tech, MCA, M.Sc. in computer science

Preferred qualifications
SQL Server SSRS \u2013 Good experience in working with Report Manager, subscriptions, building linked reports with multi-valued parameters to stored procedures, deploying reports with required formatting.
Having good hands-on experience in SQL Server, Stored procedure, trigger, functions
Proficient in OLTP and Data warehousing Design concepts.
Database SQL development work experience.

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 YouTube (https://www.youtube.com/user/GenpactLtd) .



About Company

Genpact India


Walkin for you