Overview
Remote
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
No Travel Required
Able to Provide Sponsorship
Skills
ETL
Fastload
Linux
Teradata
Unix shell scripting
bteq
multiload
teradata utilities
Data Warehouse
shell scripting
Job Details
Clover Consulting has a great client in need of a Teradata ETL Developer. This is a multi-year contract position and is also 100% REMOTE and will be for the entirety of the contract.
Data Warehouse Senior ETL Developer
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:
- 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