ETL- Ab Initio Architect

Comtech is a woman-owned small business founded in 1998 and headquartered in Reston, VA. We offer IT solutions across the disciplines of program/project management, applications development, infrastructure, Cyber security, and enterprise content/data management services. We have developed our methodologies and processes based on the IT Infrastructure Library (ITIL) v.3 Framework across enterprise infrastructure operations. These methodologies and processes are reinforced through our organization’s externally accredited certifications, which include ISO 9001:2008 Quality Management System (QMS), ISO/IEC 20000-1:2011 IT Service Management Systems (SMS, corporate ITIL certification), ISO 27001:2005 Information Security Management System (ISMS), and CMMI-DEV Level 3"

Role overview:

Candidate will support the implementation of a Data Integration/Data Warehouse for the NextGen and Informatics Teams

Responsibilities:

The EDF ETL architect determines the optimal approach for obtaining data from diverse source system platforms and moving it to the EDF. This involves understanding all of the source system platforms, application architectures and DBMSs. The person in this role designs and implements the infrastructure used by ETL specialists on specific projects. This work includes constant refinement activities to standardize and implement new functionality based on experiences learned during the course of specific projects. This also involves the establishment and enforcement of a concise series of technical standards for the deliverables of individual projects. The ETL architect provides input to the long-term technology planning portions of the program plan. This person assists and coaches ETL specialists during the course of their individual projects. He/she has a thorough understanding of – and is capable of teaching – the diverse EDF ETL acquisition techniques and the decision rules on how to apply them. The ETL architect is accountable for the following:

Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI.

Implement the ETL infrastructure used at a project level.

Establish and enforce technical standards for deliverables of projects.

Coach project ETL specialists on data acquisition techniques, decision

Required Skills

Candidate must have twelve+ (12)+years overall industry experience

Candidate must have ten+ (10) years of Data Integration/Data Warehousing with relational and Dimensional Data Modeling

Candidate must have eight+ (8+) years of knowledge/experience in architecture, design, and development using ab initio platform

Candidate must have a five+ (5+) years of experience in UNIX, DB2, SQL, Data Quality

Candidate must have five+ (5) years strong background in Data Modeling

Healthcare Experience a Plus

************Please share your resume, contact # and best time to connect you*********