- Translate business-speak from BA/ Customer into data fields.
- Investigate, understand, describe, and document data contents of source systems.
- Determine how to make source and target queries yield comparable data.
- Validate whether the source data supports the business rules defined in the Business requirements document.
- Validate whether the source date supports the key relationships enforced/designed in the target database/ data model.
- Validate referential integrity in the source data system objects.
- Indentify data quality issues-bad data as a result of simple human data entry error or a poorly structured source system process.
- Work with BA's and Data Architect to make sure that data/rule exceptions are incorporated into the requirements and logical model.
Technical Skills
Minimum of 5 years:
. Data analysis
. Ability to understand Logical and Physical Data Models
. Data requirements determination
. Use Case creation
. Basic understanding of SQL
. MS Office Suite (Word, Excel, PowerPoint)
. Basic understanding of Essbase/Cubes
. Rational Suite (Requisite Pro, Rational Rose, ClearQuest, ClearCase)
Job Responsibilities
Perform source system validation
Work with Data Architects and other Analysts to ensure consistent data and business rules
Ability to identify data quality issues in source system data
Team Information
Comprised of 2 Project Managers, 2 Technical Architects, 2 Business Analyst, and 5 ETL Developers
To Apply to this job go to http://www.GadBall.com or click here