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.