Developer – Staff

Job details

---

Job description

---

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. ETL – SSIS/ADF Developer – Staff The opportunity We’re looking for Staff Level Consultants with expertise in ETL - SSIS/Azure Data Factory (ADF) 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. Your Key Responsibilities Support client needs by developing SSIS Packages in Visual Studio (version 2012 or higher) or Azure Data Factory (Extensive hands on experience implementing data migration and data processing using Azure Data Factory). Support client needs by delivering Various Integrations with third party applications Experience in pulling data from a variety of data source types using appropriate connection managers as per Client needs. Develop, Customize, Deploy, maintain SSIS packages as per client business requirements Should have thorough knowledge in creating dynamic packages in Visual Studio with multiple concepts such as - reading multiple files, Error handling, Archiving, Configuration creation, Package Deployment etc Experience working with clients throughout various parts of implementation lifecycle Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements. Skills And Attributes For Success Deliver large/medium DWH programmes, demonstrate expert core consulting skills and advanced level of ODI, Informatica, 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 2+ years SSIS/ETL developer experience Expertise in the SSIS, ETL Mappings, Data Warehouse concepts. Thorough knowledge in Structured Query Language (SQL) and experience working on SQL Server. Should have experience in developing SSIS Batch Jobs – Deployment, Scheduling Jobs, etc Knowledge of Azure components like ADF, Azure Data Lake, and Azure SQL DB Knowledge of data modelling and ETL design Design and develop complex mappings, Process Flows and ETL scripts In-depth experience in designing the database and data modelling. 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 ideally 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. Candidates having additional knowledge of BI tools such as PowerBi, Tableau, etc will be preferred. 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 EY | Building a better working world 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. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.