This site uses cookies. To find out more, see our Cookies Policy

PL/SQL Developer in Las Vegas, NV at APEX Systems

Date Posted: 4/16/2019

Job Snapshot

Job Description

Job #:  926588

Apex Systems is looking for a SQL Database Developer in Las Vegas, NV for one of our healthcare clients! 

If this sounds like a great opportunity for you, please send Lizzy Kinsman, Technical Recruiter, an email at lkinsman@apexsystems.com and reference job #926588.

Position Description:
This Mountain West Region (MWR) Healthcare Economics (HCE) senior database developer position involves:
- Data warehouse/Data mart design, Data Modeling, Data source mapping, Production process troubleshooting,
- Database application development (Oracle APEX/MS .NET), Source data reconciliations, ETL system development, ETL Administration, and SDLC/Design Documentation.
- Database structures/processes will be developed in Oracle PL/SQL and/or MSSQL T-SQL involving various sources of data consisting of Healthcare Insurance
claims: Medical, Pharmacy, Vision and Dental (to name a few).
- Informatica Power Center will be utilized for ETL processes where appropriate.
- Data Marts will be built and maintained to support MWR HCE BI reporting and strategic analyses.
Healthcare Economics is looking for a dynamic individual to join Optum Care
and contribute to the success of the Healthcare Economics Data Management team located in Las Vegas, NV.
Duties and responsibilities include:
- Migrate existing PL/SQL, T-SQL and Informatica production ETL processes to Windows MSSQL 2016/Oracle 12c environments
- Troubleshoot ETL issues / problems and communicate solutions/resolutions to the team
- Map database sources to specified data types and objects
- Translate concepts to requirements/design then develop code, then administer testing and deploy into a production process
- Complete development activities timely and accurately while following the System Development Life Cycle (SDLC)
- Follow 'Best Practices' in Oracle PL/SQL and MSSQL T-SQL database application development
- Optimize production processes by suggesting improvements/enhancements
- Record daily hours of development activities in the Data Management Resource Management System
Minimum Position Requirements:
- 3 years of experience in Data mart design with Oracle 10g/11g/12c databases
- 3 years of experience in PL/SQL development
- 3 years of Experience with T-SQL
- Strong knowledge of Data Warehousing schema(s) design
- Strong knowledge of Data Warehouse Extract, Transform, and Load concepts
- Experience with ETL production operations and maintenance
- Bachelor's degree in Information Systems, Computer Science or 5 years of related work experience.
Additional Assets:
- Experience with MS SQL Server: T-SQL; SSIS; Jobs Management
- Experience with Extract, Transform, and Load (ETL) tools
- Experience with Data Modeler Tools

 

 

 

 

 

 

 

 

EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178

CHECK OUT OUR SIMILAR JOBS

  1. Programmer Jobs
  2. Software Developer Jobs