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

Clutch

3D Motion Designer Job at Clutch

Title : 3D Motion DesignerLocation: Remote (Must be eligible to work in the U.S.)EST preferredSalary: up to $70kClutch Creative...  ...Responsibilities: Conceptualize, design, and animate 3D motion graphics and visual effects for social media content.Collaborate with designers... 

Cognizant

SAP Performance Test Lead Job at Cognizant

 ...Cognizant Technology Solutions is looking for a SAP Performance Test Lead to join in our team of IT professionals in a permanent role. If you meet our background requirements and skills and are looking for an opportunity with these skills and expertise, here is the... 

JLL

Package Delivery Clerk Job at JLL

 ...you receive the second dose of a two-dose vaccine series (e.g., Pfizer or Moderna) or two weeks after a single-dose vaccine (e.g., Johnson & Johnson/Janssen). Failure to provide proof of vaccination may result in termination. Jones Lang LaSalle ("JLL") is an Equal Opportunity... 

Pacific First Aid Ltd.

Warehouse Associate Job at Pacific First Aid Ltd.

 ...Rationalize the layout and management of the warehouse, plan the storage space and adjust the position; Execute daily pick and pack order, and monitor order completion progress; Pack and build kits; Reduce the dead stock and optimal routing of stock picking... 

Alpha Retail Holding LLC

Florist Job at Alpha Retail Holding LLC

Job Description Job Description Hiring florists! Fast workers with excellent foral skills? Please apply!