Software Developer – ETL + Informatica PowerCenter

Remote | 17905SD3 | Closes 11/19

Loc:
Remote – Telework

Texas Department of Motor Vehicles requires the services of 1 Software Developer 3, hereafter referred to as Candidate(s), who meets the general qualifications of Software Developer 3, Applications/Software Development and the specifications outlined in this document for the Texas Department of Motor Vehicles. 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.

• 8 Required Experience in ETL development using industry-standard ETL tools.
• 8 Required Experience in ETL development using Informatica Power Center.
• 8 Required Experience with DB2 and SQL.
• 8 Required Experience writing complex SQL queries.
• 8 Required Experience in dimensional modeling.
• 6 Required Experience with JIRA and JAMA.
• 6 Required Experience working with DB2 in Linux operating systems.
• 6 Required Working in a team environment and ability to communicate and assist with training other team members.
• 4 Required Experience in ETL development using AWS or Azure Cloud Environment.
• 8 Preferred Experience working with large datasets.
• 4 Preferred Experience in ETL development using Azure Data Factory.
• 4 Preferred Experience in ETL development using Microsoft Fabric.
• 4 Preferred Experience in ETL development using Informatica Cloud ETL.
• 4 Preferred Experience ETL development with TxDMV RTS data.
• 2 Preferred Experience Converting mappings from Informatica Power Center to Informatica Cloud ETL.