ETL - Senior Engineer

Iris Software Inc.; Dadri; On-site; INR 800,000 - 1,100,000; Full time

Benefits offered by this job

World-class benefits

Job summary

Iris Software Inc. is seeking a skilled ETL/SQL Server specialist to design and implement data integration solutions. You will work on data pipelines, warehousing tasks, and performance tuning for enterprise-scale datasets.

Responsibilities include developing ETL mappings, creating data models, and collaborating with business users to ensure data quality and timely delivery. Join a leader in IT services with growing opportunities and a strong culture.

Qualifications

• Experience with SQL Server and ETL design and development.
• Strong ETL and data warehousing concepts with hands-on tooling.
• Knowledge of Informatica Power Centre and data integration tasks.

Responsibilities

• Develop and maintain ETL mappings and workflows in Informatica.
• Design logical/physical data models and generate DDL for tables, views and indexes.
• Tune performance and optimize SQL queries for large data volumes.
• Coordinate with users and support testing and data availability.

Skills

MS SQL Server

ETL

Informatica

Shell & Pearl scripting

MSBI (SSIS, SSRS)

Job description

Why Join Iris?

Are you ready to do the best work of your career at one of

Why Join Iris?

Are you ready to do the best work of your career at one of India’s Top 25 Best Workplaces in IT industry? Do you want to grow in an award-winning culture that truly values your talent and ambitions?

Join Iris Software — one of the fastest-growing IT services companies — where you own and shape your success story.

About Us

At Iris Software, our vision is to be our client’s most trusted technology partner, and the first choice for the industry’s top professionals to realize their full potential.

With over 4,300 associates across India, U.S.A, and Canada, we help our enterprise clients thrive with technology-enabled transformation across financial services, healthcare, transportation & logistics, and professional services.

Our work covers complex, mission-critical applications with the latest technologies, such as high-value complex Application & Product Engineering, Data & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation.

Working with Us

At Iris, every role is more than a job — it’s a launchpad for growth.

Our Employee Value Proposition, “Build Your Future. Own Your Journey.” reflects our belief that people thrive when they have ownership of their career and the right opportunities to shape it.

We foster a culture where your potential is valued, your voice matters, and your work creates real impact. With cutting-edge projects, personalized career development, continuous learning and mentorship, we support you to grow and become your best — both personally and professionally.

Curious what it’s like to work at Iris? Head to this video for an inside look at the people, the passion, and the possibilities. Watch it here.

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

• 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
• Good Experience on the SQL Server Development like Writing Queries, Complex Stored Procedures, Triggers, Views Etc.
• Good 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

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

Perks And Benefits For Irisians

• Iris provides world-class benefits for a personalized employee experience. These benefits are designed to support financial, health and well-being needs of Irisians for a holistic professional and personal growth. Click here to view the benefits.