ETL Programmer Consultant for Texas Motor Vehicles, Austin, Texas

Working Title : ETL Programmer / Consultant

Agency : Texas Department of Motor Vehicles

Solicitation Reference Number : 17905SD3

Location : 4000 Jackson Ave, Austin, TX 78731

Telework Policy : The working position is Telework.

Duration : On-going, no ending date

Visa : Must be US Citizen, Green Card, EAD. No H1B

Requirements / Preferences :

8 years, Required - Experience in ETL development using industry-standard ETL tools.

8 years, Required - Experience in ETL development using Informatica PowerCenter.

8 years, Required - Experience with DB2 and SQL.

8 years, Required - Experience writing complex SQL queries.

8 years, Required - Experience in dimensional modeling.

6 years, Required - Experience with JIRA and JAMA.

6 years, Required - Experience working with DB2 in Linux operating systems.

6 years, Required - Working in a team environment and ability to communicate and assist with training other team members.

4 years, Required - Experience in ETL development using AWS or Azure Cloud Environment.

8 years, Preferred - Experience working with large datasets.

4 years, Preferred - Experience in ETL development using Azure Data Factory.

4 years, Preferred - Experience in ETL development using Microsoft Fabric.

4 years, Preferred - Experience in ETL development using Informatica Cloud ETL.

4 years, Preferred - Experience ETL development with TxDMV RTS data.

2 years, Preferred - Experience Converting mappings from Informatica PowerCenter to Informatica Cloud ETL.

The Texas Department of Motor Vehicles (TxDMV) requires the services of one advanced (senior-level) software developer in the Information Technology Services Division (ITSD).

• Work involves designing, developing, implementing, and maintaining robust and scalable ETL and data pipeline solutions to ingest, transform, and load data from various sources into target data warehouse and reporting structures.

Debbie Pedigo

CEO / Senior Staffing Consultant

DebbieP@PedigoStaffing.com

830.433.4604

210.401.4501

Pedigo Staffing Services

PedigoStaffing.com

Awarded Cooperative Contracts :

DIR ITSAC (Department of Information), IT Staffing #DIR-CPO-5738

TIPS (Texas Interlocal Purchasing System), Staffing #230703

TIPS (Texas Interlocal Purchasing System), Technology Services #240101

BuyBoard, Temporary Staffing #774-25

State of Louisiana, IT Staffing #4400029273CW8873

State of Oklahoma, IT Staffing #SW1025

State of Oklahoma, Staffing #0132