ETL Architect

Reposted 3 Months Ago
Be an Early Applicant
Columbus, OH, USA
In-Office
Senior level
Professional Services • Industrial • Manufacturing
The Role
Design and implement data integration/ETL, data quality, metadata management and migration solutions using Informatica. Lead ETL design, mappings, transformations, scheduling, performance tuning, and mentor developers while engaging client architects and stakeholders. Work with multiple databases and industry data models; insurance product experience is a plus.
Summary Generated by Built In
Company Description

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com.

Job Description

Title : ETL Architect

Location : Columbus, OH 

Type : Fulltime Permanent

Work Status : US Citizen / GC / EAD (GC)

Required Skills:

• Responsible for Architecture, Design and Implementation of Data Integration/ETL, Data Quality, Metadata Management and Data Migration solutions using Informatica tools 

• Execute engagements as Data Integration-ETL Architect and define Solution Strategy, Architecture, Design and Implementation approach 

• Expertise in implementing Data Integration-ETL solutions which include components such as ETL, Data Migration, Replication, Consolidation, Data Quality, Metadata Management etc. using Informatica products (e.g. Power Center, Power Exchange, IDQ, Metadata Manager) 

• Responsible for Detailed ETL design, Data Mapping, Transformation Rules, Interfaces, Database schema, Scheduling, Performance Tuning, etc

• Lead a team of designers/developers and guide them throughout the implementation life cycle and perform Code review 

• Engage client Architects, SMEs and other stakeholders throughout Architecture, Design and implementation lifecycle and recommend effective solutions

• experience in multiple Databases such as Oracle, DB2, SQL Server, Mainframe, etc

• Experience in Industry models such as IIW, IAA, ACORD, HL7, etc. and Insurance products (e.g. Guidewire) will be plus

Additional Information

All your information will be kept confidential according to EEO guidelines.

Skills Required

  • Architecture, design and implementation of Data Integration/ETL, Data Quality, Metadata Management and Data Migration using Informatica tools
  • Hands-on expertise with Informatica products (PowerCenter, PowerExchange, IDQ, Metadata Manager)
  • Detailed ETL design including data mapping, transformation rules, interfaces, database schema design, scheduling and performance tuning
  • Lead and mentor designers/developers, perform code reviews and guide implementation lifecycle
  • Engage with client architects, SMEs and stakeholders throughout architecture, design and implementation
  • Experience with multiple databases (Oracle, DB2, SQL Server, Mainframe)
  • Familiarity with industry data models and standards (IIW, IAA, ACORD, HL7)
  • Experience with insurance products/platforms (e.g., Guidewire)
  • Work authorization: US Citizen, Green Card holder, or EAD (as listed)
  • Location: Columbus, OH (onsite)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
6 Employees
Year Founded: 2011

What We Do

EPRO Services, Inc. is a leading provider of superior waterproofing and contaminant protection systems designed to keep building structures dry and safe. Founded in 1993, the company specializes in building envelope protection, offering a comprehensive range of solutions including vapor intrusion mitigation, air barrier systems, and leak repair services for a variety of site conditions across the United States and Canada.

Similar Jobs

Scadea Software Solutions Logo Scadea Software Solutions

Architect

Artificial Intelligence • Information Technology • Software • Consulting
In-Office
Cincinnati, OH, USA
204 Employees
In-Office
Findlay, OH, USA
35000 Employees
15-15 Hourly

Arrive Logistics Logo Arrive Logistics

Logistics Internship (Summer 2027)

Logistics • Sales • Software • 3PL: Third Party Logistics
In-Office
Columbus, OH, USA
1700 Employees

SailPoint Logo SailPoint

Architect

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
143K-240K Annually

Similar Companies Hiring

Cravath, Swaine & Moore LLP Thumbnail
Legal Tech • Other • Professional Services
New York, NY
1200 Employees
Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account