Informatica ETL Architect - Maximus Services, LLC

We are seeking an Informatica ETL Architect to join our team supporting an Internal Revenue Service (IRS) client.

The Informatica ETL Architect will be responsible for the development of ETL (Extract, Transform and Load) code. The candidate will collaborate with IRS teams to design and develop ETL code to load large amounts of data from other IRS internal data sources.

•Provide SME services to Enterprise Data Platform projects
•Architect and implement new ETL solutions and standardize patterns as part of the IRS modernization effort to migrate legacy sources to the AWS cloud platforms.
•Architect, Design, and Develop ETL Interface using Informatica tool. In addition, implement an Informatica based ETL solution fulfilling stringent performance requirements
•Develop/Implement the coding of Informatica mappings for different stages of ETL. Move staging table to the target table.
•Design, code, unit test ETL packages, triggers, and stored procedures, views, SQL transactions
•Understand and comply with development standards and SDLC to ensure consistency across the project.
•Design and develop Informatica PowerCenter mappings including transformations, mappings, mapplets, workflows, workflow monitor
•Utilize Informatica repository manager, designer, workflow manager & workflow monitor, to manage and administer ETL jobs
•Design, schedule, execute and monitor ETL jobs, including necessary exception handling & balance and control measures
•Provide data modeling support
•Perform troubleshooting, debugging, and performance tuning
•Create, test and refine SQL queries to support data profiling and data management
•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.

Location of work is remote in US.

*Position is contingent on funding.

Project Specific Qualifications:
•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 seven (7) years of relevant experience required
•Experience with Informatica Power Center
•Experience with IICS
•Exposure to Power Exchange and Control-M
•Experience with Informatica MDM, Informatica Data Quality, Informatica IDQ Analyst, and Informatica Metadata Manager
•Strong experience with ETL development and process from diverse data sources
•Experience with data modeling concepts
•Experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes
•Excellent 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
•Preferred experience: Knowledge of IRS business systems and data

Additional requirements as per Contract/Client:
•Candidates must meet requirements to obtain and maintain an IRS Minimum Background Investigation (MBI) clearance (active IRS Moderate Risk MBI clearance is a plus).
•Candidates must be a US Citizen or a Legal Permanent Resident (Green Card status) for at least three (3) years, and Federal Tax compliant

Job Summary

Essential Duties and Responsibilities:
- Oversee and interface with the developers to design, develop, test and implement critical functionality and POCs.
- Work with clients to create strategies and frameworks.
- Architect and design application solutions.
- Guide developers.
- Provide hands-on development support.
- Design software components from business requirements.
- Document and diagram application functionality from business requirements.

Minimum Requirements:
- Bachelor's degree in related field.
- 7-10 years of relevant professional experience required.
- Equivalent combination of education and experience considered in lieu of degree.

MAXIMUS Introduction

Since 1975, Maximus has operated under its founding mission of Helping Government Serve the People, enabling citizens around the globe to successfully engage with their governments at all levels and across a variety of health and human services programs. Maximus delivers innovative business process management and technology solutions that contribute to improved outcomes for citizens and higher levels of productivity, accuracy, accountability and efficiency of government-sponsored programs. With more than 30,000 employees worldwide, Maximus is a proud partner to government agencies in the United States, Australia, Canada, Saudi Arabia, Singapore and the United Kingdom. For more information, visit https://www.maximus.com.

EEO Statement

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.

Posted Max

USD $195,000.00/Yr.

Posted Min

USD $150,000.00/Yr.