TechnoGen
Senior ETL Developer
TechnoGen, Atlanta, Georgia, United States, 30383
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/usersLearn a homegrown batch processing environment (MDHHS Common Batch Framework) from State of Michigan documentation and on the job exposureLearn the operational protocols and best practices of the MDHHS Common Batch FrameworkReview existing batch jobs to understand their current function, including Linux shell scripts and Teradata utility scripts for BTEQ, TPT, Multiload, Fastload, and FastExportConvert existing batch jobs into the MDHHS Common Batch Framework, ensuring they follow the operational protocols and best practicesTest batch job conversions for accuracy, quality, and adherence to standardsBecome proficient with the State of Michigan Helix ticket system and the promotion process for productionLead other developers in the conversion of existing batch jobsMentor other developers in the creation of new batch processesFollow a cohesive approach for achieving conversion milestonesAnalyze and recommend process improvementsMust be able to work independentlyRequired:
5+ Years of Teradata Experience (V16/17) and Teradata Utilities5+ Years' Experience with SQL Assistant5+ Years' Experience performing Data Extracts, Data Transformations & Data Loads (ETL)5+ Years' Experience with Linux/Unix shell scripting5+ Years' Experience with Data Migration5+ Years' Experience with all phases of SDLC5+ Years' Experience working on projects employing Agile methodologyPreferred:
Bachelor's degree or equivalent technical study1+ Years' Experience with State Government/Public Health business areasExperience working with business partners to proactively identify value add solutionsExperience with Report Development
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/usersLearn a homegrown batch processing environment (MDHHS Common Batch Framework) from State of Michigan documentation and on the job exposureLearn the operational protocols and best practices of the MDHHS Common Batch FrameworkReview existing batch jobs to understand their current function, including Linux shell scripts and Teradata utility scripts for BTEQ, TPT, Multiload, Fastload, and FastExportConvert existing batch jobs into the MDHHS Common Batch Framework, ensuring they follow the operational protocols and best practicesTest batch job conversions for accuracy, quality, and adherence to standardsBecome proficient with the State of Michigan Helix ticket system and the promotion process for productionLead other developers in the conversion of existing batch jobsMentor other developers in the creation of new batch processesFollow a cohesive approach for achieving conversion milestonesAnalyze and recommend process improvementsMust be able to work independentlyRequired:
5+ Years of Teradata Experience (V16/17) and Teradata Utilities5+ Years' Experience with SQL Assistant5+ Years' Experience performing Data Extracts, Data Transformations & Data Loads (ETL)5+ Years' Experience with Linux/Unix shell scripting5+ Years' Experience with Data Migration5+ Years' Experience with all phases of SDLC5+ Years' Experience working on projects employing Agile methodologyPreferred:
Bachelor's degree or equivalent technical study1+ Years' Experience with State Government/Public Health business areasExperience working with business partners to proactively identify value add solutionsExperience with Report Development