The company is looking to improve its business intelligence capabilities by analyzing raw data and developing ETL/ELT processes.
Requirements
- SQL knowledge
- Techno-functional skills
- Oracle technologies: ETL / ELT, Data Analysis
- Working knowledge of database/data warehouse concepts including views, tables, and indexing
- General understanding of Star and Snowflake schema structures
- General understanding of the OBIEE/OAC environment
- Experience in ODI (Oracle Data Integrator)
Responsibilities
- Analyzes raw data and develops ETL/ELT processes by designing, testing, and troubleshooting processes in accordance with requirements
- Analyzes and translates business needs into long-term solution data models
- Supports database/data warehousing
- Designs custom fact tables, aggregate tables, and dimensions
- Designs, develops and customizes RPD with multiple data sources
- Creates technical documentation
- Extends data models to house additional data structures to meet requirements
Other
- 4-year degree preferred
- Minimum of 5+ years of experience
- Minimum of 3+ years experience in applications like Oracle Data Integrator, Oracle Data Warehouse
- Ability to competently perform all the essential duties of the position, with or without reasonable accommodation
- Demonstrated commitment to effective customer service delivery, integrity, and the ability to work productively as a member of a team or work group