Description
TITLE: ETL Data Architect
LOCATION: Austin, TX
Candidates MUST BE LOCAL TO AUSTIN. A FACE TO FACE interview is REQUIRED. No third party candidates considered for this position.
REQUIREMENTS:
- 8 years of overall experience in:
- Translating client requirements
- Application data architecture and supporting implementation
- Data migration project planning
- Source to target mapping
- Experience with capacity planning and data storage
- Experience with database systems engineering
- 3 years of experience working with ETL/ELT for data migration
- 3 years of involvement in design of bi-directional data movement (front bridge/back bridge)
- Integration of data using a publish/subscribe model
- ETL development using Informatica and/or Microsoft SSIS
- Subject area Datamodelling for OLTP, normalized models, domains
RESPONSIBILITIES:
- Coordinate with the analysts and application architects to define the structure for how data will be captured and used in the application and shared across other applications.
- Coordinate data migration planning activities including any Datamodelling required to understand the mapping between source and target systems.
- Design a data flow between systems that shall support the front-bridge and back-bridge data transport requirements
- Determine data migration, application data, and data feed requirements
- Design ETL and develop data flows and models to support data feeds, geospatial