This site uses cookies. To find out more, see our Cookies Policy

Software Engineer 1 (R1058809) in Bangalore, India at IQVIA™

Date Posted: 4/12/2019

Job Snapshot

Job Description

Join us on our exciting journey! IQVIA™ is The Human Data Science Company™, focused on using data and science to help healthcare clients find better solutions for their patients. Formed through the merger of IMS Health and Quintiles, IQVIA offers a broad range of solutions that harness advances in healthcare information, technology, analytics and human ingenuity to drive healthcare forward.

This requirement is for Informatica Power Center ETL developer
-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

We know that meaningful results require not only the right approach but also the right people. Regardless of your role, we invite you to reimagine healthcare with us. You will have the opportunity to play an important part in helping our clients drive healthcare forward and ultimately improve human health outcomes. Whatever your career goals, we are here to ensure you get there! We invite you to join IQVIA™



Job ID: R1058809