BI/ETL Developer -local consultants only - Scadea Solutions Inc

Compensation

: $115,530.00 - $170,900.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Please send the resume to sharaq AT scadea DOT net or can reach me at 908-###-#### Ext 2228 Searching for an BI/ETL Developer for a CONTRACT assignment with one of our premier Insurance clients in Westchester, NY. Business intelligence ETL SQL Server SSIS Data Warehousing SSRS Will need to create dozens of ETL processes that included many sources (XLM, SQL, Oracle, Excel) using SSIS. Create additional functions to existing OLAP cubes and Data Warehouse validation improvements. Perform extensive database performance tuning and optimization for the current environment for this global insurance/reinsurance company. Main areas of responsibility: Develop complex queries and stored procedures using T-SQL Understand and analyze requirements to develop, test, configure and deploy complex SSIS packages. Use of SQL Server 2012, 2014 or 2016 experience to implement robust, maintainable solutions that meet requirements Evaluate large and complex data sets Troubleshoot SSIS packages to address critical production issues. Assist application developers in refining complex queues and performance tuning Create tables, assign permissions, import data, perform app configurations, etc. Write and maintain technical documentation Manage source code versioning and deployments Stay knowledgeable with the latest advances in SQL Server and other data technologies Minimum Qualifications: 7+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017 7+ Years' experience coding T-SQL including the use of dynamic SQL 5-7 Years of SSIS development experience in developing ETL applications Data warehouse development experience using SSIS/SQL best practices including the development of reconciliation and validation frameworks Working knowledge of best practices for loading a data into normalized and/or Star schemas Experience with best practice SSIS design patterns Demonstrated skill and ability in interfacing programmatically with a variety of enterprise systems Familiarity with source code management systems (TFS) Preferred Qualifications: Experience with development in other aspects of the Microsoft BI Stack SSAS/SSRS a plus Excellent written and verbal communication skills with the ability to formulate and communicate recommendations Quick learner Analytical, Problem Solving, creative thinking and design skills Clearly demonstrated sense of urgency and bias for action Ability to work well under pressure and independently Education: Bachelor's Degree in Computer Science or related field preferred Sharaq Scadea Solutions Inc Work #: 2228 - provided by Dice
Associated topics: .net, application, back end, c c++, develop, developer, python, sde, software engineer, software programmer * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...