03 SSIS Data Engineer (Gurgaon) JobCode JC0015828

Job Description

**Role & Responsibilities Overview: **

Create, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms

Assist in the roll-out of new SQL based applications, problem fixes, and enhancements of software

Follow database best practices to improve the operational reporting environment while focusing on resolving problems raised by team members, stakeholders and end users

Implement/develop ETL using SSIS and other data movement requirements using SQL

Develops original and/or complex code in T-SQL/ SQL/ DENODO

Design and develop new SQL code as part of an ETL process

Improve SQL procedures, Window services / .NET programs which transform and load data

Develop stored procedures functions using T-SQL/SQL

Responsible for data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation

Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people

**Candidate Profile: **

Bachelor’s/Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply

Must have advance SQL, SSIS & Teradata knowledge