What are the responsibilities and job description for the Senior ETL Developer position at TechnoGen?
Job Title : Senior ETL Developer (Data Warehouse)
Job Type : Contract
Location : Remote
This candidate will be part of a 45 person team made up of Project Managers, Teradata and Web Developers, Data Modelers, DBAs, Business Analysts and Report Analysts. Must be able to communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector.
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
Required :
Preferred :
