Job Description

Responsibilities :

Technical Competencies:

Primary Skills: Mandatory
MS SQL Server
ETL , Informatica

Secondary Skills : Good to have
Shell Pearl scripting
MSBI ( SSIS , SSRS )

Responsibilities:
Solid 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
Good Experience on the SQL Server Development like Writing Queries, Complex Stored Procedures, Triggers, Views Etc.
Valuable 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
Robust logical and Analysis Skill

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

Location: Noida, UP, India

Company: Iris Software

📌 Etl Senior Engineer Noida
🏢 IRIS SOFTWARE
📍 Noida