Job Description :
Position: Data Warehouse Architect – ETL Developer
Location; Rosslyn,VA
Duration: Long Term
Position Description
? Functions as the primary technical architect for data warehousing projects to solve business intelligence challenges ? Possesses deep technical expertise in database design, ETL (OWB/ODI), reporting, and analytics ? Previous consulting experience utilizing an agile delivery methodology Section II: Position Requirements
? Strong conceptual, analytical, and decision-making skills ? Knowledge and Experience of dimensional modeling ? Strong knowledge of Oracle PL/SQL ? Working knowledge of SQL server ? Proficiency in creating PL/SQL packages ? Full SDLC and Data Modeling experience ? Ability to create both logical and physical data models ? Ability to tune databases for maximum performance ? Experience in Data Preparation: Data Profiling, Data Cleansing, and Data Auditing ? Ability to work with Business Analysts to create functional specifications and data ? Manages QA functions ? Develops unit, system, and integration test, plans and manages execution ? Ability to write technical and end-user system documentation ? Excellent written and oral communication skills ? Experience transforming logical business requirements into appropriate schemas and models ? Ability to analyze and evaluate moderate to highly complex information systems by being able to interpret such devices as Entity Relation Diagrams, data dictionaries, record layouts, and logic flow diagrams. ? Knowledge of Data Factory ? Oracle performance tuning experience ? Familiarity with highly available database solutions / architectures in Oracle 12c and SQL Server ? Knowledge of Power BI and SAS analytics platforms ? DBA Administration Section III: Experience
? Three years ETL experience using Oracle Warehouse Builder, or ODI ? Three years of experience with ETL processing ? Three years of experience utilizing data warehousing methodologies and processes