Join Iris Software, recognized as one of India's Top 25 Best Workplaces in the IT industry. We are a fast-growing IT services company dedicated to helping clients thrive through technology-enabled transformations. Our work involves complex, mission-critical applications utilizing cutting-edge technologies in Data & Analytics, Cloud, and Engineering.

At Iris, we believe in empowering our employees to "Build Your Future. Own Your Journey." We foster a culture that values your potential, amplifies your voice, and ensures your work makes a real impact. Through engaging projects, personalized development, and mentorship, we support your professional and personal growth.

Key responsibilities include designing and architecting ETL processes, data extraction, and profiling. You will implement transformations, manage data loading, error handling, and archiving, along with performance tuning based on data volumes.

This role also involves documenting ETL mapping and transformation logic, as well as all database schemas, table names, and roles. You will gain substantial experience in SQL Server development, including writing complex stored procedures, triggers, and views, alongside performance optimization and tuning.

Furthermore, you will be involved in designing logical and physical data models, generating DDL for database objects, and coordinating user acceptance testing. Ensuring test cycle execution and data availability are crucial aspects of this position. Strong communication and analytical skills are essential for interacting with clients and business users independently.

Mandatory technical competencies include strong proficiency in MS SQL Server and ETL using Informatica. Good-to-have skills encompass Shell and Pearl scripting, as well as MSBI components like SSIS and SSRS.

Further mandatory competencies include experience with Data Warehousing (DWH), Oracle PL/SQL Packages, Autosys, Talend, and Informatica PowerCenter. Excellent written and verbal communication skills are vital for client interaction and independent work, complemented by strong logical and analytical abilities.