Data Warehouse Analyst with SAP Business Objects ;Face2Face
SWAMI K S R
Hi Partners,
Data Warehouse Analyst With SAP- SAP Business Objects
Face2Face required
Work Location:
4822 Madison Yards Way
Madison
Wisconsin
USA
53707-7982
Description:
NOTE TO VENDORS: *** PLEASE DO NOT SUBMIT CANDIDATES THAT DON'T MEET THE REQUIRED SKILLS LISTED & DESCRIBED BELOW ***
DOT is looking for a candidate that can help provide BI ETL & Reporting needs for our DTIM Division.
The candidate will be a strong technical leader working on Data Integration, Data Warehouse, and BI Report Development projects, gathering & documenting requirements, performing analysis, designing solutions to meet business objectives, developing specifications, developing ETL mappings using Informatica PowerCenter, developing universes and reports using SAP Business Objects, testing, and implementing solutions. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Seek continuous improvement in performance & tuning and ensure security of data. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Work with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Work with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 7 - 9 years experience or equivalent education.
Ideal candidate will have demonstrated experience designing BI solutions, with development experience using Informatica PowerCenter and SAP Business Objects.
DW & BI Knowledge and Skills Required for the position:
1. Data warehouse/data marts using Kimball & Inmon methodologies
2. Informatica PowerCenter V10.1
3. SAP Business Objects universe and report design/development - V 4.1
4. Crystal Reports
5. Infoburst
6. Oracle, DB2 and SQL Server
7. Complex SQL development
8. Dimensional Data Modeling - Star Schemas
9. Slowly Changing Dimensions
10. Requirements gathering and documentation
11. Test plan development and testing execution
12. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support
13. Excellent written and oral communications
14. Independent worker
Knowledge and experience using Informatica Data Validation Option (DVO) and Informatica Test Data Management (Data Masking) is a plus
Required Must Have DW & BI Knowledge areas:
Informatica PowerCenter - ETL (8+ years experience):
• Data warehouse design
• Data warehouse development
SAP Business Objects (8+ years experience):
• SAP Business Objects Universe design and development
• SAP Business Objects report design and development
Database Knowledge (8+ years experience):
• DB2
• ORACLE
• SQL Server
• Complex SQL statements
General Competencies
Able to work independently8 years
Analytical/problem solving skills 8 years
Bachelor's Degree in Computer Science or Software Engineering Yes
Data Analysis 8 years
Excellent Communication Skills 8 years
Excellent oral and written communication skills 8 years
Information Technology - Commonly Used Software
MS Office products 8 years
Outlook (MS) 8 years
Information Technology - Databases
Data Warehouse - Experience in data warehouse design and development 8 years
Data Warehouse - Experience in requirements gathering for data warehouse 8 years
DB2 and 8 years
Informatica 8 years
Knowledge of Oracle PL/SQL 8 years
MS SQL Server 8 years
Oracle 8 years
Information Technology - Design
Develop design specifications 8 years
Knowledge of Kimball data warehouse design principals 8 years
Information Technology - Languages/Tools
Business Objects 8 years
Information Technology - Requirements
Requirements analysis 8 years
Requirements gathering 8 years
Information Technology - Testing
Conduct unit and system tests 8 years
Develop Test Plans, Test Cases, and Test Procedures 8 years
Identify defects 8 years
Interpret test results 8 years
---------------------------
Regards & Thanks,
Swamy,
Prospect Infosys Inc.
IT Takes Talent – Experience the Difference
EMAIL: swamy_...@prospectinfosys.com