Skills and Competencies
•Good knowledge and experience of Microsoft SQL Server.
•Logical and analytical thinking.
•Self-motivated.
•Pro-active approach.
•Enthusiasm, flexibility and ability to function well in a small team.
•Positive attitude.
•Knowledge of SDLC.
•Comfortable in an Agile project environment.
•Diplomacy and negotiating skills.
•Excellent written and verbal communications.
•Ability to see the bigger picture.
•Good eye for detail.
•Good working knowledge of Excel .
•Commitment and determination to deliver good service.
Key Result Areas
•Performing Impact analysis (mostly through use of SQL Server).
•Extraction of logic and rules from the system code, understanding rules and mapping the rules and data to a new data model (interaction with Business as and when required).
•Performing Regression testing and explaining variances (through analysis of the system SQL code).
•Integration analysis.
•Specifying attributes required from source.
•Specifying data types of attributes .
•Specifying filtering, mapping and transformation rules to be applied to source data.
•Specifying file requirements (e.g.)
frequency, file format, delivery time etc).
•Specification of Processing rules per system, this includes.
•Specifying data mappings.
Specifying filtering rules to be applied to data.
•Specifying transformation to be applied to data to comply to the required target format.
•Communicating all requirements clearly and with the required level of detail to the Technical Team.
•Making suggestions for improvements where areas are identified.
•Assisting Project Manager in the identification of Project Risks.
• Interacting with Business to obtain requirements.
•Interacting with Business to communicate status of the analysis.
