ETL Developer - United States - 27091 - Maximus

General information

Job Posting Title

ETL Developer

Date

Tuesday, December 17, 2024

City

Remote

Country

United States

Working time

Full-time

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.

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

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

EEO Statement

Active military service members, their spouses, and veteran candidates often embody the core competencies Maximus deems essential, and bring a resiliency and dependability that greatly enhances our workforce. We recognize your unique skills and experiences, and want to provide you with a career path that allows you to continue making a difference for our country. We’re proud of our connections to organizations dedicated to serving veterans and their families. If you are transitioning from military to civilian life, have prior service, are a retired veteran or a member of the National Guard or Reserves, or a spouse of an active military service member, we have challenging and rewarding career opportunities available for you. A committed and diverse workforce is our most important resource. Maximus is an Affirmative Action/Equal Opportunity Employer. Maximus provides equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status or disabled status.

Pay Transparency

Maximus compensation is based on various factors including but not limited to job location, a candidate's education, training, experience, expected quality and quantity of work, required travel (if any), external market and internal value analysis including seniority and merit systems, as well as internal pay alignment. Annual salary is just one component of Maximus's total compensation package. Other rewards may include short- and long-term incentives as well as program-specific awards. Additionally, Maximus provides a variety of benefits to employees, including health insurance coverage, life and disability insurance, a retirement savings plan, paid holidays and paid time off. Compensation ranges may differ based on contract value but will be commensurate with job duties and relevant work experience. An applicant's salary history will not be used in determining compensation. Maximus will comply with regulatory minimum wage rates and exempt salary thresholds in all instances.