This position is responsible for identifying the mapping between source data elements and target data elements in support of the requirements of data integration, reporting and analytic consumption projects such as: SQL, DB2, and Teradata
MUST HAVE:
· Strong Experience with Data Mapping
· Strong Experience in working with Operational and Analytical Data models for Mapping a variety of sources
· Experience working in Data profiling across various Databases
· Working experience with Teradata and DB2
· Extensive experience in mapping for ETL
· Experience in mapping dimensional data models
· Extensive experience in Requirements Analysis and Gap Analysis
· Advanced SQL Skills
· Experience eliciting requirements
· Profile data –do investigation on the data and work with business to understand what is needed
· Experience with Data analysis
o Ideally someone who has come from a Data Warehouse environment– some light data movement is required
· Experience working in the Heath Care industry
o Must have deep understanding of healthcare / payor data, subject areas, and source systems.
· Familiar with DataStage concepts
· Must understand data, data relationships at the table and attribute level.
· Able to interpret measurement definitions, and perform data decomposition.
· Perform Gap analysis and impact analysis on any changes that are being suggested.
· Possesses working knowledge of Relational Database Management Systems (RDBMS) and data warehouse, including full reference architecture from data integration, through semantic layer and reporting.
· Strong knowledge of data and dimensional modeling.
· Experienced in group facilitation with participants from diverse business functions and work skills.
· Strong analytical and problem solving skills
· Technical expertise regarding data models and database design development.
· Understanding of XML
· Identify, analyze, and interpret trends or patterns in complex data sets
· Ability to Identify, analyze, and interpret trends or patterns in complex data sets
· Ability to present complex information in an understandable and compelling manner
· Ability to understand complex Business Processes and their relationships
· Interpret data and develop data integration mapping documents based on findings
· In collaboration with others, develop and maintain temporary databases for data analysis necessary for projects and department functions
· In collaboration with others, develop and implement data collection systems and other strategies for data profiling