About the role
Job Description:
- Understand the data and perform data analysis to support building new reports and modify existing reports;
- Analyze users’ needs and design as necessary;
- Perform code promotions and test that reports are operating correctly;
- Perform Technical Review of requirements, analyze source data and provide gap analysis;
- Demonstrate Company’s Core Competencies and values held within;
- Collaborate, coordinate, and communicate across disciplines and departments;
- Research, construct, develop, and test complex SQL and PL/SQL scripts for new reports;
- Coordinate cross-functional projects as assigned and interact with all areas of the organization to achieve timely results;
- Ensure compliance with HIPAA regulations and requirements;
- Communicate with end users on report or environment issues;
- Provide weekend and off-hours support, as needed;
- Use structured coding methodology and “code once use many times” methodology so that the developed code is reusable;
- Perform code reviews/walk-throughs and unit testing of code developed by contract or new developers;
- Work with team members to develop program units that integrate seamlessly into the overall system.
Any Degree
Exp 5-9 years.
· Oracle SQL and PLSQL: Advanced (Well versed with Joins, ranking functions, analytic functions, views ,stored procedures, functions, packages, collections)
· Responsible for the design, development, coding, testing, debugging and documentation of applications to satisfy business requirements. Troubleshooting and resolving issues related to PL/SQL code.
· Optimizing database performance by tuning SQL queries and PL/SQL code.
· Perform Technical Review of requirements, analyze data and provide gap analysis.
· Good to have: Credit risk knowledge