ETL Architect

E*Pro Inc; Columbus (OH); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading technology solutions provider is seeking an experienced ETL Architect in Columbus, OH. The role involves architecture, design, and implementation of data integration solutions using Informatica tools. Candidates should possess strong expertise in ETL methodologies, data quality, and metadata management. Leadership ability to guide teams through the implementation lifecycle is essential. Knowledge of various databases such as Oracle, DB2, and SQL Server is preferred. Competitive compensation and a collaborative work environment are offered.

Qualifications

• Experience in designing and implementing ETL processes using Informatica.
• Proficient in data integration and migration solutions.
• Knowledge of performance tuning, data mapping, and scheduling.

Responsibilities

• Lead the design and implementation of ETL solutions.
• Collaborate with stakeholders to recommend effective solutions.
• Guide a team through the implementation lifecycle.

Skills

Informatica tools

ETL Architecture

Data Migration

Data Quality

Metadata Management

SQL Server

Oracle

DB2

Job description

Job Description

Title : ETL Architect

Location : Columbus, OH

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.