Job Description
Job Purpose
The Senior Developer, SQL will analyze and develop SQL for existing data structures and new applications.
Responsibilities
- Analyze and develop queries, stored procedures, and functions for use by existing and new data sets.
- Responsible for code development in modern RDMS systems as well as unstructured data stores.
- Get familiar with existing business process and data structure.
- Learn code standards, development processes and tools.
- Gather and understand requirements and develop business modules using various data tools.
- Write complex queries to conduct research and implement complex business rules.
- Develop sequences of processes populating data into new database structure.
- Create required table structure for loading data and ingestion processes.
- Performance optimization and troubleshooting new code.
- Develop PowerShell script to schedule business jobs.
- Document technical processes and approach.
- Collaborate with team members and participate in design discussions.
Knowledge and Experience
- 10+ years of experience and a degree in a technology field.
- Bachelor's degree
- Strong experience with Data warehouse, T-SQL development supporting OLTP applications (complex queries, stored procedures, scripts, etc.).
- Experience with Postgres databases.
- Experience working with unstructured data and related tools.
- Good communication and problem-solving skills. Be able to understand requirements and communicate problems and solutions clearly.
- Experience working in agile development teams and utilizing SDLC tools such as Azure DevOps and Jira.
- Experience automating delivery of database changes using DevOps tools such as Azure DevOps and Jenkins.
- Experience with ETL processes utilizing SSIS.
- Experience with SSRS is desired.
- Experience with PowerShell scripting is desired.
- Familiar with data modeling concepts
- Basic knowledge of Mortgage domain.
- Strong verbal and written communication skills
Schedule
- Shift timings: 3PM – 12:30AM
Read Full Description