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.