Ey - Gds Consulting - Ai And Data - Informatica Cloud - Manager

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.EY- GDS - Data and Analytics – Informatica ManagerAs part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.Summary of Technologies : ETL Tools : Informatica PowerCenter, Informatica IDMCDatabases : Oracle, DB2, IDMSProgramming Languages : PL / SQL, SQLData Modeling and Documentation Tools : Standard data modeling tools, data flow toolsData Warehousing Technologies : Data warehouse architecture and designPerformance Tuning Tools : Oracle Database tuning tools, SQL tuning toolsRoles and Responsibilities : Project Management : Oversee the planning, execution, and delivery of data integration projects using Informatica PowerCenter and IDMC.Coordinate with stakeholders to define project scope, objectives, and deliverables.Team Leadership : Manage and direct the tasks of a team with up to two resources, providing mentorship and guidance on best practices and technical skills.Foster a collaborative environment to encourage team development and knowledge sharing.Architecture and Design : Design and implement data integration architectures that meet business requirements, specifically in the context of Core Banking and COTs (Commercial Off-The-Shelf) products.Analyze data structures in existing legacy systems to design extract, transform, and load (ETL) processes and data warehouse data structures.Development and Implementation : Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changing needs and requirements.Perform advanced ETL development activities using Informatica, PL / SQL, and Oracle Database tuning, including SQL tuning and Informatica Server administration.Develop data movement processes for the data warehouse.Performance Tuning : Monitor and optimize the performance of ETL processes and data integration workflows.Identify and resolve performance bottlenecks in data processing, ensuring efficient data movement.Data Quality Management : Implement data quality checks and validations to ensure the accuracy and integrity of data.Make recommendations, based on data profiling and analysis, for changes to existing / legacy systems, particularly in the area of automated data validations.Collaboration with IT and Business Teams : Work closely with IT and business team members in the design and implementation of the data warehouse.Collaborate with non-technical subject matter experts to understand underlying data behavior and characteristics, presenting findings in an accessible manner.Documentation and Reporting : Use standard data modeling, data flow, and data documentation tools to analyze, document, and present data analysis work.Maintain comprehensive documentation of data integration processes, workflows, and architecture.Provide regular status reports to management and stakeholders on project progress and challenges.Training and Support : Provide training and support to end-users and team members on Informatica tools and best practices.Act as a point of contact for troubleshooting and resolving issues related to data integration.Continuous Improvement : Stay updated with the latest trends and advancements in data integration technologies.Propose and implement improvements to existing processes and tools to enhance efficiency and effectiveness.To qualify for the role, you must haveEducation : BE / BTech / MCA with 10+ years of IT development experience, specifically in data integration and management.Informatica Expertise : Proven expertise in designing, architecting, developing, and implementing data engineering solutions using Informatica PowerCenter and IDMC.Cloud Platform Experience : Hands-on experience with public cloud platforms such as Snowflake, Azure, and AWS for data integration and management.Regulatory Knowledge : Strong understanding of Data Governance frameworks and compliance regulations, including BCBS, GDPR, HIPAA, and ACCORD.Data Documentation : Experience in producing Data Lineage Reports, Data Dictionaries, Business Glossaries, and identifying Key Business Entities (KBEs) and Critical Data Elements (CDEs) through data analysis.Data Integration Experience : 5+ years of experience in data lineage, data governance, data modeling, and data integration solutions, particularly with Informatica tools.Real-Time Data Processing : Strong exposure to real-time data processing methodologies and technologies within the Informatica ecosystem.Customer Interaction : Ability to effectively manage customer interactions and address issues in various situations.Data Management Knowledge : In-depth knowledge of Data Architecture, Data Modeling, and the adoption of best practices and policies in the Data Management space.Database and Warehousing Experience : Experience with databases (e.G., Oracle, DB2, IDMS), data warehousing, and high-performance computing environments.Presales and Presentations : Experience in presales activities, responding to RFPs, and delivering impactful customer presentations related to data integration solutions.Domain Experience : Nice to have experience in the Insurance and Finance domains, particularly in relation to data integration and management.Ideally, you’ll also haveClient management skillsWhat we look forPeople with technical experience and enthusiasm to learn new things in this fast-moving environmentWhat working at EY offersAt 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 youEY | 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.