US-MA-Boston-Data Architect

Connexion Systems & Engineering, a Boston based IT and Engineering
Solutions Company immediately seeks individuals with the following
skills:

Job# 6876

Data Architect

6+ years of database development experience
4+ years of PLSQL development
Most recent experience should be on Oracle 10g
2+ year as data architect
Prior experience with real time data replication techniques like
Oracle Streams and CDC is a big plus

Extensive experience with database design and architecture, data
mappings, data modeling in a data warehouse/reporting environment

Extensive experience building ETL solutions based on Informatica and
Oracle databases in a batch
and real time environment

Understand client's P&L reporting requirements
Refine staging and reporting database data model to fill the reporting
gaps
Modify existing import stored proc to bring the additional tables/
columns from staging database to reporting database
Create Data Access Layer in plsql stored proc for new client reports
Work with ETL developer for real time (or near real time) data imports
from operational databases (Oracle and sqlserver).
Create new real time (or near real time) data imports from operational
databases to reporting database
Work with PM and QA team to ensure thorough functional and performance
testing of the new system

Informatica experience
Crystal reports
Oracle Streams

Duration: Open

Rate: 3-6 months
Location: Boston, MA
Contact Info:
Ken DiMaggio
ConneXion Systems & Engineering
490 Boston Post Road
Sudbury, MA 01776
978-579-0030
ken.dimaggio.RemoveThis@csetalent.com