Senior Oracle Programmer Analyst
Apply NowCompany: West Advanced Technologies (WATI)
Location: Los Angeles, CA 90011
Description:
Senior Oracle Programmer Analyst
Los Angeles, CA
12 months
Minimum Qualifications:
Bachelor of Science (BS) degree in computer science or closely related field.
6 years of experience with Oracle utilizing PL-SQL programming objects, Oracle database objects, Unix scripting and experience with Toad/Oracle SQL Developer, Data Modeler, Oracle 12c and/or later
6 years of experience writing stored procedures, T-SQL, functions, Packages, Triggers, and SQL queries
Experience utilizing report writing best practices (optimization, use of joins and sub-queries)
Experience pulling data from Oracle 12c and/or higher databases for reports and interfaces
6 years of experience with MAPPER (Maintain, Prepare, and Produce Executive Reports)/ BIS (Business Information Server)
Responsibilities:
Maintain and provide support for a critical application running on MAPPER (Maintain, Prepare, and Produce Executive Reports)/BIS (Business Information Server)
Provide support to Business Analyst(s) in gathering and/or clarifying data and functional requirements from business owners
Develop, Deploy and/or maintain interfaces & reports in accordance with Client requirements and standards using Oracle 12c and/or higher and Microsoft SQL Server
Reporting Services (SSRS) 2012 and/or higher
Develop data interface packages, shell scripts in accordance with Client requirements and standards using Oracle and Unix shell scripts
Develop and maintain database stored procedures, views, functions and/or packages
Develop SQL queries and support ad hoc requests for data
Identify and troubleshoot business process or data quality issues that show up in the reports and interfaces and subsequently communicate to resolve and eliminate problems
Regards
Naresh Damagalla
West Advanced Technologies, Inc
Serving government agencies for 22 Years
www.wati.com
Los Angeles, CA
12 months
Minimum Qualifications:
Bachelor of Science (BS) degree in computer science or closely related field.
6 years of experience with Oracle utilizing PL-SQL programming objects, Oracle database objects, Unix scripting and experience with Toad/Oracle SQL Developer, Data Modeler, Oracle 12c and/or later
6 years of experience writing stored procedures, T-SQL, functions, Packages, Triggers, and SQL queries
Experience utilizing report writing best practices (optimization, use of joins and sub-queries)
Experience pulling data from Oracle 12c and/or higher databases for reports and interfaces
6 years of experience with MAPPER (Maintain, Prepare, and Produce Executive Reports)/ BIS (Business Information Server)
Responsibilities:
Maintain and provide support for a critical application running on MAPPER (Maintain, Prepare, and Produce Executive Reports)/BIS (Business Information Server)
Provide support to Business Analyst(s) in gathering and/or clarifying data and functional requirements from business owners
Develop, Deploy and/or maintain interfaces & reports in accordance with Client requirements and standards using Oracle 12c and/or higher and Microsoft SQL Server
Reporting Services (SSRS) 2012 and/or higher
Develop data interface packages, shell scripts in accordance with Client requirements and standards using Oracle and Unix shell scripts
Develop and maintain database stored procedures, views, functions and/or packages
Develop SQL queries and support ad hoc requests for data
Identify and troubleshoot business process or data quality issues that show up in the reports and interfaces and subsequently communicate to resolve and eliminate problems
Regards
Naresh Damagalla
West Advanced Technologies, Inc
Serving government agencies for 22 Years
www.wati.com