Database Warehouse Developer

Category: Other
Company: BioWare
Location: Austin (United States)
Start Date: immediately

Job Description

 

BioWare is a member of the incredible family of EA studios, which employs over 8,000 people worldwide. BioWare has created some of the world's best-selling titles including the award-winning Baldur's Gate, the Neverwinter Nights series, and Star Wars: Knights of the Old Republic. Original BioWare-created IPs include the critically acclaimed Mass Effect, the epic fantasy RPG Dragon Age, Jade Empire, and Sonic Chronicles: The Dark Brotherhood. BioWare Austin is hard at work on the massively multiplayer online game, Star Wars: The Old Republic.

BioWare Austin is looking for an experienced Oracle Data Warehouse Developer to design, develop, and maintain complex ETL (extract, transform, load) and data integration processes. This job requires previous experience working with high data volumes and VLDBs.

The successful candidate will be a key contributor to the design and development of all technologies related to data warehouse database systems in a collaborative environment populated by domain experts.

Duties and Responsibilities

• Design, develop, tune, deploy, and support ETL processes to extract data from various sources, transform, and load into the data warehouse using a variety of techniques and technologies such as Oracle GoldenGate, shell scripting, SQL*Loader, and custom PL/SQL

• Design, develop, and support automation of load processes

• Review, enhance, and optimize performance  of existing processes

• Author and assist with applicable documention of ETL processes including design documents, source/target mappings, transformation specifications, restartability, etc.

• Collaborate with Platform and Analytics team to understand business context and suggest appropriate methods to acquire data from various performance sensitive source systems

• Assist with review and offer suggestions for enhancements to existing, and development of future, data models from an ETL impact / assessment perspective

• Perform data analysis, validation/QA, troubleshoot and resolve data/integration issues, effectively articulate the business impact of data issues to peers and stakeholders

• Assist to define and implement logging/auditing and reporting of ETL processes metrics

• Assist with definition and implementation of ETL design and development standards, guidelines, and best practices

• Perform and/or support periodic system administration tasks including evaluating/reviewing, installing, and configuring new software releases, upgrades, patches

• Work with global / distributed teams as needed

• Ability to support and help foster a ‘data driven’ culture, and communicate the importance and impact of quality and timely data across the organization

• Understand and comply with established software development life cycle (SDLC) methodology

• Assist with all other data warehouse activities as needed/directed

 

Experience and Qualifications

  • Bachelor’s degree in Computer Science, Computer/Software Engineering, Information Systems, or related field
  • Minimum of 3-4 years data warehouse development experience in an Oracle production environment
  • Knowledge of and direct experience with data warehousing methodologies, principles, and modeling techniques
  • Expert level PL/SQL development and optimization techniques
  • Expert level shell scripting
  • Expert level SQL Tuning
  • Medium knowledge working with Oracle partitioning and parallelism
  • Experience working in an Oracle RAC environment
  • Deep understanding of RDBMS concepts, and expertise with relational and dimensional database (3NF and Fact-Dimensional) programming and design
  • Ability to visualize and architect automated end-to-end data integration flows
  • Strong analytical and problem solving skills
  • Demonstrated ability to effectively collaborate with various business representatives/users/stakeholders and IT peers including DBAs, engineers, developers, analysts, technology and project managers
  • Ability to effectively and efficiently manage time and prioritize tasks in a fast-paced, high-volume, deadline-driven environment
  • Excellent written and verbal communication skills
  • Oracle Database Programming:
  • SQL*Loader, PL/SQL and PL/SQL optimization techniques
  • UNIX:
  • Shell Scripting

 

Pluses:

• GoldenGate experience

• Exadata experience

• Knowledge of and experience with BI and reporting/analytic tools, preferably MicroStrategy and Tableau

• Previous Oracle DBA Experience

• Previous project team experience utilizing SCRUM or Agile methodology, and building data warehouse/data marts in a dynamic work environment that is complex and high-volume in nature

• Familiarity with MMO and RPG game designs and back-end data/services, and a passion for playing games

 

Created on the 08-07-2013
Logo BioWare
Personal Job Informations
This is an "Off-Site-Posting" and therefore no requirements got specified. So it is sadly not possible to display how matching you are for this job.
Action :
Apply for Job
You will be redirected to
the Company-Homepage