Job Title:                     SSIS SQL Opportunity

Industry                      Information Technology & Services

Location:                     Chennai, India

Salary:                         Competitive Salary + Other Benefits

Roles & Responsibilities

• 3 plus years of experience with Data Analytics
• Highly proficient in SQL
• Experience working with Data Warehousing, Reports and Dashboards
• Knowledge of Dimensional and relational modelling techniques
• Good Analytical and Execution ability
• Unix/Linux knowledge (Mandatory)
• Very organized with high-level attention to details
• Good interpersonal skills and ability to work under challenging circumstances
• Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent
• Java Dev experience is a plus
• Expert in all areas of SQL Server development including SQL Queries, Stored Procedures, User-defined Functions, Views, Triggers, Case expressions, Cursors, SQL relational database models and data integrity.
• Hands on in error handling and debugging coding issues and troubleshooting of production problems.
• Highly qualified in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables and strong knowledge of SDLC principles.
• Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent
• Organize professional with excellent Oral and written communication skills.
• Ability to work on fast paced work environment
• Experience with SSIS, SSAS, SSRS, dimensional models / star schema, and Power BI preferred – Optional
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart and Sub Reports. -Optional
• Involved in Migration from Business Objects reports to SSRS reports conversion. - Optional