Job ID :
Company :
Internal Postings
Location :
Type :
Duration :
6 months
Salary :
Status :
Openings :
Posted :
02 Jul 2018
Job Seekers, Please send resumes to
Job Details:

Must Have Skills (Top 3 technical skills only):
  • sql
  • dot net
  • ssis
Detailed Job Description:
  • Support services for applications used by Energy and Utilities Major
  • Hands-on experience on SQL Server 2008 and 2014
  • Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
  • Experienced T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and Cursors
  • Strong experience with SSIS ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
  • Experience in ETL DTS Packages & SSIS(DTSX) Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and union all.
  • Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2012
  • Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2012
  • Experience in Migration of SSRS reports from SQL 2008 to SQL 2014
  • Experience in creating Jobs, Alerts, SQL Server Agent, and scheduled SSIS Packages.
  • Experience in deploying packages in SQL Server 2014
  • Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQLServer Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
Minimum years of experience: 4+

Certifications Needed: No

Top 3 responsibilities you to shoulder and execute:
  • Support
  • Offshore Interaction
  • Client Interaction
Interview Process (Is face to face required?): No.