CyberQ Consulting jobs - Senior SSIS/SQL Developer

The candidate will be the part of SQL Development with SQL Server 2008, 2012, SQL Server Integration Services (SSIS) 2008 and 2012 The SSIS Developer will be creating SSIS packages, develop and maintain existing Production SSIS/ DTS Packages, TSQL Code and Windows batch jobs. Hands on experience in SQL Server development, SSIS and SSRS. Good Experience in SQL queries. Stored procedures, functions, Triggers, cursors and strong experience with dynamic SQL. Candidates should have very good experience in data migration / data analysis / Data Conversion.

Your Key Responsibilities

• Expert Level - Development experience with MS SQL Server, SQL Server Reporting Services and SQL Server Integration Services (SSIS)
• Expert Level - Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Package
• Expert Level - Experience as a SQL Developer or similar role and excellent understanding of T-SQL programming.
• Expert Level - Develop complex SQL scripts, Stored Procedures, Triggers, Functions, and Views.
• Expert Level - Migrating data from various data formats into SQL Server databases using automated import processes (DTS and SSIS packages, etc.). Develop, imports to and extracts from existing SQL databases.
• Expert Level -Data Exploration and ETL: Microsoft BI, Alteryx, Talend Data Integration, Informatica PowerCenter, IBM Infosphere Data Stage etc.
• Expert Level - Experience using Microsoft Technologies (SQL Server 2008/2008 R2/2012/2016, Visual Studio 2008/2010/2012/2015)
• Expert Level -Data Warehouse Solutions: Redshift, Snowflake, Postgres
• Expert Level - Big Data technologies, such as Spark, Hive, NoSQL stores (HBase, Cassandra, DynamoDB, MongoDB).
  

What To Bring

• Strong Structured Query Language (SQL) skills.
• Fluent in MDX and T-SQL programming language, including stored procedures and user-defined functions
• Strong analytical, quantitative, problem solving, and organizational skills; attention to detail; and ability to coordinate multiple tasks, set priorities, and meet deadlines.
• Seek a self-starter who can work effectively as a member of a team or independently as the assignment requires. Excellent interpersonal skills and a successful track record of collaboration toward achieving objectives expected.
• Demonstrated ability to perform complex queries, assess data quality, and develop data mappings.
• Experience with scripting languages such as PowerShell and VBScript.
• Design and develop ETL Processes that will transform a variety of raw data such as flat files, xl spreadsheets into SQL Databases
• Experience with other Microsoft languages and technologies, including VB.Net, C#.Net preferred
• Experience with version control software such as TFS and Git.