Position: Data Modeler/ Analyst
Location: Carlsbad, CA
Project Overview: Corporate Data Mart Reporting
Duration: 5 months
Job Description: Thermo Fisher Scientific is seeking a Data Modeler/ Analyst located at Carlsbad, CA to work with the BI team on variety of new development and/or enhancement projects to build the enterprise level data warehouse system, which is backed by Oracle Exadata database (11g or later), Informatica ETL tools set and Cognos Reporting.
Responsibilities
· Participate in requirements definition, analysis and the design of logical and physical data models
· Leading data discovery discussions with Business in JAD sessions and map the business requirements to logical and physical modeling solutions.
· Conduct data model reviews with project team members
· Capture technical metadata through data modeling tools
· Code standard Informatica ETL routines
· Develop standard Cognos Reports
· Collaborate with ETL teams to create data landing and staging structures as well as source to target mapping documents
· Ensure data warehouse database designs efficiently support BI and end user requirements
· Collaborate with application and services teams to design databases and interfaces which fully meet business and technical requirements
· Maintain expertise and proficiency in the various application areas
· Maintain current knowledge of industry trends and standards
Required Skills
· Strong data analysis and data profiling skills
· Strong Conceptual, Logical and Physical data modeling for VLDB Data warehouse
· Hands on experience with modeling tool such as ERWIN or another industry standard tool
· Exposure to ETL tool Informatica or other industry leading tools
· Exposure to Cognos Reporting tool or other industry leading tools
· Fluent in both normalized and dimensional model disciplines and techniques
· Minimum of 3 years' experience in Oracle Database (11g or above).
· Bachelor's degree in software engineering, computer science or information systems (or equivalent experience)
· Effective oral and written communication skills
· Ability to learn and maintain knowledge of multiple application areas
· Self-motivated, responsible, conscientious, and detail oriented
· Ability to follow and inform priorities and timelines
· Ability to work independently and in conjunction with a team
· Understanding of industry best practices pertaining to Quality Assurance concepts and procedures
Thanks & Regards,
Ayushi Thapliyal
Associate Technical Recruiter - TAG
D: 302-351-4231 | F: +1 (302)-298-0102
E: ayushi@mwidm.com
MWIDM Inc.
PA Office: 1445 City Line Avenue, Suite 10B, Wynnewood, PA 19096
Corporate: www.mwidm.com
You received this message because you are subscribed to the Google Groups " c2c jobs usa" group.
To unsubscribe from this group and stop receiving emails from it, send an email to c2cjobsusa+unsubscribe@googlegroups.com.
To post to this group, send email to c2cjobsusa@googlegroups.com.
Visit this group at https://groups.google.com/group/c2cjobsusa.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment