Lead Systems Integration Engineer
Medidata: Conquering Diseases Together
Medidata is leading the digital transformation of life sciences, creating hope for millions of patients. Medidata helps generate the evidence and insights to help pharmaceutical, biotech, medical device and diagnostics companies, and academic researchers accelerate value, minimize risk, and optimize outcomes. More than one million registered users across 1,400 customers and partners access the world's most-used platform for clinical development, commercial, and real-world data. Medidata, a Dassault Systèmes company, is headquartered in New York City and has offices around the world to meet the needs of its customers. Discover more at www.medidata.com.
As a key member of Corporate Technology, you will work in a culture of innovation and partner with experienced technology professionals with deep technical experience who are committed to delivering efficient, technology-based solutions.
The Information Systems Integration Engineer will play an integral role in the analysis of data from a variety of sources, ETL design and development of all Medidata corporate systems integrations using Informatica Intelligent Cloud Services(IICS).
The engineer will be working hands-on with the latest cloud systems like Salesforce, Workday, Zendesk, Informatica Cloud,AWS (S3,EC2,RedShift,RDS) ,Tableau BI and tens of other Cloud business applications.
Hands on Experience in Informatica Intelligent Cloud Services(IICS) OR Informatica PowerCenter
Designs, develops and automates ETL processes from a variety of complex sources
Strong experience in ETL development with Files, RDBMS,Cloud Integration with (Salesforce and various Web Service Endpoints)
Should be very good at SQL and past experience in relational database systems (MS Sql Server, Oracle, MySql etc.) is a must
Experience in AWS services (EC2,S3 & RedShift) is nice to have
Create/maintain/improve system integration documentation and processes
Ability to tolerate stress and be adaptable, flexible, persistent, and handle multiple projects and re-prioritizations
Ability to work both independently and within a team environment
Ability to work in a very fast paced environment
Your Education & Experience:
Bachelor's degree in Computer Science or a degree in some STEM program. However, if one does not have a STEM undergrad then at least 5 years of overall demonstrable and quantifiable work experience in the subjects (ETL, Data Warehousing, Business Intelligence and Corporate SaaS based Business Systems mentioned)
5+ years of experience as a Data Integration developer (Informatica PowerCenter or Informatica Cloud)
5+ years of experience on database technologies
Medidata Solutions, Inc. is an Equal Opportunity Employer. Medidata Solutions provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability status, protected veteran status, or any other characteristic protected by the law. Medidata Solutions complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.