Educational Requirements

Bachelor of Engineering

Service Line

Data Analytics Unit

Responsibilities

- Design, develop, and maintain ETL packages using SSIS.
- Extract, transform, and load data from multiple data sources such as SQL Server, Oracle, flat files, APIs, and cloud platforms.
- Develop and optimize complex SQL queries, stored procedures, views, and functions.
- Perform data validation, cleansing, and transformation activities.
- Troubleshoot ETL failures and resolve performance bottlenecks.
- Monitor and maintain data integration workflows and schedules.
- Collaborate with business users and data teams to understand data requirements.
- Implement error handling, logging, and auditing mechanisms within SSIS packages.
- Support data warehouse development and reporting initiatives.
- Conduct unit testing, integration testing, and deployment activities.
- Create and maintain technical documentation for ETL processes and workflows.
- Ensure adherence to data governance, security, and compliance standards.

Additional Responsibilities
- Bachelor's degree in Computer Science,



Information Technology, Engineering, or a related field.
- 57 years of experience in SSIS development and SQL Server environments.
- Relevant Microsoft certifications are an added advantage

Technical and Professional Requirements
- Strong experience with Microsoft SQL Server Integration Services (SSIS).
- Proficiency in T-SQL, stored procedures, triggers, views, and functions.
- Experience with SQL Server Management Studio (SSMS).
- Knowledge of ETL/ELT methodologies and data integration best practices.
- Experience with SQL Server Agent job scheduling and automation.
- Understanding of data warehousing concepts such as star schema and dimensional modeling.
- Experience in performance tuning and query optimization.
- Familiarity with source control tools such as Git, Azure DevOps, or TFS.
- Solid debugging and troubleshooting skills.

Preferred Skills
- Technology->SQL SSIS->SQL Server

📌 SSIS Developer (Hyderabad)
🏢 Infosys
📍 Hyderabad