ETL Developer

Go Intellects Inc; United States; Remote; USD 80,000 - 120,000; Full time

Job summary

An innovative firm is seeking an expert Informatica ETL Developer with over 10 years of experience to join their dynamic team. This fully remote position involves designing and optimizing ETL workflows using Informatica PowerCenter, ensuring data integrity and performance across various environments. The role includes creating technical documentation and mentoring junior developers, all while collaborating closely with functional teams to meet project goals. If you are adaptable, analytical, and driven, this opportunity offers a chance to make a significant impact on critical projects within the organization.

Benefits

Competitive salary

Qualifications

• 10+ years of experience in Informatica ETL development and administration.
• Strong skills in creating data mappings and workflows.

Responsibilities

• Develop and optimize ETL workflows and mappings for data extraction and loading.
• Mentor junior developers and troubleshoot ETL batch job issues.

Skills

Informatica PowerCenter

ETL Development

Data Mapping

Performance Tuning

Technical Documentation

Troubleshooting

Education

Bachelor’s degree in Information Technology

Project Management Professional (PMP) Certification

Tools

Informatica PowerCenter HTTP Adapter

JMS Adapter

Webservices Hub

Job description

Benefits:

• Competitive salary

Job Description:

Short Description:

Expert Informatica ETL Developer with at least 10+ years of proven professional experience in the design, development, testing and administration of Informatica PowerCenter workflows and mappings.

Complete Description:

The Core duties associated with the role are as follows:

1. Create data mapping and workflows using Informatica Powercenter to extract, transform and load data into the target environments (batch files, databases).
2. Create Technical design documents and develop test plans for ETL unit testing and integration testing.
3. Work and interact with functional and integration teams on architecture and design.
4. Tune and optimize ETL batch jobs for performance and throughput.
5. Conform to Informatica workflow and mapping standards to ensure consistent development across all resources (no hard coding, leverage of mapplet/reuse concept).
6. Develop ETL workflows and mappings from ODS to Datawarehouse using Informatica Powercenter.
7. Provide development support and mentor junior developers.
8. Assist with troubleshooting ETL batch job issues in production, PreProd, QA, and UAT.
9. Work and support Infrastructure and development teams.
10. Experience in Informatica Powercenter Installation, Administration, and Configuration is a plus.
11. Familiarity with Informatica Powercenter HTTP Adapter, JMS Adapter, Webservices Hub is good to have.

This individual will be working closely with the DHCF and its partner agencies to ensure the agencies’ priorities are met. This is a position in the DC Access System (DCAS) project.

Behavior Characteristics:

• Adaptable
• Analytical
• Goal-Orientated/Driven/Self-Starter

Minimum Education/Certification Requirements:
Bachelor’s degree in Information Technology or related field or equivalent experience; or a current Project Management Professional (PMP) Certification.

This is a remote position.