The job description is given below:
Position: Data Base Programmer
Experience: 3 – 7 years
Location: Bangalore
Mandatory skill: SSIS and SQL exp candidate.
ESSENTIAL REQUIREMENTS FOR THE ROLE
- Minimum 4 years of relevant hands-on experience in design & develop data warehouse and database programming.
SQL & DB Programming:
In-depth knowledge of T-SQL / PL-SQL Programming, performance tuning of complex queries
Knowledge in creating various database objects - Stored Procedures, User Define Functions, Views, indexes
ETL:
- Design and develop Scripts and Programs required to extract, transform, clean, and move data, in a manner that quality data can be loaded into the Data Warehouse.
- This will require previous experience in "incremental and history data load”
- Will need ETL performance handling experience using MS - SSIS/any standard ETL Tool and strong in handling large volume of data extraction and loading (500gb to 5tb)
- Should have above average skills in ETL, ETL performance tuning as well as above average skills in fine tuning complex queries of analytical Database Warehouse etc
NICE TO HAVE
- Experience in SSRS/SSAS 2005/2008 and knowledge of standard BI tools which is an added advantage
- Retail / Client domain exposure