ETL - Senior Engineer

Job Description

Responsibilities :

Technical Competencies:

Primary Skills: Mandatory

1.      MS SQL Server

2.      ETL , Informatica

 Secondary Skills : Good to have 

• Shell & Pearl scripting
• MSBI ( SSIS , SSRS ) 

 Responsibilities :  

1. Strong in SQL Server and ETL using Informatica Tool.
2. Responsible for all ETL design and architecture activities including data extraction, Profiling
3. Implement various transformations, loading, error handling, Audit and archiving data 
4. Responsible to implement performance tuning based on volume of data.
5. Responsible for ETL mapping and transformation logic coding including document all database schema, table names and roles
6. Good Experience on the SQL Server Development like Writing Queries, Complex Stored Procedures, Triggers, Views Etc.
7. Good Experience on the Performance optimization and Tuning
8. Designing logical, physical data models and generate DDL (Data Definition Language) for creating Tables, Views, Indexes,
9. Coordinate with the users and facilitate the use acceptance testing Responsible for executing the test cycles and data availability.
10.  Excellent Communication skills (written and verbal) 
11. Should be able to interact with client/business users.
12. Should be able to work independently 
13. Strong logical and Analysis Skill

Mandatory Competencies