ETL Lead Developer Job at Maintec Technologies, New York, NY

TFEzT2JxS1VsWkR6M3ZCZ3I5Z2hJampwRGc9PQ==
  • Maintec Technologies
  • New York, NY

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. Maintec Technologies

Job Tags

Contract work,

Similar Jobs

Cal Solar

Solar Installer Job at Cal Solar

 ...Based in Surrounding Counties About CalSolar Do you like the feeling of standing on...  ...dream job. At Cal-Solar, were not just installing solar. Were building long-term energy confidence...  ...structures Secure and install solar panels, inverters, and related hardware... 

Minnesota Staffing

Picker/Packer 1 (1st shift - Warehouse) Job at Minnesota Staffing

 ...Warehouse Order Fulfillment Position RRD is a leading global provider of marketing, packaging, print, and supply chain solutions that elevate engagement across the complete customer journey. The company offers the industry's most trusted portfolio of creative execution... 

Auto Centers

WASH BAY MANAGER Job at Auto Centers

 ...Description Description: The primary job for our Wash bay/Lot attendant Manager is to oversee the Lot Attendants, make the schedule for the wash...  ...functions. The employee must regularly lift and /or move up to 10 pounds, frequently lift and/or move up to 25 pounds and... 

School Result

Remote Customer Service Representative Work From Home (Atlanta-Based) Job at School Result

 ...Remote Customer Service Representative Work From Home (Atlanta-Based) Company: Rooted Talent Solutions Location: Atlanta, GA (Fully Remote) Job Type: Contract Estimated Salary: $33,800 $38,300 annually Job Description Rooted Talent Solutions... 

Pardo Dentistry

Dental Receptionist Job at Pardo Dentistry

 ...Our growing dental practice in in need of a dental receptionist! We are looking for an experienced and professional Dental Receptionist to join our team. The successful candidate will be responsible for greeting patients, scheduling appointments, managing patient records...