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 DescriptionTitle : 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 InformationAll 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)
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.
