ETL Developer (Remote) Job at Maximus, Bangor, ME

OHRzR3U0cmczSHJlUUhaUFc4SnplSDBSMGc9PQ==
  • Maximus
  • Bangor, ME

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

Job Tags

Remote job, Minimum wage, Holiday work, Full time, Contract work, Temporary work, Work experience placement,

Similar Jobs

WhiteCap Search

People Operations Associate - Investment Management Firm (Newport Beach) Job at WhiteCap Search

 ...People Operations Associate - Investment Management Firm Join to apply for the People Operations Associate - Investment Management Firm role at WhiteCap Search People Operations Associate - Investment Management Firm Join to apply for the People Operations... 

PDS Services, LLC

Apartment Leasing Agent Job at PDS Services, LLC

Apartment Leasing AgentLocation: Ann ArborPay rate: $20 per hour plus commissionJob descriptionOur Leasing Consultants handle all leasing, marketing, sales, customer service, resident retention and administrative responsibilities.Some Responsibilities include... 

Baker Roofing

Commercial Roofing Project Manager Job at Baker Roofing

 ...Commercial Roofing Project Manager Baker Roofing Company is seeking an experienced Commercial Roofing Project Manager to join our winning team. You would manage high-profile commercial projects within your region. Baker Roofing invests in our employees by empowering... 

Manpower

General Labor Job at Manpower

 ...Our client, a dynamic and innovative organization, is seeking a General Labor to join their team. As a General Labor, you will be part of the operations supporting the maintenance and logistics team. The ideal candidate will have strong attention to detail, a proactive... 

TINOS MAINTENANCE

Industrial Machine Spray Painter Job at TINOS MAINTENANCE

 ...Job Description Job Description Industrial Machine Spray Painter. We paint at our customer's locations. Must have valid driver's license and reliable transportation. Must have experience with pressure pots and cup guns, must have experience mixing to spray two part...