02 Oct
|
IRIS SOFTWARE
|
Noida
02 Oct
IRIS SOFTWARE
Noida
Job Summary
ETL - Senior Engineer
Location: Noida, UP, India
Company: Iris Software
Job Description
Strong in SQL Server and ETL using Informatica Tool.
Responsible for all ETL design and architecture activities including data extraction,Profiling
Implement various transformations, loading, error handling, Audit and archiving data
Responsible to implement performance tuning based on volume of data.
Responsible for ETL mapping and transformation logic coding including document all database schema, table names and roles
Positive Experience on the SQL Server Development like Writing Queries, Complex Stored Procedures, Triggers, Views Etc.
Positive Experience on the Performance optimization and Tuning
Designing logical, physical data models and generate DDL (Data Definition Language) for creating Tables, Views, Indexes,
Coordinate with the users and facilitate the use acceptance testing Responsible for executing the test cycles and data availability.
Excellent Communication skills (written and verbal)
Should be able to interact with client/business users.
Should be able to work independently
Strong logical and Analysis Skill
Technical Competencies
MS SQL Server
ETL , Informatica
Secondary Skills: Valuable 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
📌 Etl Senior Engineer Noida
🏢 IRIS SOFTWARE
📍 Noida