Description & Requirements
Maximus is currently seeking a ETL Developer to work remote and join our team supporting one of our Federal clients.
Essential Duties and Responsibilities:
- Provide design and implementation expertise to a cross-functional software development team.
- Design and develop software applications from business requirements in collaboration with other team members.
- Support testing and remediate defects.
- May mentor entry and mid-level developers.
ETL Development:
-Develop end-to-end ETL solutions using Actian DataConnect.
-Participate in requirements gathering and design sessions.
-Create applications for processing financial and other transactions using ETL, SQL, and Web Services.
-Design self-cleanup ETL processes and enhance existing ETL processes for better performance.
-Develop reusable transformations, SQL queries, stored procedures, and functions.
-Conduct feasibility studies and proof of concepts.
-Implement data validation, data management, and file management processes using various scripting languages.
Support and Upgrades:
-Support environment and product/tool upgrades, including proof of concept and beta testing.
-Re-engineer business processes for version control and change management.
-Perform unit testing and validate ETLs during SQL Server upgrades.
-Identify and address product gaps, engaging with vendor architects for solutions.
Production and Quality Assurance:
-Monitor daily data transmission and ETL loading activities.
-Troubleshoot and perform root cause analysis for production issues.
-Conduct defect root cause analysis and participate in test case reviews.
- Bachelor's degree in related field.
- 5-7 years of related experience required.
- Equivalent combination of education and experience considered in lieu of degree.
-Minimum 5 years experience ETL Tool required.
-Minimum 5 years of SQL Server (T-SQL) experience, must experience writing very complex T-SQL procedures and queries.
-Experience with reading and creating XML using an ETL tool.
-Experience with creating Json functions.
-Experience with invoking SOAP and REST calls using an ETL tool.
-Experience with ETL tools to read and create various data files (Excel, Flat file, XML etc.).
-Experience with Windows batch scripting.
-Experience with Windows PowerShell scripting.
-Experience with C&R Software’s Debt Manager application.
Preferred Skills:
-Experience with Actian Data Connect ETL.
-Experience with Perl scripts.
-Experience with C&R Software’s Debt Manager application.
Additional Requirements as per contract/client:
-Must be eligible to Obtain Government Clearance.
-Must be a U.S. citizen.
-Must currently reside in the U.S.
-Must be able to pass a criminal background check.
-Must not be delinquent or in default on any federal student loans.
-Employment and continued employment are contingent upon obtaining and maintaining a favorable clearance.
-Final suitability determination is the sole discretion of the Department of Education.
-Obtaining and Maintaining a PIV-I card is a requirement of this position. PIV-I cards must be picked up in person. If applicable, new and existing employees may need to travel via car, train, or plane to a designated location to pick up their new or replacement PIV-I card. Any travel expenses will be paid for by Maximus.