Job Description :
Informatica ETL Developer
Location : Marlborough, MA
Interview : Phone and F2F or Skype (Preferred Local)
Duration : 6+ Months
JOB DESCRIPTION :
· Will work primarily for Sales Data Warehouse, CRM, Aggregate Spend Hub Environments
· Good Experience with Documenting Technical Design Documents and Specifications
· Monitors project progress by tracking activity; resolving problems; recommending actions
· Maintains user confidence and protects operations by keeping information confidential
· Adheres to Sunovion Standards
· Thorough Knowledge of ETL (Informatica Power Center), Oracle PL/SQL, Data Warehousing/ETL Design
· Good to have DataModel at ERWIN, IDQ (Informatica Data Quality), Informatica MDM, Informatica On Cloud/Demand (IOD) Expertise
· Ability to write Test cases, Queries in SQL@Oracle and Test Summaries are a must
· Thorough understanding and debriefing ability in Data Warehousing environment is a must.
· Good Experience in interacting with End Users, Analysts, Technical Teams is needed.
· Quickly come up to speed and a self-learner
· Solid understanding of SDLC/Waterfall methodology
· Must be a Team Player
Skills
Informatica PowerCenter 9.1 or above
Oracle 11g / 12c programming
Unix Solaris / Linux Programming
Pharmaceutical Data Knowledge is a plus
Must be hands on all the above
Should be a Team Player
Experience with ERWIN, IDQ, Informatica MDM or Informatica on Cloud, Subversion is a plus
Having Knowledge in Pharmaceutical Sales/CRM data is a plus
Expertise with Aggregate Spend Hub System is a plus
Understanding of data is a plus