Innovations technological

Hi,

Hope you are doing great.

Job Title: SSIS Developer

Location: Dublin, OH

What Software Engineering contributes.

·         Software Engineering is responsible for designing, developing, implementing and supporting applications, systems and IT products required to achieve the company's business objectives.

·         Demonstrates knowledge of software development techniques and fluency in software languages and application programming interfaces.

·         Demonstrates general understanding of hardware/software platforms including but not limited to operating systems, databases, application servers, web servers and integration technologies.

·         Plans and executes system implementations that ensure success and minimize risk of system outages or other negative production impacts.

·         Demonstrates conceptual knowledge of architecture standards and database and operating systems.

·         Demonstrates problem solving ability that allows for effective and timely resolution of system issues including but not limited to production outages.

·         Analyzes production system operations using tools such as monitoring, capacity analysis and outage root cause analysis to identify and drive change that ensures continuous improvement in system stability and performance.

·         Demonstrates knowledge of software development, life cycle, modeling of business processes, application design patterns, business/functional documents. Estimates to high level business requirements and provide options analysis.

Job Details

·         SSIS development

·         Implementation end to end packages that must include variables, parameters, expressions,transactions, Script task, Script component using C#

·         Fact ETL, Dimension ETL and advanced including slow changing dimensions and late arrivals

·         Dimension design

·         Developing expressions

·         TSQL

·         Stored procedures

·         User-Defined Functions and Types

·         Triggers

·         Error handling

·         Query Performance Tuning

·         XML

·         Files, File groups, and Integrity

Qualifications

·         Bachelor's degree in Computer Science, Math, Engineering or equivalent degree required.

·         Masters Degree in Computer Science, Math or Engineering preferred.

·         2-3 years working in the Microsoft stack, including experience using C#, .NET 3.5/4.0

·         MS Visual Studio 2010 or higher

·         MS Team Foundation Server 2010 or higher

·         MS SQL Server 2008 or higher, ETL, SSRS, T-SQL

·         MS .NET Framework 3.5 or higher

·         C#.NET, VB.NET, ASP.NET, JavaScript, HTML 3/4/5, CSS

·         Good Knowledge of Ado.net technologies like entity framework or LINQ to SQL and preferred to know ADOMD for accessing Cubes (SQL server analysis services )

·         Architectural and application design patterns (MV* preferred)

·         Demonstrate a solid understanding of database design principles as well as Multidimensional databases

·         Agile software development methodologies