Data Warehouse ArchitectSupport for development and maintenance of Oracle Data Warehouse to support OBIEE and BIP reporting tools for ABCThe applicant is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in Data Warehouse and BI development and implementations. The applicant will be involved in gathering of business requirements and creating technical designs.It involves designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems. The data warehouse developer's role in an organization includes providing support to the organization's business requirements in the application and consumption of information from the Data Warehouse.The applicant will be part of the team to review, analyze, modify, and create ETLs, testing, debugging, integration and implementation processes.
Task will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.This position involves the delivering of huge data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how.Data Warehouse Developer Role:Experienced SQL and PL/SQL developer on Oracle database platform.Deep understanding of data warehouse and star schemaDevelop ETL scripts and write PL/SQL code from data model, dataflow diagram and technical design specificationsAbility to work on wide variety of development needs from simple queries to complex queries and multidimensional analysisAbility to follow best coding standards practicesExpert in performance tuning of ETL/SQL codeAnalyze and provide resolutions for production data issuesFamiliar with Unix shell scripting and job automationBuild and implement BI dashboards, analysis using OBIEEBuild reports using BI publisherlocal considered first