ETL Architect

Columbus, OH, us on site Until 8/22/2026 H-1B sponsor history First posted February 23, 2026 Last posted February 23, 2026
Job 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.

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


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

About this role

Summary

Design and implement data integration solutions using Informatica, lead teams, and engage stakeholders.

Job title

ETL Architect

Experience level

not specified

Industry

technology

Location requirements

On-site in Columbus, OH, no remote work allowed.

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

Yes

Skills & keywords

Required skills

Informatica Power CenterInformatica Power ExchangeIDQMetadata ManagerETL designData MappingTransformation RulesDatabase schemaPerformance TuningOracleDB2SQL ServerMainframe

Preferred skills

industry models IIWIAAACORDHL7Insurance products Guidewire

Specializations

ETLdata integrationdata qualitymetadata managementdata migration
Locations

Structured locations inferred from the posting.

Columbus, OH, USA

On-site City