Data Warehouse Architect

Data Warehouse Architect 3

Interview Type:
In Person Only

Rate: 120K on W2

Local candidates strongly preferred.

Support for development and maintenance of Oracle Data Warehouse to support OBIEE and BIP reporting tools.

The applicant is responsible for the successful delivery of business intelligence information to the entire organization and has experience in Data Warehouse and BI development and implementations. The applicant will gather business requirements and create technical designs.

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. The task will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

This position involves delivering huge data integration projects and therefore requires leveraging best practices expertise and experience at implementation, as well as effective technology know-how.

• Experienced SQL and PL/SQL developer on Oracle database platform.
• Deep understanding of data warehouse and star schema.
• Develop ETL scripts and write PL/SQL code from data model, dataflow diagram and technical design specifications.
• Ability to work on a wide variety of development needs from simple queries to complex queries and multidimensional analysis.
• Ability to follow best coding standards practices.
• Expertise in performance tuning of ETL/SQL code.
• Analyze and provide resolutions for production data issues.
• Familiar with Unix shell scripting and job automation.
• Build and implement BI dashboards, analysis using OBIEE.

• 5 Years of PL/SQL and SQL development with Oracle.
• 5 Years of understanding of star schema data warehouse design.
• 5 Years of ETL script development and execution, including automation in Linux/Oracle environment.
• 5 Years of performance tuning and reconciliation of SQL query execution.
• 5 Years of familiarity with Unix Shell scripting.
• 5 Years of experience with OBIEE, BIP and data repository in Oracle OBIEE reporting platform.
• 5 Years of experience developing report specifications from business requirements and executing builds to design.
• Experience with a mature data modeling tool such as ERWIN (preferred).