Job ID: TX-TDI24343 (99590302)
Data Architect with data mapping, ERD, ERwin/TOAD, Oracle, Tableau and Microsoft Power BI experience
Location: Austin, TX (TDI)
Duration: 5+ months
Interview: In Person Only
Years Skills/Experience
4 Required Creating data dictionaries, containing application and database metadata
4 Required Creating database views
4 Required Creating documentation to map application data entry to database fields
4 Required Creating Entity Relationship Diagrams (ERDs) using ERwin or TOAD software
4 Required Working in Oracle 12c databases, via table-level administration and writing custom Oracle SQL queries
2 Preferred Working in Tableau Desktop and Tableau Server
2 Preferred Creating data sources using Oracle Views
2 Preferred Working in Microsoft Power BI
A database architect is being solicited by TDI to create comprehensive documentation mapping application to database for agency applications utilizing Oracle 12c databases. Primary focus will be on creating entity relationship diagrams (ERDs), data dictionaries, and intuitive documentation using screen shots and other presentation methods to describe how an application maps to the database, at the column-level. Additionally, database views may be created for use in Tableau or Microsoft Power BI to assist with the agency’ reporting needs. This work will extend to at least one application, Independent Dispute Resolution, but may also include other applications as contract time and funding allow.