Research, document, and correct data issues, causing application anomalies.
Researches existing applications, system data, business processes and constraints. Conducts routine analysis of information gathered to correctly identify the problem/request and review with senior personnel as appropriate. Assists in the development of alternative solutions to define boundaries of the problem/request and estimate effort. Assists customers in clarifying routine requirements by reviewing business process needs.
Translates routine business requirements into written functional specifications. Updates existing specification documents. Participates in the review of technical specifications to receive approval.
Assists in the support of software applications and the development of training. Performs routine system and customer support and develops communications materials to assist customers with relevant system activities. Develops basic ad hoc reports and queries.
Assists in developing test plans and scripts of moderate complexity to validate that system functionality meets business requirements. Executes test scripts based on the test plan. Documents and communicates test results. Supports compliance standards for testing, approvals, migration and implementation.
Compiles relevant facts about customer issues and requests for presentation to business partners and process owners. Supports development of presentation material used in the change management processes.
Supports database integration and validation, to include integration of proprietary Data Conversion Spreadsheets.
Optimizes database so that the applications and services process and pass data as quickly as possible.
Typical Education and/or Experience Qualifications:
Technical bachelor's degree and typically 2 or more years' related work experience or a Master's degree or an equivalent combination of education and experience. A technical degree is defined as any four year degree, or greater, in a mathematic, scientific or information technology field of study.
Preferred Experience for this position:
SQL and PL/SQL programming experience required
Pentaho Data Integration, (PDI, Oracle Warehouse Builder (OWA), or Informatica ETL experience required.
Installation, configuration, and maintenance experience with Oracle s SQL and PL/SQL is required
Experience with ERP systems such as GOLDesp, Oracle, or SAP is preferred
Prior experience in customer facing environment is preferred Prior system administration experience is preferred
Java, Perl, shell scripting experience is desired