EXPLORE

Careers at ThermoFisher Scientific

Apply Now >>    
Job ID :
46655BR
Location :
US - California - Carlsbad
:
Job Description

About Thermo Fisher Scientific
Thermo Fisher Scientific, Inc. is the world leader in serving science, with revenues of $18 billion and more than 55,000 employees globally. Our mission is to enable our customers to make the world healthier, cleaner and safer. We help our customers accelerate life sciences research, solve complex analytical challenges, improve patient diagnostics and increase laboratory productivity. Through our premier brands - Thermo Scientific, Applied Biosystems, Invitrogen, Fisher Scientific and Unity Lab Services - we offer an unmatched combination of innovative technologies, purchasing convenience and comprehensive support.

Skills:
  • Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager , Workflow Monitor,
  • Strong database Analysis skill using SQL/PLSQL (Oracle)
  • Understand reusability, parameterization, workflow design, ETL
  • Extensive experience in scheduling and managing Informatica Jobs
  • Demonstrated skill and ability in the development of data warehouse applications (Oracle & SQL Server)
  • Data warehouse development experience using SSIS/SQL best practices including the development of reconciliation and validation frameworks
  • Experience in SQL Server 2005/2008/2012 database design and development best practices.
  • Expert in transformation logic, conditional split, data conversion, multicast, lookup, merge joins.
  • Building and extracting data for SSAS cubes (Tabular and Multi-dimensional).
  • Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members.
  • Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
  • Must have good communication skills
  • Must be able to look beyond the detailed requirements to understand what the business is trying to do and don’t get lost in the details
  • Must be able to develop and maintain documentation to our standards / provide feedback on standards where they can be improved
Experience
  • 5 – 7 years of experience at Enterprise-level ETL development & architecture in Informatica PC 9.x, 10.x
  • 3-4 Years of SSIS development experience and programming knowledge and skills with in developing ETL applications
  • 2 - 3 years of SQL/PLSQL development with Oracle 10g, 11g
  • 2 – 3 Data Profiling / Data Analysis and Unix shell scripting.
Nice to have
Knowledge of Data Model on SAP, Siebel, JDE, BAAN as well as extensive experience on Data Extract from these systems is a Plus.
The successful candidate will be part of our Enterprise Data warehouse team to work with cross functional teams to define and design data integration from various enterprise systems, build and implement solutions, and support development of large-scale data integration using Informatica.


Thermo Fisher Scientific is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.
Apply Now >>    
Join our Talent Community

If you're ready to make a difference in the world, you can do it here.

Join
Refer a friend

Already work here? Help us write our next chapter

Refer Now

SHARE

5 Reasons to Work at Thermo Fisher Scientific
View
Search Jobs by Map
Search