Software Devl Analyst 2 (R1055766) in Bangalore, India at IQVIA™

Date Posted: 6/7/2019

Job Snapshot

Job Description

IQVIA™ is the leading human data science company focused on helping healthcare clients find unparalleled insights and better solutions for patients. Formed through the merger of IMS Health and Quintiles, IQVIA offers a broad range of solutions that harness the power of healthcare data, domain expertise, transformative technology, and advanced analytics to drive healthcare forward.

Development and support of PLICS system - core skills required: SQL Server (Stored Procedures, functions, indexes..etc.), SSIS(Sql server Integration Services),SSAS(Sql server Analysis Services), Qlik Sense
General Skills
SQL Server (Stored Procedures, functions, indexes etc), SSIS, SSAS, SSRS Qlik Sense, Power BI, Oracle
Requirements
• Strong experience with writing SQL 
• Should have some experience with Performance Tuning.
• Should be able to write complex SQL Query’s (CTE’s ,self joins).
• Should be well versed with SQL Procedures, functions (scalar and table values), indexes, temp tables
• Should be able to debug complex stored procedures.
• Should have working knowledge of Qlik Sense.
• Familiarity with SSIS 
• Should be aware of star and snow flaked (Data warehousing Concepts) schemas
• Expert with Data-modelling
• Must be familiar with TFS or SVN

Principal Accountabilities:

• Maintain a deep understanding of IMS BI tier toolsets and components

• Design ETL Processes for Data warehouse implementations

• Plans, conducts and coordinates the application of database designs, cube designs and implementation processes to existing and future BI Offerings. 

• Partner with the business units to develop effective solutions that solve business challenges


Responsibilities Include:

• 5 to 8 years of experience in MS BI with minimum 4+ years of experience in SSIS, T-SQL (SQL SERVER 2012),

• Expertise in writing SQL Queries, T/SQL, Stored Procedures, Functions, Triggers, Dynamic SQL and able to understand the existing business functionalities.

• Should have some experience with Performance Tuning.

• Should be able to debug complex stored procedures.

• Experience in analyzing source system, data flows, data profiling, data  analysis and ETL design

• Good troubleshooting, optimization and debugging skills required.

• Hands-on technical skills with a can-do attitude and ability to work in  a dynamic, fast paced environment

• Should have working knowledge of Qlik Sense.

• Excellent teamwork, communication, and documentation skills.

• Experience in working with both Agile/RAD methodologies and equivalent Waterfall methodologies.

• Must be familiar with TFS or SVN

• Good troubleshooting, optimization and debugging skills required.

• Good interpersonal skills with good experience in onsite & offshore delivery model

• Good knowledge of any one of modern reporting solution like – QlikView, QlikSense, Tableau, Power BI.

Join Us

Making a positive impact on human health takes insight, curiosity, and intellectual courage. It takes brave minds, pushing the boundaries to transform healthcare. Regardless of your role, you will have the opportunity to play an important part in helping our clients drive healthcare forward and ultimately improve outcomes for patients.

Forge a career with greater purpose, make an impact, and never stop learning.



Job ID: R1055766

CHECK OUT OUR SIMILAR JOBS

  1. Business Analyst Jobs
  2. Systems Analyst Jobs