SQL Developer II

| Summerlin | Hybrid
Sorry, this job was removed at 11:43 p.m. (CST) on Thursday, February 24, 2022
Find out who's hiring in Other US Location.
See all Developer + Engineer jobs in Other US Location
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Overview
Provides technical support to Project Leads and Managers. Heavy focus on translating requirements for new or existing processes into new ETLs, stored procedures, view, tables and other database objects. This role requires following strict Software Development Life Cycle development and implementation guidelines. Responsibilities also include conducting QA testing, providing support for business partners with ad-hoc needs requests and organizing and presenting data to business partners.
Job Description

  • Facilitate data retrieval and manipulation through implementation of views, stored procedures, triggers and cursors
  • Design and develop ETLs to move data across internal servers utilizing input variables for easier deployment to different environments
  • Design and develop ETLs to move data across external SFTP utilizing input variables for easier deployment to different environments
  • Apply ETL error handling and package logging that stores results into SQL tables for ease of troubleshooting
  • Optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables objects
  • Optimize query performance tuning by reading executing plans, maintaining indexes, database refactoring (making code more efficient and maintainable)
  • Knowledgeable of cloud services such as Snowflake, Amazon AWS and Microsoft Azure
  • Follow strict Software Development Life Cycle development and implementation guidelines
  • Perform other related duties as required and assigned
  • Demonstrate behaviors which are aligned with the organization's desired culture and values

Ideal Candidate will have the following:

  • 3+ years of MS SQL database and SQL Information Services knowledge and development experience
  • Ability to design, code, test, debug, package and deploy quality, scalable and well documented SQL solutions
  • Experience with SSIS, Informatica or other ETL tools
  • Programming experience with emphasis on designing complex SQL queries and business components
  • Ability to collaborate with other developers, business analysts, project managers, business users, vendors, and management
  • Team player with strong communication and interpersonal skills, possess a high degree of self-motivation and ability to work independently with minimal supervision
  • Proven track record at delivering timely and accurate information in a fast-paced environment
  • Financial Services and, if possible, mortgage industry experience preferred
Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about PennymacFind similar jobs