Datawarehouse Developer

High chance of interview for the candidate having prior state client experience. Qualifications: Bachelor's degree: MBA or relevant technical degree preferred. A strong background in technology, analysis and critically evaluating information gathered from multiple sources. Experience decomposing high-level information into details, distinguishing user requests from the underlying true needs, and developing solution ideas from requirements. Strong experience writing business requirements documentation (BRDs) and functional requirements documentation (FRDs). Proven experience successfully working in a team setting and ability to reconcile conflicts. Minimum seven 7-10 years of experience in related professional business/project analyst capacity. Excellent oral and written communication skills. Experience in the housing and financial sector is preferred and a major plus, especially around accounting, bonds, mortgages, underwriting, loans origination and servicing; in addition to, experience around grants, tax credits, property/buildings asset management and compliance reporting. Excellent experience with MS Office 2013/2016 and above as well as design tools and flowcharting tools, e.g. Visio. Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data warehouse applications. Experience in developing Data Warehouse/Data Marts using, as examples, OBIEE, OBI APPS, Cognos, Business Objects, SPSS, SSIS, SSRS, Informatica Power Center, OWB and ODI . Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts . Experience in defining metadata standards for the enterprise data warehouse. Experience in design and development of: ETL processes using Dimensional Modeling for ROLAP and MOLAP. ETL technical architecture. BI load dependency plan, job scheduling and cycle management. Experience in developing end-to-end Data warehouse ETL routines. Experience in using SQL in advanced analytical functions . Experience in writing complex PL/SQL packages stored Procedures, functions, cursors, triggers, views, and materialized views.

Created: 2024-10-19