ETL Developer

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.

Job-Specific Essential Duties and Responsibilities:

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.

Minimum Requirements

- Bachelor's degree in related field.
- 5-7 years of related experience required.
- Equivalent combination of education and experience considered in lieu of degree.

Job-Specific Minimum Requirements:

-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 and Qualifications:

-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...