Occupation:Datawarehouse Designer |
Location:San Jose, CA |
Education Level:Master |
Will Relocate:YES |
Description
SUMMARY: Highly accomplished and motivated IT professional with over 18 years of contribution in individual and leadership roles involving Enterprise Software and Consulting Services, catering to a variety of different areas across many industry verticals, including Business Intelligence/Data Warehousing, Data Integration, Data Governance, ETL and Master Data Management (MDM). * 15+ years of experience in end-to-end Life Cycle Design and Development of Data Warehousing (Dimensional Modelling, Database design, ETL/ELT and Business Intelligence (Report, KPI, Scorecards, Dashboards) * Master Data Management, Customer Data and Product Data Hub groups to help analyze and then help resolve issues using Informatica and Oracle * With expertise as both a technical and functional lead of Oracle Master Data Management (MDM) (including Customer Master Data Management (CDM), Product Data Management (PDM), Product Information Management (PIM), Customer Data Quality (CDQ) and Product Data Quality (PDQ). * SME on building Enterprise Data Warehouse or Data Warehouse appliances from Scratch using both Kimball and Inmon Approach. Having knowledge in Data Lakes Architecture and Design experience. * Data Architecture (Conceptual, Logical, Physical) experience involves building Normal form & Star Schema {Dimension (Slowly Changing, Snowflake, Conformed Dimensions), Fact, Metrics, Use cases and KPI} using Erwin, TOAD, Visio and PowerDesigner. * ETL Architecture experience involves defining different layers (landing/staging, recovery point layers, ) Complete ETL schedule and flow to fit SLA, IDQ, Power Center, mapping design, Error handling and Workflow Design on Informatica. Knowledge in ELT Processing. Hands on mainly on Informatica, guided team on SSIS and DataStage. Worked on Databases like Oracle, SQL Server and DB2 * Strong expertise as solution architect designing and delivering solution deployment architecture, Infrastructure sizing, performance and scalability options, benchmarking & tuning (application, database and hardware) for test, development and production environment * Proven track record in Project Management in Traditional Methodologies and Agile Methodologies * Worked with high performance teams developing and implementing state-of-art data warehouse applications. Ability to understand (or get the customer to articulate) the business needs in terms of business value * Managed and mentored 20+ team technically to deliver solutions both Company and Vendors onsite/off-shore