Systems Analyst (BI/ETL)

  • Company:
    Thermo Fisher Scientific
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    1 week ago
  • Category:
    Biotechnology/Pharmaceutical/Medicine | Manufacturing/Industrial

Skill: bi , data warehousing , cognos , business intelligence , sql , plsql , unix scripting , etl , pl / sql , oracle , erp / crm , informatica power center , integration services , dwh , oracle sql , ssis , informatica; Exp: 5-7 years; Systems Analyst (BI/ETL) Job ID 80062BR Location India – Bangalore Job Description Job Title Systems Analyst (BI/ETL) Job Location Bangalore, India About Company Thermo Fisher Scientific Inc. is the world leader in serving science, with revenues of more than $20 billion and approximately 70,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, deliver medicines to market 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 services. About Team Business Intelligence Enterprise Data Warehouse Team is responsible for providing Enterprise wide Data for Historical, Trend & Business analysis. We help our company executives; business managers and other operational workers make better and more informed business decisions. Business Intelligence team uses tools, technologies, applications and practices used to collect, integrate, analyze, and present Thermofishers raw data in order to create insightful and actionable business information. Role & Responsibilities Purpose – Candidate should be strong in Data Warehousing Concepts, strong experience in ETL Tools like Informatica Power Center, Prior experience in handling Production issues. Responsibilities Strong knowledge on Data warehouse loading , Production Monitoring of ETL Data loads using Informatica. Strong experience in handling Production issues related to Data load, ETL Mappings, sessions, workflows etc. Ability to analyze logs and troubleshoot symptoms associated with root cause at application level is a must requirement Should be good in analyzing & troubleshooting production failures of ETL sessions. Ability to participate in and be available for on-call support and other key operational activities. Should have strong knowledge on Data warehousing concepts, ETL concepts, Oracle(SQL, PLSQL). Working knowledge of handling Informatica loads with ERP/CRM/DW systems like SAP, JD Edwards, Salesforce Experience in Informatica on AWS Cloud will be an added advantage. Should have good knowledge on Unix scripting to automate loads Experience on scheduling tools like Control-M, Tivoli is a plus. Ability to provide administration support through on-call rotations Good technical aptitude combined with the ability to learn new tools and technologies Excellent team player with attention to technical details Candidate Requirement Education & Experience levels Bachelor Degree in Computer Science or equivalent Nature of experience 5-7 Years of Experience in working on Data warehousing ETL Tools like Informatica Power Center Knowledge Required Strong knowledge on Data warehouse loading , Production Monitoring of ETL Data loads using Informatica. Strong experience in handling Production issues related to Data load, ETL Mappings, sessions, workflows etc. Should be good in analyzing & troubleshooting production failures of ETL sessions. Ability to participate in and be available for on-call support and other key operational activities. Should have strong knowledge on Data warehousing concepts, ETL concepts, Oracle(SQL, PLSQL). Working knowledge of handling Informatica loads with ERP/CRM/DW systems like SAP, JD Edwards, Salesforce Experience in Informatica on AWS Cloud will be an added advantage. Should have good knowledge on Unix scripting to automate loads Experience on scheduling tools like Control-M, Tivoli is a plus. Ability to provide administration support through on-call rotations Skills DWH ETL Tools, Informatica Power Center, Oracle SQL, Pl/SQL, IBM Cognos, SQL Server Integration Services(SSIS) At Thermo Fisher Scientific, each one of our 70,000 extraordinary minds has a unique story to tell. Apply today http//jobs.thermofisher.com . 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. Link for schema

Data Warehousing

Degree: 

Experience: 5-7

Function: IT Software : Software Products & Services