Previous Job
Previous
ETL Architect
Ref No.: 16-11007
Location: Columbus, Ohio
ETL Architect
Key Responsibilities:

· Function as the technical advisor
· Create a new data model
· New architecture design
· Lead the project full life cycle. 
· Managing the solution design and then stepping into a project lead role.



Basic Qualifications:
· Minimum 10 years total working experience in ETL architecture with strong BI reporting (Informatica, QlikView/Cognos)
· Assess the existing technical environment and culture to deliver the best solution and define the scope of architectural effort to be involved 
· Define the technical architecture in consultation with client architecture group using best design practices 
· Design and implement the system architecture 
· Lead and participate in group-analysis and design sessions
· Communicate critical technical choices, specify technical requirements and constraints for design and implementation
· Involve in review of technical solutions
· Understand the existing data integration strategy for the source feeds
· Identify the source-target mappings and the associated business transformations for the source systems
· Design data integration and conversion strategy 
· Design exception handling mechanism
· Design data retention and purging mechanism, data archival strategy, data auditing and process control mechanisms
· Create high level ETL design document



Preferred Qualifications:
· Minimum 14 years total working experience in ETL architecture with strong BI reporting (Informatica, QlikView/Cognos)
· Multiple ETL tools experience 
· Prior consulting experience
· Bachelor's Degree