Previous Job
Datawarehouse Architect with Crystal reports
Ref No.: 17-22905
Location: Jefferson City, Missouri
Role:- Datawarehouse Architect with Crystal reports 
Location:- Jefferson City, MO
Duration:- 12+ months
Job Description:-
• 10+ Years of experience on Database Architecting and Design, DWH migrations
• Strong knowledge on Data modeling, DWH concepts and reports modeling using Crystal Reports solution
• Strong knowledge on designing database for Web Application, good on performance tuning, SQL scripts
• Strong knowledge on Informatica, SQL scripts, ETL Scripts
• Involve in analysis, design and architectural discussions and provide solutions, design documentation and development
• Requirement Gathering, Meeting with Stakeholders ( Business , IT & Incumbent Vendors)
• Review of Business requirement documents and making sure that all requirements captured
• Lead in Technical Documentation (LLD & HLD Design Document)
• Test Approach and Strategy for Business Scenarios
• Identify any Risks and co-ordinate with customer Project Manager to mitigate the same
• create Project and rollout Plan for migration activities
  • Database: Oracle 11g, 12g
  • ETL: Informatica, SQL scripts, ETL Scripts
  • Hosting Platform: Windows Server
Reporting: SSRS/Power BI