EY EY - GDS Consulting AI DATA SSIS Developer-Senior 

India, Karnataka, Bengaluru 

991367256

Your key responsibilities:

• Minimum of 4 to 6 years of industry experience in SSIS
• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
• Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems.
• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
• Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
• Design, implement and maintain database objects (tables, views, indexes, ) and database security
• Experience working with SSIS packages
• Analyse and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
• Test and prepare ETL processes for deployment to production and non-production environments.

Requirements:

• Bachelor’s degree in computer science, Engineering, or related field.
• 4 to 7 years of experience in SSIS development, with a focus on SSIS and SQL
• Strong understanding of Data Warehouse & ETL principles and practical experience.
• Understanding ofSSIS packages
• Experience working on Cloud Environment
• Proficiency in SQL tuning, data analysis, and data profiling techniques.
• Experience with Python coding for automation tasks.
• Ability to learn new technologies quickly and adapt to a fast-paced development environment.
• Excellent problem-solving skills and logical thought process.
• Ability to work independently and collaborate effectively in a team environment.
• Strong communication skills, both verbal and written.

Primary Skills:

• SSIS
• SQL

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.