Full-Time

ETL Informatica PowerCenter Developer

OpTech

OpTech

51-200 employees

No salary listed

Auburn Hills, MI, USA

In Person

Category
Data & Analytics (1)
Required Skills
ETL
Informatica
Requirements
  • 5+ years of experience with ETL Informatica
  • experience collecting design specs
  • good seasoned developer (lead not required)
  • testing
  • discussing defects
  • estimating task completion
  • must be proactive to identify design issues
  • experience working with clients to review requirements and discuss potential issues
  • 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
  • Good interpersonal skills
  • analytical skills
  • self-starter
  • easily adapt to change
Responsibilities
  • Attend ETL design meetings (approximately once per week)
  • work with BA's and other stakeholders
  • participate in testing and defect discussion
  • estimate task completion and track progress
  • collect and interpret design specifications for ETL solutions
  • proactively identify design issues and potential risks in ETL design and implementation
  • perform ETL development using Informatica PowerCenter and related tools
  • review requirements with clients and discuss potential issues
  • collaborate with other technology teams and the bank-wide teams
  • support small-to-medium scale ETL projects
  • understand and adapt to dynamics of the team/company
  • come up to speed on project and team processes
  • review requirements with clients and discuss potential issues
Desired Qualifications
  • Data Warehousing
  • working on large teams

Company Size

51-200

Company Stage

N/A

Total Funding

N/A

Headquarters

Troy, Michigan

Founded

1999

Simplify Jobs

Simplify's Take

What believers are saying

  • Fortune 1000 clients grow via experienced recruiters averaging 25 years in IT, healthcare, engineering.
  • Project-based delivery model supports auto parts manufacturers with mobile solutions and logistics.
  • Personalized staffing pairs talent with employers faster using leading technology nationwide.

What critics are saying

  • Teledyne Optech name collision erodes SEO, diverting 70-90% searches in 3-6 months.
  • Robert Half, TEKsystems capture 25-40% IT clients using AI matching in 12-18 months.
  • 2026 NDAA cuts slash federal IT outsourcing 20%, compressing OpTech margins in 6-12 months.

What makes OpTech unique

  • OpTech expands staffing to automotive OEMs via Personnel Research Division with 1,500 employees.
  • Michigan women-owned status enables government contracts in IT, AV, security across VA, NC, PA.
  • Embedded systems expertise delivers automotive ECUs and RTOS for 20+ years using SEI-CMM.

Help us improve and share your feedback! Did you find this helpful?

Your Connections

People at OpTech who can refer or advise you

Company News

OpTech
Sep 26th, 2023
OpTech Named Best and Brightest Company to Work for - 13th year in a row!

OpTech, LLC was once again recognized as one of Metropolitan Detroit's Best and Brightest Places to work for.

OpTech
Oct 19th, 2021
Optech, LLC recognized as Best and Brightest Places to work for

OpTech, LLC has been recognized as one of Metropolitan Detroit’s Best and Brightest Places to work for.