Essential Duties and Responsibilities:

• Develop, design, tune and maintain SSIS packages to perform ETL processes.
• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
• Troubleshoot performance issues (i.e. evaluating execution plans, indexing, etc.) and provide technical leadership and recommendations
• Write scripts for automated testing of data quality, data completeness and business logic.
• Write and maintain documentation of the ETL process and system interfaces using CBNA templates and process flow diagrams.
• Collaborate with business analysts, other data services team members and developers to accomplish task objectives.
• Guide developer colleagues to correctly/appropriately implement business requirements and perform code review/testing of software developed by colleagues.
• Design ETL audit control and log tracking.

Experience / Qualifications /Education:

• 10+ years of challenging experience in system architecture, software design and development
• 5-7 year of experience in SQL Server 2012/2014/2016 database development such as advanced SQL, XML, function, procedure, indexes, partition, and query optimization.
• 5+ years of SQL Server experience with SSIS, SSRS components
• Comprehensive knowledge of Microsoft SQL Server 2008/2012 and/or 2016 including Integration Services (SSIS)
• Experience in C#, ASP.net, JavaScript a plus
• 2+ years in Financial industry desirable
• Demonstrate strong development practices including source code documentation, source code analysis, test driven development, source code control, configuration management, unit and regression testing
• Have at least 3-year experience in Object-oriented analysis, design and programming (Java / C++)
• Create technical design documents, diagrams, and proposals
• Be able to manage your time efficiently and work with little supervision.
• Strong problem solving and critical thinking skills
• Strong attention to details

Strong verbal and written communication skills

Job Type: Fixed term contract

Salary: $43.10-$81.72 per hour

Schedule:

• Monday to Friday

Experience:

• SSIS: 7 years (preferred)
• SSRS: 6 years (preferred)

Work Location: Remote

Please Note :
nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.