At EY, we’re all in to shape your future with confidence.We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.Join EY and help to build a better working world.
ETL - SSIS Developer – Senior
The opportunity
We’re looking for Senior Level Consultants with expertise in ETL - SSIS to join the EA group of our GDS consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.This role demands a highly technical, extremely hands-on Data Warehouse Modelling consultant who will work closely with our EY Partners and external clients to develop new business as well as drive other initiatives on different business needs. The ideal candidate must have a good understanding of the value of data warehouse and ETL and proven experience in delivering solutions to different lines of business and technical leadership.
Your Key Responsibilities
- Working with the client team, perform development and provide L3 support to database integrations and data warehouse using SQL Server, SSIS, Azure, 3rd party tools, etc.
- Good research, analysis, and problem-solving skills
- Ability to estimate work items in a systemic manner
- Strong understanding of Software Development Life Cycle (including agile development methodology)
- Hands on development and maintenance of the SQL based systems and various associated components for data ingestion, transformation, and processing.
- Hands on development and maintenance of integrations with various (including bespoke) Financial (Applications and Management Information Systems), Underwriting and Claims Management Systems and other systems based on business requirements.
- Ensure data quality and accuracy by implementing business and technical reconciliations via scripts, profiling and data analysis; analyse and create data mappings.
- Develop and support objects and code for data profiling, extraction, load and updates.
- Provide and maintain documentation for all developed objects and processes, in strict timelines.
- Integration testing of deliverables.
- Develop and run test scripts to ensure the quality of code and integrity.
- Use source code control repository (using VSTS, GIT) – preferred GIT
- Following data / integration design patterns and architecture as prescribed by the Architects. Come up with suggestions and recommendations where required
Skills And Attributes For Success
- Deliver large/medium DWH programmes, demonstrate expert core consulting skills and advanced level of SQL, PL/SQL, SSIS, SSAS knowledge and industry expertise to support delivery to clients
- Demonstrate management and an ability to lead projects or teams individually
- Experience in team management, communication, and presentation.
To qualify for the role, you must have
- Minimum of 3 - 7 years of ETL development on SQL Integration Projects using SQL Server Integration Services (SSIS) and SQL Server database objects
- Experience in implementing Type 2 Dimension Data models and data warehouse ETL techniques for historical data
- Experience in development of complex / enterprise data warehouse implemented over standard RDBMS (using SQL Server Integration Services (SSIS) and SQL Server database objects)
- Ability to understand/re-write nested complex SQL script
- Experience of analysis and resolution of data quality and integration issues
- Experience of Database queries (SQL) and performance tuning
- Experience in providing and maintaining technical documentation, specifically Data Mapping and Low Level / ETL Design Documentation
- Experience of working both independently and collaboratively with various teams and global stakeholders (Business Analysts/Architects/Support/Business) in an agile approach while working on projects or data quality issues
- Experience of upgrading/converting SQL based system to new versions (SQL Code and Objects) – preferable
- Microsoft Azure - PaaS fundamental knowledge - preferable
- Insurance Domain Experience – nice to have.
- Experience working on SSAS Cubes (development & design), along with troubleshooting performance and processing issues – nice to have
- Experience in BIML based development – nice to have
- Experience in source control using GIT
- Possess and demonstrate deep knowledge of data warehouse concepts, techniques, various design alternatives, and overall data warehouse strategies.
- Knowledge of Type 2 Dimension Data model and data warehouse ETL techniques for historical data
- Excellent communication and interpersonal skills
- Ability to work in a geographically dispersed team environment.
- Demonstrable ability to work on multiple activities simultaneously, and work to deadlines.
- Good written and verbal communication and interpersonal skills.
- Good understanding of development methodologies, frameworks, and best practices.
- Ability to work outside of regular working hours where necessary to ensure global migrations are successfully tested.
Ideally, you’ll also have
- Strong knowledge of ELT/ETL concepts, design, and coding
- Expertise in data handling to resolve any data issues as per client needs
- Experience in designing and developing Oracle object such as
- Tables, Views, Indexes, Materialized Views and Analytical functions
- Experience of creating complex SQL queries for retrieving, manipulating, checking, and migrating complex datasets in oracle
- Experience in SQL tuning and optimization using explain plan and SQL trace files
- Candidate ideally should have good knowledge of ETL technologies/tools such as SSAS, SSRS, Azure Analysis Services, Azure Power Apps.
- Good verbal and written communication in English, Strong interpersonal, analytical, and problem-solving abilities.
- Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
- Experience with Cloud data bases and multiple ETL tools.
What We Look For
- The incumbent should be able to drive ETL Infrastructure related developments. Additional knowledge of complex source system data structures preferably in Financial services (preferred) Industry and reporting related developments will be an advantage.
- An opportunity to be a part of market-leading, multi-disciplinary team of 10000 + professionals, in the only integrated global transaction business worldwide.
- Opportunities to work with EY GDS consulting practices globally with leading businesses across a range of industries
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 around
- Opportunities to develop new skills and progress your career
- The freedom and flexibility to handle your role in a way that’s right for you
EY | Building a better working world
EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.
