Job Description:
Job Purpose
Analyzing and develop SQL for existing data structure and new applications.
Responsibilities
-
Responsible for code development in SQL Server.
-
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 T-SQL or SSIS.
-
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 an approach.
-
Collaborate with team members and participate in design discussions.
Knowledge and Experience
-
10+ year’s experience and any Degree.
-
Strong experience with Data warehouse, SQL Server T-SQL development supporting OLTP applications (complex queries, stored procedures, scripts, etc.).
-
Good communication and problem-solving skills. Be able to understand requirements and communicate problems and solutions clearly.
-
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
