Founded 33 years ago, Allied Consultants is an Austin-based firm and premier provider of technical and business staffing solutions for the State of Texas. We are currently seeking an experienced ETL Developer to be a key resource on a technical services team for our client, Texas Workforce Commission (TWC).

**Location: Remote.**

Responsibilities

The Worker(s) will provide the following services:

Perform duties such as 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 enhance data warehouse functionality.

Performs other duties as assigned to maintain operations.

Qualifications

Minimum Requirements:

• 8 years of hands on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle using different data sources
• 8 years of proven ability to work successfully with technical and non technical groups and manage multiple responsibilities
• 8 years of communication, analytical and interpersonal skills at all levels
• 8 years of strong technical writing skills

Preferred:

• 6 years of ERWin or other equivalent data modeling tools
• 6 years or more than one type of RDBMS (DB2, SQLServer, Oracle)
• 4 years experience in Public Sector delivery
• Certified Data Management Professional (CDMP)
• 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
• Hands on experience with data modeling preferably in a data warehouse environment
• Experience with Informatica product suite in the Informatica cloud
• Texas Workforce Commission Experience

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 ETL Developer 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 check

Texas GovLink is an equal opportunities employer.