Maintec Technologies
ETL Lead Developer
Maintec Technologies, New York, New York, us, 10261
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 recommendationsWrite 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 development5-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 componentsComprehensive knowledge of Microsoft SQL Server 2008/2012 and/or 2016 including Integration Services (SSIS)Experience in C#, ASP.net, JavaScript a plus2+ years in Financial industry desirableDemonstrate strong development practices including source code documentation, source code analysis, test driven development, source code control, configuration management, unit and regression testingHave at least 3-year experience in Object-oriented analysis, design and programming (Java / C++)Create technical design documents, diagrams, and proposalsBe able to manage your time efficiently and work with little supervision.Strong problem solving and critical thinking skillsStrong attention to detailsStrong verbal and written communication skills.
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 recommendationsWrite 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 development5-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 componentsComprehensive knowledge of Microsoft SQL Server 2008/2012 and/or 2016 including Integration Services (SSIS)Experience in C#, ASP.net, JavaScript a plus2+ years in Financial industry desirableDemonstrate strong development practices including source code documentation, source code analysis, test driven development, source code control, configuration management, unit and regression testingHave at least 3-year experience in Object-oriented analysis, design and programming (Java / C++)Create technical design documents, diagrams, and proposalsBe able to manage your time efficiently and work with little supervision.Strong problem solving and critical thinking skillsStrong attention to detailsStrong verbal and written communication skills.