ETL - Senior Engineer

Job Summary Job Description

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

Technical Competencies

• MS SQL Server
• ETL , Informatica

Secondary Skills: Good to have

• Shell Pearl scripting
• MSBI (SSIS, SSRS)

Mandatory Competencies

• Data AI - ETL OTHERS - Data Warehousing (DWH)
• Database - Oracle - PL/SQL Packages
• DevOps/Configuration Mgmt - DevOps/Configuration Mgmt - Autosys
• ETL - ETL - Talend
• ETL - ETL - Informatica Power Centre
• Beh - Communication and collaboration