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.