- Position Description:
- Assignments will include various
data work within the Enterprise Data Services group.
Responsibilities / Deliverables:
- Lead and perform the analysis
of data requirements for projects and on-going application enhancements
integrating them with multi-function, division, or enterprise
data models.
- Develop conceptual and logical
data models that are implementation independent and meet the
business requirements. Identify and document data conversion
rules, and the interactions between data and business processes.
Participate in and lead logical data model reviews.
- Lead and perform the design,
development and maintenance of physical data models for projects
and on-going application enhancements integrating them with multi-function,
division, or enterprise data models. Write and execute DDL to
create tables, indexes, triggers, constraints, and privileges.
Ensure data integrity, security and performance through review
of physical data models against application processing, system
design, and architectural standards.
- Lead and perform the design
and execution of DML test plans. Lead and perform database-related
testing in conjunction with other application testing efforts.
Coordinate the implementation of database objects into production.
Support development teams, including consulting on the design
and execution of all data-related tasks.
- Support the resolution of production
application data problems. Recommend improvements to or replacement
of application databases, data modeling tools, and data processes.
- Identify AS-IS data conditions
by writing and executing complex SQL. Contribute to data cleansing
and conversion efforts by writing and maintaining Oracle procedures,
functions, and packages.
|
|
Required Skills, Knowledge
and Experience:
- Advanced knowledge of system
analysis concepts, techniques and tools.
- Experience with SQL and PL/SQL
- Experience with data analysis
modeling techniques and tools
- Experience with relational database
technology (Oracle, DB2, MS Access)
- Knowledge with technology frameworks
based on object-relational mapping
- Knowledge of MetaData concepts
and tools, data warehousing, and dimensional modeling.
- Experience working on large
projects, and leading small teams preferred
- Experience with data mapping
and data conversions
- Experience with Object Oriented
analysis and design concepts.
Desired Skills, Knowledge
and Experience:
- Advanced knowledge of system
analysis concepts, techniques and tools.
- Experience with SQL and PL/SQL
- Experience with data analysis
modeling techniques and tools
- Experience with relational database
technology (Oracle, DB2, MS Access)
- Knowledge with technology frameworks
based on object-relational mapping
- Knowledge of MetaData concepts
and tools, data warehousing, and dimensional modeling.
- Experience working on large
projects, and leading small teams preferred
- Experience with data mapping
and data conversions
- Experience with Object Oriented
analysis and design concepts.
|