Job Description
The opportunity
We are looking for an experienced ETL professional with strong hands-on expertise in SSIS, Azure cloud data services, and Guidewire ClaimCenter migration. This is an excellent opportunity to join a leading organization and contribute to a growing Data & Analytics team. The ideal candidate will bring strong technical skills, end-to-end delivery experience, and the ability to work in a high-impact, fast-paced environment.
Job Description: ETL Developer
We are seeking a highly skilled Senior ETL Developer with deep knowledge of SSIS, Azure cloud data platforms, and Guidewire ClaimCenter migration processes. The ideal candidate will be responsible for designing, developing, and optimizing ETL workflows, ensuring data quality, and enabling seamless migration and integration across enterprise systems. This role requires a strong analytical mindset, attention to detail, and the ability to collaborate with cross-functional teams.
Key Responsibilities:
Overall experience must 5+ years.Design, develop, and maintain SSIS packages, data pipelines, and ETL workflows to support business and system integration requirements.Lead and execute data migration initiatives, especially migrations involving Guidewire ClaimCenter, including mapping, transformation, validation, and reconciliation.Work with business analysts and domain teams to translate requirements into scalable and maintainable ETL solutions.Implement data extraction, transformation, and loading strategies for complex datasets across on-prem and cloud platforms.Develop and optimize Azure-based data solutions, including Azure Data Factory (ADF), Azure SQL Database, Azure Storage, and related services.Perform data profiling, quality checks, reconciliation, and root-cause analysis to ensure accuracy and completeness of migrated or transformed data.Troubleshoot ETL performance issues, optimize workflows, and ensure best practices for scalability and maintainability.Collaborate with architects and cloud engineering teams to ensure solution alignment with enterprise standards.Maintain documentation, version control, deployment scripts, and ETL operational procedures.Stay updated with emerging Azure data engineering capabilities, ETL tools, and industry best practices.Experience with JIRA, Git, and Agile methodologies is preferred. What we look for
Strong technical expertise in SSIS, ETL development, and SQL programming.Hands-on experience delivering Azure cloud-based data pipelines.Proven experience in Guidewire ClaimCenter data migration or integration projects.Strong analytical, problem-solving, and communication skills.Ability to lead development tasks, mentor junior team members, and deliver complex solutions with minimal supervision.Enthusiasm to learn new technologies and adapt in a rapidly evolving data landscape. What working at EY offers
At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.
You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:
Support, coaching and feedback from some of the most engaging colleagues aroundOpportunities to develop new skills and progress your careerThe freedom and flexibility to handle your role in a way that’s right for you EY | Building a better working world
Apply for this Position
Ready to join ? Click the button below to submit your application.
Submit Application