ETL Developer (Remote)

Maximus; Houston (TX); Remote; USD 98,000 - 108,000; Full time

Job summary

A leading company is seeking an ETL Developer to work remotely and support federal clients. The ideal candidate will design and implement ETL solutions using Actian DataConnect and SQL. Responsibilities include developing ETL processes, conducting testing, and providing leadership in software development. Applicants must have a Bachelor's degree and significant experience in ETL tools and SQL Server.

Benefits

Health insurance coverage

Life and disability insurance

Retirement savings plan

Paid holidays

Paid time off

Qualifications

• 5+ years of ETL Tool experience required.
• 5+ years of SQL Server (T-SQL) experience, including complex procedures.
• Experience with XML, JSON functions, and invoking web services.

Responsibilities

• Develop end-to-end ETL solutions and improve performance.
• Support testing, remediation, and monitor data transmissions.
• Conduct feasibility studies and root cause analysis for production issues.

Skills

ETL Tool

SQL Server

XML

JSON

SOAP

REST

Windows batch scripting

PowerShell scripting

Education

Bachelor's degree in relevant field

Tools

Actian DataConnect

C&R Software’s Debt Manager

Job description

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 provide guidance, coaching, and training to other employees within job area.

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 relevant field of study and 5+ years of relevant professional experience required, or equivalent combination of education and experience.

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

Maximus is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, age, national origin, disability, veteran status, genetic information and other legally protected characteristics.

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.

Minimum Salary

$98,000.00

Maximum Salary

$108,000.00

Compensation:
$98,000-$108,000 per year

Remote: Yes