Mgr, Software Devl (R1076405) in Kochi, India at IQVIA™

Date Posted: 10/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.

This requirement is for Senior Informatica Power Center ETL developer with database expertise with suppport experience
-Work with engineers from disparate source systems for data acquisition, transformation and data quality.
- Understand the structure and meaning of data coming in the source systems through data profiling and applying business content to the data.
- Define business rules and transformations for data coming from source systems into the data warehouse to match the business application of the data.
- Design and develop production level data loads into the data warehouse that are optimized for fast performance and minimal maintenance.
- Design dimensional data models that Work well with the other components of the BI stack, like the database and reporting tools.
- Identify data quality issues and their root causes. Implement fixes and Design data audits to capture the issues in the future.
- Implement indexing and partitioning strategies that maximize query performance based on how users access the data.
- Develop ETL routines for Extraction, transformation and Loading data into Target Databases
- Perform data analysis and normalization to resolve requirement conflicts and gaps between various data stores and business entities create entity relationship and multidimensional data models, reports and diagrams.
- Document and develop ETL routines related to Fact Tables, Dimension Tables, star/snow flake schema models, slowly changing dimensions, foreign key concepts & referential integrity.
- Interface with system architects, designers, and developers to ensure a thorough understanding of functions, technical, and performance requirements
- Review/analyze test case results to ensure functionality meets documented specifications
- Assist in the execution/analysis of integration, user acceptance, and performance testing

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: R1076405

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs