Data Pipeline/ETL (Informatica) Developer

Description & Requirements

At Maximus, we're proud to be celebrating our 50th year in business, with strong financial performance - including $1.4B in revenue this quarter and 15% growth in our Federal services group.

Becoming part of Maximus means joining a team that offers:



* A generous annual allowance for education or professional certification



* Free access to robust certification and training programs to help you grow your career



* Strong career path with support for internal mobility



* A collaborative, respectful work environment with supportive leadership



* Comprehensive benefits, including medical/dental/vision, generous paid time off, and more

We are seeking a Data Pipeline/ETL(Informatica) Developer to join our team supporting an Internal Revenue Service (IRS) client.

Position is 100% remote with preference close to Farmers Branch, TX or Lanham, MD.

Employment is contingent upon successful completion of the IRS-required Moderate Risk Background Investigation (MBI).

The MBI requires the selected candidate be a U.S.

Citizenship or Permanent Resident (Green card) status for at least 3 years.

The MBI certification process will take 4 to 5+ months, unless the candidate already holds an active MBI, which may shorten the timeline.

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.

This role will be responsible for the development of data pipeline (Informatica workflows) and ETL (Post processing) code.

The candidate will collaborate with IRS teams to design and develop ETL code to transform and process large amounts of data from disparate IRS data sources.

Job-Essential Duties and Responsibilities:



* Design and develop Informatica PowerCenter mappings including transformations, mappings, mapplets, workflows, workflow monitoring


* Design, code, unit test ETL packages, triggers, and stored procedures, views, SQL transactions


* Migrate data from On-prem managed service environments to cloud platforms AWS Redshift/Databricks



* Ingest data from disparate data sources and apply business rules using SQL/Python to create fact, dimension and summary tables for ingestion by BI tools


* Create, test and refine SQL queries to support data profiling and data management


* Understand and comply with development standards and SDLC to ensure consistency across the project.


* Perform troubleshooting, debugging, and performance tuning


* Support installation, upgrades, and testing of Informatica components.


* Perform data profiling, data standardization, data transformations, data loads.


* Perform detailed data profiling and end-to-end data management analysis to understand data issu...