ECS is seeking a ODI Solutions Architect.

Ready to apply Before you do, make sure to read all the details pertaining to this job in the description below.

THIS POSITION IS HYBRID.

Job Description:

ECS is seeking an ODI solutions Architect to support our PBES program in the Pentagon.

Responsibilities and required skills.

Expert in migration and conversion of ODI versions
Tune application SQL queries for performance optimization.
Convert user stories into application logic, reports, printed outputs, and interfaces with other systems.
Develop, validate, and maintain large, enterprise class, applications written in Oracle PL/SQL.
Help write and optimize in-application SQL statements.
Help Reporting developers solve data load and data quality issues.
Provide production deployment and production support as needed.
Validate and fix data in the tables as appropriate.
Validate the tables design / data quality for individual reports as based on business requirements.
Experience with Oracle/Hyperion products (Essbase, Planning, HFM, DRM) or other multi-dimensional products.
Ability to work in a multitask environment and within a team setting.

Required Skills:

Bachelor s degree in computer science, Computer Engineering, or a closely related field. Or equivalent work experience.
US citizenship required per contract.
Secret Security clearance.
Effective communication and interpersonal skills.
Excellent Unit testing Skills.
Ability to take requirements documentation from end users.
Experience using Oracle Packages/Functions/Procedures.
6+ Years Experience with Performance Tuning and optimizing SQL, PL/SQL code to reduce execution time or improve efficiency.
6+ years' experience with the following skillsets: PL/SQL, SQL, PowerBuilder, UNIX shell scripting, GIT, BitBucket
Experience analyzing complex business applications, developing logic flow charts, and translating detailed design into software.
Hyperion development skills.
Knowledge of the financial services industry desired but not required.
Knowledge of working in Oracle relational databases.
Strong SQL development, SQL analytics and tuning skills.
Strong understanding of both structured and unstructured data.

Desired Skills:

Strong understanding of database structures, theories, principles, and practices, and are familiar with the full data lifecycle from creation and transformation to usage and archiving. Have previous working experience on financial system databases.