Informatica ETL Developer

AHU Technologies Inc; United States; Remote; USD 80,000 - 120,000; Full time

Job summary

A leading technology firm is seeking an ETL Developer to be a part of the DC Access System (DCAS) project. In this fully remote role, you will create data workflows and collaborate with various teams to ensure project success. Strong proficiency in Informatica PowerCenter and a background in IT are essential. Join us to leverage your expertise in a dynamic environment and contribute to impactful projects.

Qualifications

• Bachelor’s degree or equivalent experience in IT.
• Experience with Informatica PowerCenter for ETL tasks.
• Strong analytical and goal-oriented mindset required.

Responsibilities

• Create data mappings and workflows using Informatica PowerCenter.
• Tuning and optimizing ETL batch jobs for performance.
• Consult on complex projects with a focus on systems analysis.

Skills

Critical thinking

Data mapping

ETL optimization

Technical documentation

Informatica PowerCenter

Education

Bachelor’s degree in Information Technology

Project Management Professional (PMP) Certification

Tools

Informatica PowerCenter

Informatica HTTP Adapter

Webservices Hub

Job description

Role: ETL Developer

Location: WASHINGTON, DC (Remote)

Client: DC Government

Job Description

The resource will become an integral part of the DCAS Team, making every problem associated with the platform a problem of their own. They will demonstrate the initiative and critical thinking abilities necessary to resolve all problems and challenges accordingly.

Core Duties:

• Create data mapping and workflows using Informatica PowerCenter to extract, transform, and load data into target environments (batch files, databases).
• Create technical design documents and develop test plans for ETL unit testing and integration testing.
• Work and interact with functional and integration teams on architecture and design.
• Tune and optimize ETL batch jobs for performance and throughput.
• Conform to Informatica workflow and mapping standards to ensure consistent development across resources (avoid hard coding, leverage mapplet/reuse concepts).
• Develop ETL workflows and mappings from ODS to Data Warehouse using Informatica PowerCenter.
• Provide development support and mentor junior developers.
• Assist with troubleshooting ETL batch job issues in production, PreProd, QA, and UAT.
• Support infrastructure and development teams.
• Experience in Informatica PowerCenter installation, administration, and configuration is a plus.
• Familiarity with Informatica PowerCenter HTTP Adapter, JMS Adapter, Webservices Hub is beneficial.

This individual will work closely with DHCF and partner agencies to meet their priorities. This position is part of the DC Access System (DCAS) project.

Behavior Characteristics:

• Adaptable
• Analytical
• Goal-oriented/Driven/Self-starter

Additional Contract Responsibilities:

1. Formulate and define system scope and objectives based on user needs and business requirements.
2. Devise or modify procedures to solve complex problems, considering system capacity, limitations, and desired results. Analyze business and user needs, document requirements, and translate into system specifications.
3. Provide consultation on complex projects, acting as a top-level contributor/specialist in systems analysis, considering business implications of technology application.

Minimum Education/Certification Requirements:

Bachelor’s degree in Information Technology or related field, or equivalent experience. PMP certification is a plus.

This is a remote position.