ETL Lead Developer job vacancy

Vacancy expired!

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.