Hi,
Hope you doing great,
Please share me consultant with PHARMA experience.
No OPT - EAD
Role : Senior SSIS ETL Consultant with Pharma experience
Location : New Jersey, Princeton
Minimum Experience / Relevance :
· Over all 8+ IT Experience
· 6-7 years of ETL Architecture experience using ETL and Business Intelligence techniques including 5+ years using SSIS product suite development tools and environments.
Skills (Mandatory) :
· Good Knowledge / Experience in SSIS
· Good expertise in Designing, Developing SSIS Packages and Workflows
· Debugging / Trouble shooting of SSIS Jobs
· Good in MS SQL Server Database
· Good Knowledge in Migration (between versions and other tools)
· Strong Data Warehousing Concepts & Architecture
· Good Knowledge on Data warehousing Design approach
· Experience in Big Data and AWS is a Great Plus
· Good Knowledge in ETL Testing Methodologies
· Experience in Pharma Domain and it’s data set is a great plus
· Good Data Modelling in Commercial Pharma
· Strong Experience in life sciences/healthcare and working experience with various Healthcare Sources IMS data, Medpro, Plantrack, IMS Xponent, Fingertip, Formulary,DDD, Call Plan, Speciality exclusion primarily in the areas on Physician Targeting , Segment profiling analytics, Source of business etc is a Great PLUS
· Very good Communication and experienced in Development / Support projects
· Demonstrated experience leading MSBI product suite, ETL and Business Intelligence products.
· Demonstrated understandings of database architecture design patterns, and complete application development lifecycle.
· Demonstrated experience ETL and Business Intelligence products.
· Customer handling and good communications skills
Skills (Optional) : OLAP Reporting Tools is a plus
Roles & Responsibilities :
· Define data relationship model to support data migration from source systems to target data warehousing environments.
· ETL solutions should follow database normalization standards and best
practices.
· Design and develop Informatica mapping and transformation rules to support new data warehouse architecture model
· Understand Change control Management and drive changes by performing Impact Analysis
· Working with dependent teams such as DBA, Admin etc for tasks that require other team’s assistance
· Identify, design, and write technical specifications and champion re-usable
software and frameworks and common objects using ETL and Business Intelligence technology.
· Define database architecture development principles, standards, and best
practices.
· Preparing test/quality strategies, plans for meeting the CTQs of the project
· Research current trends and emerging technologies and provide input on how they may positively or negatively impact the enterprise.
· Solutioning and Customer manager skills are necessary
Khatib Rahman | VBeyond Corporation