SQL, SSIS, ETL Database Developer St. Paul, MN 3-6+ Month Contract *upon offer, candidates must complete background check and drug test* Responsibilities: As the Database Developer for the IT Development team, reporting to the Software Development Manager. This Program is chartered with developing Global Sales and Service applications on enterprise mobile clients (Windows/iPad) with supporting web applications. The Database Developer will be responsible for the analysis, design, documentation, development, unit testing, and support of database ETL development for software applications. Provides support and guidance regarding ETL best practices and development standards Work with Business Analysts, Application Developers, Solution Architects and Data Architects in analyzing business requirements, specifications and technical design documents to define the optimal ETL solution and identify responsibilities for delivering Design, develop, test, tune, and implement procedural database code using ETL (SSIS) tools and Microsoft SQL Server. This includes but is not limited to SSIS packages, stored procedures, views, and functions Provide support and guidance regarding ETL database development, best practices, and development standards Create and propose technical design documentation which includes current and future ETL functionality, database objects affected, specifications, and flows/diagrams to detail the proposed implementation Research and facilitate resolution of support or production related ETL database development issues Create and maintain documentation as it relates to ETL database development standards, templates, and processes Basic Qualifications: 5+ years experience working in an IT environment 3+ years experience with SQL Server development 3+ development experience with SQL Server Integration Service (SSIS) Strong knowledge of Data Warehousing methodologies and concepts Experience with BI Tools is a plus Advanced knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) and best practices Advanced knowledge of metadata driven ETL integration using SSIS Familiarity with RDBMS principles, database design and normalization Experience with advanced query design, stored procedures, views and functions Experience with index design and T-SQL performance tuning techniques Must be able to effectively communicate technical information to both technical and non-technical personnel Exposure to Database Administration i.e. Replication, Backup\\Restore strategies, Clustering, Log-shipping a plus Strong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are required. Excellent English communication skills: formal presentation, written and oral, impeccable articulation and enunciation to be fully comprehended by foreign Ecolab associates Strong familiarity with the US business environment and with managing communications with users and other Ecolab IT resources Ability to comprehend complex technical and logical concepts and adapt quickly to change. Design and develop database schema from conceptual models and extending existing schema Preferred Qualifications Bachelors degree in a technical area or equivalent Experience working in a multi-technology environments is a plus Strong knowledge of a variety of software development methodologies (Agile, Waterfall, etc) and an understanding as to when each of these approaches is most suitable Strong analytical and problem solving skills Experience of working in a methodical and structured manner. Previous experience of implementing new process and structures in order to improve database development performance highly desirable 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
Key Skills: