Pedigo Staffing Services ยท 1 month ago
ETL Programmer Consultant for Texas Motor Vehicles, Austin, Texas
Pedigo Staffing Services is seeking an ETL Programmer/Consultant for the Texas Department of Motor Vehicles. The role involves designing, developing, implementing, and maintaining ETL and data pipeline solutions for data ingestion, transformation, and loading into data warehouses.
Human Resources
Responsibilities
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
Qualification
Required
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
Preferred
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