Rate: Depending on experience

Work location: Remote

Required:

• 5+ Years of Teradata Experience (V16/17) and Teradata Utilities

• 5+ Years' Experience with SQL Assistant

• 5+ Years' Experience performing Data Extracts, Data Transformations & Data Loads (ETL)

• 5+ Years' Experience with Linux/Unix shell scripting

• 5+ Years' Experience with Data Migration

• 5+ Years' Experience with all phases of SDLC

• 5+ Years' Experience working on projects employing Agile methodology

Preferred:

• Bachelor's degree or equivalent technical study

• 1+ Years' Experience with State Government/Public Health business areas

• Experience working with business partners to proactively identify value add solutions

• Experience with Report Development

• Experience with Analytical Tools

Job Duties:

• Manage batch job migration and conversion activities for the State of Michigan Health Services Data Warehouse and participating systems/users

• Learn a homegrown batch processing environment (MDHHS Common Batch Framework) from State of Michigan documentation and on the job exposure

• Learn the operational protocols and best practices of the MDHHS Common Batch Framework

• Review existing batch jobs to understand their current function, including Linux shell scripts and Teradata utility scripts for BTEQ, TPT, Multiload, Fastload, and FastExport

• Convert existing batch jobs into the MDHHS Common Batch Framework, ensuring they follow the operational protocols and best practices

• Test batch job conversions for accuracy, quality, and adherence to standards

• Become proficient with the State of Michigan Helix ticket system and the promotion process for production

• Lead other developers in the conversion of existing batch jobs

• Mentor other developers in the creation of new batch processes

• Follow a cohesive approach for achieving conversion milestones

• Analyze and recommend process improvements

• Must be able to work independently