Responsibilities:
- Tune application SQL queries for performance optimization
- Convert user stories into application logic
- reports, printed outputs, and interfaces with other systems.
- Ability to turn high-level requirements into a working system through iterative development.
- Create acceptance criteria, develop automated test frameworks, and validate work products.
- Develop, validate, and maintain large, enterprise class, applications written in Oracle PL/SQL
- Load data into tables
- Profile server resource usage, optimize and tweak, as necessary.
- Help write and optimize in-application SQL statements.
- Help Reporting developers solve data load, data quality issues.
- Develop and enhance an existing Data Mart in an OLAP schema.
- Analyze and convert business requirements to technical requirements, followed by design and implement the solutions.
- 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.
- Collaborate with other team members and stakeholders.
Education: At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required