Maintec Technologies
Location: New York,NY, USA
Date: 2024-12-03T07:43:10Z
Job Description:
Job Role: ETL Lead Developer Location: NYC, NY. Duration: 12+ Months Contract 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.
Apply Now!