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

bzJ5VXRQSUorVlQrYnV0UkQ2TGw2bTlITVE9PQ==
  • 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.

Job Tags

Contract work

Similar Jobs

StagePilot

Graphic/Motion Designer Job at StagePilot

 ...StagePilot is adding a designer with strong narrative and motion skills to our Nashville team. Youll work with our producers and directors to create graphics packages for high profile livestreams, and youll design and animate StagePilots production reels, product demos... 

Smith Seckman Reid

Real Estate Manager Job at Smith Seckman Reid

 ...new offices, expansions, renewals, and relocations. With Managements input, develop space programs aligned to headcount, growth assumptions...  ...readiness. Lead lease document process with LL and real estate counsel; review terms, track redlines, route for approvals,... 

Hander Inc. Plumbing & Heating

Sheet Metal Fabricator Job at Hander Inc. Plumbing & Heating

 ...Job Description POSITION SUMMARY Sheet Metal Fabricators will apply their sheet metal skills and knowledge to fabricate for residential and commercial HVAC job applications Essential Functions: Forming, cutting, and bending metal to create fabricated units accurately... 

Banana Daddy

No Open Roles. Just Good People Wanted. Job at Banana Daddy

 ...serving premium banana & coconut-based soft serve, scratch-made baked goods and tasty coffee with good vibes. Banana Daddy is...  ...already know than start from scratch. If you're someone who loves food, gives a damn about great service, and wants to be part of... 

Polly Pies

Baked Goods Production Commissary Job at Polly Pies

 ...Brand through promoting and providing extraordinary value through food safety and product quality. Willing and able to adhere to all...  ...Basic understanding of kitchen and food safety guidelines. Good organizational and communication skills. Valid Food Handlers Card...