What are the responsibilities and job description for the Database Architect position at Allied Consultants, Inc.?
Overview
Texas GovLink, Inc. is an Austin-based firm which has been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Database Architect to be a key resource on a technical services team.
Texas GovLink offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (TGL shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background checkTexas GovLink is an equal opportunities employer.
Responsibilities
The Worker(s) will provide the following services:
Perform Database Architect work as a member of the Data Governance team, overseeing one or more projects concurrently. Design, develop, and test Extraction Transformation Load (ETL) processes for the data warehouse. Develop and document ETL processes to extract data from existing systems into the data warehouse. Document the “as-is” schemas currently in use at client. Perform other analysis and documentation tasks as required to facilitate and support client’s Enterprise Data Warehouse. Define and document the technical architecture. Perform other analysis and documentation tasks as required. Perform other duties as assigned to maintain operations.
**Location of work: Remote**
Qualifications
Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements(skills/experience) will not be considered for this opportunity.
Years
Skills/Experience
8
Design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes
8
Hands-on experience with data warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle
8
Analyzing and generating technical requirements and design
8
Hands on experience with data modeling preferably in a data warehouse environment
8
Experience with Informatica product suite in the Informatica cloud
8
Creating source to target mapping database documentation
8
Assist with migrating data from legacy database to new target database
Preferred:
Years
Skills/Experience
5
More than one type of RDBMS (DB2, SQL Server, Oracle)
5
erwin or other equivalent data modeling tools
3
Experience in Amazon Web Services
Texas Workforce Commission experience
