ETL Programmer Consultant for Texas Motor Vehicles, Austin, Texas at Pedigo Staffing Services

Working Title: ETL Programmer/ConsultantAgency: Texas Department of Motor VehiclesSolicitation Reference Number: 17905SD3Location: 4000 Jackson Ave Austin TX 78731Telework Policy: The working position is Telework.Duration: On-going no ending dateVisa: Must be US Citizen Green Card EAD. No H1BRequirements/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 PedigoCEO / Senior Staffing Consultant830.433.4604210.401.4501Pedigo Staffing Services Cooperative Contracts:DIR ITSAC (Department of Information) IT Staffing #DIR-CPO-5738TIPS (Texas Interlocal Purchasing System) Staffing #230703TIPS (Texas Interlocal Purchasing System) Technology Services #240101BuyBoard Temporary Staffing #774-25State of Louisiana IT Staffing #CW8873State of Oklahoma IT Staffing #SW1025State of Oklahoma Staffing #0132Required Experience:Contract Key Skills Machine Shop,Drilling,CSSD,ADMA,Drafting,HR Employment Type : Full Time Experience: years Vacancy: 1