Understand client requirements and convert the ask into technical terms/user stories.
Work with Agile team and Data Architects to help and come up with the solution approach.
Help estimating implementation effort based on the requirements.
Researching and documenting data mart inputs and outputs. Source to target mapping, business rules applied to ETL.
Reviewing conceptual, logical, and physical data models to determine compatibility and fit with architectural principles and optimal solution design.
Understanding system data elements and existing data structures, as well as, data lineage connecting source to target.
Collecting, documenting and analyzing information management requirements.
Collecting, organizing, analyzing and disseminating significant amounts of information with attention to detail and accuracy.
Post-Secondary Education in an IT Concentration
10+ years of broad experience in IM/IT solution design and delivery, including working knowledge with infrastructure, database platform, middleware and applications.
7+ year in architecting and modeling large-scale enterprise applications, designing OLTP, OLAP, BI and ETL solutions leveraging multiple DBMS technologies (MS SQL Server, Oracle, Access Database etc.), in addition to strong MS Excel skills.
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
Experience with reverse engineering the source to target mapping to gain data insights
IBM: Data Manager, InfoSphere DataStage