ETL Informatica PowerCenter Developer

OptechUs; Auburn Hills (MI); On-site; USD 90,000 - 110,000; Full time

Job summary

OptechUs in Auburn Hills, Michigan is seeking an experienced ETL Informatica Developer to support small projects and collaborate with team members. The role requires 5+ years of experience in ETL development and excellent interpersonal skills.

The ideal candidate will have a solid background in Informatica PowerCenter and a history of working with clients to review requirements. The position offers the opportunity to work on diverse technologies in a dynamic banking environment.

Qualifications

• 5+ years of experience with ETL Informatica.
• Experience collecting design specs.
• Seasoned developer, testing and discussing defects.

Responsibilities

• Support small projects and interact with various technologies.
• Work closely with BAs and attend ETL design meetings.
• Proactively identify design issues.

Skills

ETL Informatica

Data Warehousing

Interpersonal skills

Analytical skills

Self-starter

Tools

Informatica PowerCenter 9.5

DB2

TOAD

IBM Data Studio

Job description

Job Description

Requirements—5+ years of experience with ETL Informatica, experience collecting design specs, seasoned developer (lead not required), testing, discussing defects, estimating task completion, proactive to identify design issues, experience working with clients to review requirements and discuss potential issues.

Current Environment—Informatica PowerCenter 9.5 (9.x experience required), Power Exchange, Data Validation (used by analytics, may be used by this team in the future), database client—DB2, TOAD (future), IBM Data Studio.

Soft Skills—Good interpersonal skills, analytical skills, self‑starter, easily adapt to change.

Potential Challenges—Coming up to speed, understanding dynamics of the team/company, if they’ve worked in a large company where there’s a lot of red tape they can be comfortable.

Exciting Items About Role—Support fairly small projects, get to touch a lot of other technologies and work with other members in the bank, work with BAs, attend ETL design meetings (once a week).

Qualifications

Requirements—5+ years of experience with ETL Informatica, experience collecting design specs, seasoned developer (lead not required), testing, discussing defects, estimating task completion, proactive to identify design issues, experience working with clients to review requirements and discuss potential issues.

Current Environment—Informatica PowerCenter 9.5 (9.x experience required), Power Exchange, Data Validation (used by analytics, may be used by this team in the future), database client—DB2, TOAD (future), IBM Data Studio.

Soft Skills—Good interpersonal skills, analytical skills, self‑starter, easily adapt to change.

Potential Challenges—Coming up to speed, understanding dynamics of the team/company, if they’ve worked in a large company where there’s a lot of red tape they can be comfortable.

Exciting Items About Role—Support fairly small projects, get to touch a lot of other technologies and work with other members in the bank, work with BAs, attend ETL design meetings (once a week).

Additional Information

Preferred Skills/Experience: Data Warehousing, working on large teams.