Previous Job
Lead IT developer-St. Paul, MN
Ref No.: 17-01862
Location: St. Paul, Minnesota
Job Title : Lead IT developer
Location : St. Paul, MN
Rate : DOE
Position Type : Full time/Contract
Interview: Phone /Skype

(US Citizens/ GC/GC-EAD preferred)

No sponsorship available for this job, direct hire and NO 1099 or C2C

Job Description

Basic Qualifications:
  • 10+ years' experience working in an IT environment
  • 5+ years' experience as a SQL / ETL developer
  • 4+ years' experience as a software developer using one or more of the following database development languages (Microsoft SQL, SSIS, other SQL)
  • Demonstrable experience having used Informatica or similar batch ETL tool
  • 2+ years' experience with Informatica or other ETL tool
  • 1+ years' experience using Microsoft Team Foundation Server (Around Source Control, Branching and Merging, Creating Build Definitions)
  • 1+ years' experience using/interacting with Microsoft Visual Studio
Preferred Qualifications:
  • Bachelor's degree in a technical area or equivalent.
  • Demonstrable skill in UC4 and/or Mulesoft is a plus
  • Experience working in a multi-technology environments is a plus.
  • Strong knowledge of a variety of software development methodologies (Agile, Waterfall, Scrum) and an understanding as to when each of these approaches is most suitable
  • Strong analytical and problem solving skills
  • Demonstrable experience involving designing a large application level architecture.
  • Experience of working in a methodical and structured manner. Excellent communication skills: presentation, written, oral.
  • Strong interpersonal skills to successfully team with software vendors, outsourcing partners and internal business and IT associates.
  • Must be able to perform as an effective member in a team-oriented environment, maintain a positive attitude, and achieve desired results while working with minimal supervision

  • Developing transactional SQL Procedures/Queries for web and mobile applications.
  • Review and analyze business requirements and provide technical feasibility and estimates with regards to data access, extracts and transformations.
  • Create technical documents for ETL and SQL developments using Visio, Powerpoint and other MS Office package.
  • Distribute and manage SQL/ETL development work across the team's SQL/ETL internal developers and contractors.
  • Translating technical requirements into SQL/ETL application code
  • Developing ETL (Batch) / SQL transformation using Microsoft SQL Server tools, Informatica software and Mulesoft .
Participate in Scrum Sprints as the SQL/ETL Development Lead; activities include participating in Sprint Planning and Estimating sessions, Daily Stand-ups, writing code, and attending Sprint Demos and Sprint retrospectives.
  • Developing transactional queries using Ecolab's SQL tools
  • Making modifications to existing applications and modules in accordance with written specifications.
  • Set / Implement ETL / SQL development standards (Coding Standards, Code Reviews, Test-Driven Development) for the G360 Program and other Development initiatives
  • Work closely with the QA / Testing team to help identify/implement defect reduction initiatives.
  • Work closely with the Architecture team to insure architecture standards and principles are followed during development. Provide early input to influence architecture design.
  • Take part in code reviews, and reviewing the work of colleagues.
  • Coaching / mentoring team members.