Description
Function:Systems/Product Software
- Enhances data integration team accomplishments and competence by planning delivery of solutions; answering technical and procedural questions for less experienced team members; teaching improved processes; mentoring team members.
- Studies data sources by interviewing users; defining, analyzing, and validating data objects; identifying the relationship among data objects.
- Plans data integration process by developing common definitions of sourced data; designing common keys in physical data structure;
- Establishing data integration specifications; examining data applications; examining data models and data warehouse schema;
- Identifying factors that negatively impact integration; forecasting resource requirements; establishing delivery timetables.
- Delivers data integration by implementing shared databases; integrating data shared across legacy, new development, and purchased package environments;
- Developing system modification specifications; mapping data; establishing interfaces;
- Developing and modifying functions, programs, routines, and stored procedures to export, transform, and load data; meeting performance parameters; resolving and escalating integration issues; coordinating actions among users, operations staff, and outside vendors; recommending adjustments as objectives change; documenting operational procedures and data connections.
- Validates data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
- Maintains data warehouse performance by identifying and resolving data conflicts; upgrading data definitions;
- Improves data integration by designing and evaluating new data interchange formats; improving physical design; rewriting data policy, standards, and procedures;
- Maintains team accomplishments by communicating essential information; coordinating actions; obtaining expert input; reviewing open issues and action items; contributing information to team meetings and reports; transferring knowledge of data integration process, techniques, and issues to application and support teams.
- Updates job knowledge by tracking ETL strategies and technologies; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.