About the role
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.
Requirements
- • 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 pr
- • 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