Hi,
I have an urgent requirement mentioned below. If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number.
Position: BI Analytics/Data Modeler (Oracle) Consultant
Location: Fountain Valley, CA
Duration: 6+ Months
Required Skills:
Oracle Database
Job Description:
BI Analytics/Data Molder with Oracle
Overview:
This is for operations and maintenance. Their team at KIA recently implemented a major microstrategy and massive MDM project. They need help with day to day maintenance gathering requirements.
As a member of the EDW team, the BI/Data Warehouse Consultant will perform requirements gathering and system analysis, data analysis, data mapping, logical data modeling, functional design, and data quality improvements. This individual will be working closely with end users, ETL developers, Data Modelers / Architects, Report Developers and Functional teams.
Qualified Must Haves:
- Excellent Data Modeling Skills
- Expert background in Oracle (Index, SQL, Hints, Understand All objects)
- Expert level PL/SQL and SQL
- Write ETL Instructions (Build Mapping)
- Experience with Erwin or other similar tool
- 50% Data Modeling and 50% BSA Skills
- Requirements Gathering skills from the business
- Understanding of Data Marts and Data Warehousing
- Kimball Methodology Experience
- Automotive Background is a plus
- Excellent Communication Skills (Very Important)
- Agile Methodology (Scrum)
- Excellent PL/SQL Oracle consultant
- Excellent Data Modelling Skills
- Excellent Communication Skills
Must Haves Managers Description
- 5-7 years of proven hands on experience in the role of a BSA in a Data Warehouse / BI environment
- Extensive data modeling experience using ERwin r7 or higher
- Extensive experience creating, maintaining, and fine-tuning Oracle database objects using Toad for Oracle 11 or higher
- Strong understanding of data warehousing methodology, data mapping and modeling, ETL, databases, and Business Intelligence and their processes
- Strong knowledge of SQL, Oracle database, stored procedures and ad-hoc query development
- Strong ability to work with star schema designs and extensive knowledge in building and designing logical /physical data modelling
- Strong data modeling skills be detail and process oriented
- Strong business analysis experience to capture data and reporting requirements and translating to technical specs for the enterprise data warehouse
- Extensive experience in data analysis and develop data mapping and functional solution design documents for ETL developers
- Performs source data model / data analysis, and target EDW data model / data analysis
- Capture business rules and builds physical design document to meet user requirements
- Strong expertise to understand and interpret logical design document and data model diagrams to understand requirements to build physical design document
- Ability to effectively communicate the functional design to developers and confirm the same with the business teams
- Ability to effectively document overall business processes and data/information flow. Suggest and implement process improvement and data collection opportunities. Functional testing of reports and ETL data auditing
- Ability to work under pressure, adapt to changing environment, and multi-task
- Must be an initiative taker and possess ability to work independently with minimal supervision
- Possess a collaborative working style and the ability to work independently in a team environment
- Excellent communication and presentation skills
Plus:
- Automotive industry experience a plus
Regards,
Praveen Tiwari
Senior Technical Recruiter
Sage Group
W:+ 732-767-0010 x 113 |Direct: 732-851-1637 | F: 732-749-8969 | Email: ptiwari@sagetl.com
Gtalk/yahoo/Skype: praveentj101
This message contains information that may be privileged or confidential and is the property of Sage Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. Sage Group does not accept any liability for virus infected mails.
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment