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