Data Pipeline/ETL (Informatica) Developer

Job description

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 issues, and to identify potential options to resolve issues.
* Support phases of the project lifecycle including requirements gathering, analysis, design, development, testing, deployment, support, and documentation
* Analyze, document and define data management processes, both batch and real-time.
* Evaluate data management and data governance practices to provide options and recommendations.
* Create clear deliverable materials for a range of recipients including technical teams, business teams, project leads and executives.
Job-specific minimum requirements:
* Bachelor's Degree in Information Technology or related field from an accredited college or university required; an additional four (4) years of related work experience can substitute for a degree
* At least five (3-5) years of relevant experience required
* Oracle and GreenPlum experience
* Proven Experience with SQL (Postgres, Redshift, MySQL), Python
* Strong experience with ETL development and working with diverse data sources
* Working knowledge of S3
* Advanced experience with Informatica Power Exchange, Control-M
* Experience with data modeling concepts
* Hands-on experience with Unix and shell scripts
* Experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes
* Good verbal and written communication skills
* Ability to interface with all levels of management
* Ability to perform complex tasks with minimal supervision and guidance
* Excellent time management, scheduling and organizational skills
* Ability to work well independently or in a team setting
* Candidates must be a US Citizen or a Legal Permanent Resident (Green Card status) for 3 years and be Federal Tax compliant.
#techjobs #veteranspage #C0reJobs
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.
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.
Accommodations
Maximus provides reasonable accommodations to individuals requiring assistance during any phase of the employment process due to a disability, medical condition, or physical or mental impairment.
If you require assistance at any stage of the employment process-including accessing job postings, completing assessments, or participating in interviews,-please contact People Operations at applicantaccommodations@maximus.com.
Minimum Salary
$
135,000.00
Maximum Salary
$
155,000.00
*

Required Skill Profession

Computer Occupations