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