Database Architect
Alleare Consulting - Richardson, TX

This job posting is no longer available on Alleare Consulting. Find similar jobs: Database Architect jobs - Alleare Consulting jobs

Database Architect: Contract-to-Hire

Located in Richardson or Houston

Summary:
Client in Texas is looking for a Sr. Enterprise Data Architect focused on Oracle PL/SQL and Informatica. This role will be responsible for data warehouse of clients, customers and prospects. These databases may hold up to 1 billion records of transactions. This individual works as part of a development team designing software solutions supporting client's relationship marketing activities. Software solutions include creating and supporting data warehouses and data marts of client's customers and prospects; creating extract, transform and load (ETL) data movement processes; creating automated reports; and creating data extraction processes supporting client's marketing campaigns.

Duties / Responsibilities:
Working under general supervision or independently, this individual performs the following functions:

: Interacts frequently with Account Managers, Project Managers, and clients.

: Must be thoroughly skilled with data modeling, data warehouse and data mart design.

: Designs ETL processes using Informatica PowerCenter and/or Epiphany and/or Alterian

: Assists developers with difficult Oracle PL/SQL code needed for queries, triggers, and stored procedures

: Designs data warehouses and data marts hosted in Oracle.

: Designs data marts to support Business Intelligence reporting using Business Objects and campaigning using Neolane, Unica, Epiphany or other CRM tools.

: Designs ETL processes using Informatica PowerCenter

: Assists developers with difficult Oracle PL/SQL code needed for queries, triggers, and stored procedures

: May design automated reports using Business Objects and other technologies

: Conducts reviews of developed code

: Mentors developers on established guidelines and best practices

: Diagnoses and corrects system problems

: Creates design and other system documentation in accordance with established processes and policies

Required Skills:
: Bachelor's Degree in Computer Science, Management Information Systems, Mathematics, Engineering, or equivalent

: Eight years data architecture experience (Oracle PL/SQL, Informatica)

: Interest in learning the concepts and practices, acquiring the skills, and developing the expertise needed to succeed in this position

: Excellent Communication and Interpersonal skills

: Excellent skills with dimensional data modeling to design data warehouses and data marts

: Must have demonstrated expertise in core competencies of data modeling, ETL (preferably using Informatica), and SQL (preferably using Oracle PL/SQL).

: Experience with Neolane, Unica, Epiphany or other CRM tools is a plus.