Please send the resume to sharaq AT scadea DOT net or can reach me at 908-###-#### Ext 2228Searching for an BI/ETL Developer for a CONTRACT assignment with one of our premier Insurance clients in Westchester, NY.Business intelligenceETLSQL ServerSSISData WarehousingSSRSWill 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-SQLUnderstand 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 requirementsEvaluate large and complex data setsTroubleshoot SSIS packages to address critical production issues.Assist application developers in refining complex queues and performance tuningCreate tables, assign permissions, import data, perform app configurations, etc.Write and maintain technical documentationManage source code versioning and deploymentsStay knowledgeable with the latest advances in SQL Server and other data technologiesMinimum Qualifications:7+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 20177+ Years' experience coding T-SQL including the use of dynamic SQL5-7 Years of SSIS development experience in developing ETL applicationsData warehouse development experience using SSIS/SQL best practices including the development of reconciliation and validation frameworksWorking knowledge of best practices for loading a data into normalized and/or Star schemasExperience with best practice SSIS design patternsDemonstrated skill and ability in interfacing programmatically with a variety of enterprise systemsFamiliarity with source code management systems (TFS)Preferred Qualifications:Experience with development in other aspects of the Microsoft BI Stack SSAS/SSRS a plusExcellent written and verbal communication skills with the ability to formulate and communicate recommendationsQuick learnerAnalytical, Problem Solving, creative thinking and design skillsClearly demonstrated sense of urgency and bias for actionAbility to work well under pressure and independentlyEducation:Bachelor's Degree in Computer Science or related field preferredSharaqScadea Solutions IncWork #: 2228- provided by Dice Associated topics: .net, algorithm, back end, c c++, develop, developer, php, sdet, 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.