EY - GDS Consulting - AI And DATA - IICS - Senior
EY - GDS Consulting - AI And DATA - IICS - Senior
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
At EY youll 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 were 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.
EY-Consulting - Data and Analytics Senior - IICS Developer
EYs Consulting Services is a unique industry-focused business unit that provides a broad range of integrated services that leverage deep industry experience with strong functional and technical capabilities and product knowledge. EYs financial services practice provides integrated Consulting services to financial institutions and other capital markets participants including commercial banks retail banks investment banks broker-dealers & asset management firms and insurance firms from leading Fortune 500 Companies. Within EYs Consulting Practice Data and Analytics team solves big complex issues and capitalize on opportunities to deliver better working outcomes that help expand and safeguard the businesses now and in the future. This way we help create a compelling business case for embedding the right analytical practice at the heart of clients decision-making.
The opportunity
A Senior Designer and Developer working with Informatica Intelligent Cloud Services (IICS) in roles involving multiple sources such as files and tables typically has a broad set of responsibilities centered around designing developing and managing complex data integration workflows. Their role spans across multiple data sources including databases files cloud storage and APIs to ensure seamless data movement and transformation for analytics and business intelligence purposes.
Key Roles and Responsibilities of an IICS Senior Designer and Developer
- Designing and Developing Data Integration Solutions
- Develop and design ETL (Extract Transform Load) mappings and workflows using Informatica Cloud IICS integrating data from various sources such as files multiple database tables cloud storage and APIs through ODBC and REST connectors.
Configure synchronization tasks that may involve multiple database tables as sources ensuring efficient data extraction and loading.
Build reusable parameterized mapping templates to handle different data loads including full incremental and CDC (Change Data Capture) loads.
- Develop and design ETL (Extract Transform Load) mappings and workflows using Informatica Cloud IICS integrating data from various sources such as files multiple database tables cloud storage and APIs through ODBC and REST connectors.
- Handling Multiple Data Sources
- Work with structured semi-structured and unstructured data sources including Oracle SQL Server MI Azure Data Lake Azure Blob Storage Sales Force Net zero Snowflake and other cloud/on-premises platforms.
Manage file ingestion tasks to load large datasets from on-premises systems to cloud data lakes or warehouses.
Use various cloud connectors and transformations (e.g. Aggregator Filter Joiner Lookup Rank Router) to process and transform data efficiently.
- Work with structured semi-structured and unstructured data sources including Oracle SQL Server MI Azure Data Lake Azure Blob Storage Sales Force Net zero Snowflake and other cloud/on-premises platforms.
- Data Quality Governance and Documentation
- Implement data quality and governance policies to ensure data accuracy integrity and security throughout the data integration lifecycle.
Create and maintain detailed documentation such as source-to-target mappings ETL design specifications and data migration strategies.
Develop audit frameworks to track data loads and support compliance requirements like SOX.
- Implement data quality and governance policies to ensure data accuracy integrity and security throughout the data integration lifecycle.
- Project Planning and Coordination
- Plan and monitor ETL development projects coordinate with cross-functional teams including system administrators DBAs data architects and analysts to align on requirements and deliverables.
Communicate effectively across organizational levels to report progress troubleshoot issues and coordinate deployments.
- Plan and monitor ETL development projects coordinate with cross-functional teams including system administrators DBAs data architects and analysts to align on requirements and deliverables.
- Performance Tuning and Troubleshooting
- Optimize ETL workflows and mappings for performance including tuning SQL/PLSQL queries and Informatica transformations.
Troubleshoot issues using IICS frameworks and collaborate with Informatica support as needed.
- Optimize ETL workflows and mappings for performance including tuning SQL/PLSQL queries and Informatica transformations.
- Leadership and Mentoring (Senior Role Specific)
- Oversee design and development efforts review work of junior developers and ensure adherence to best practices and standards.
Lead the creation of ETL standards naming conventions and methodologies to promote consistency and reusability across projects.
- Oversee design and development efforts review work of junior developers and ensure adherence to best practices and standards.
Summary of Skills and Tools Commonly Used
- Informatica Intelligent Cloud Services (IICS) Informatica Cloud Data Integration (CDI)
- Should be having 6-9 years of experience
- SQL MI PL/SQL API integrations (REST V2) ODBC connections Flat Files ADLS Sales Force Netzero
- Cloud platforms: Azure Data Lake Azure Synapse (SQL Data Warehouse) Snowflake AWS Redshift
- Data modelling and warehousing concepts including OLAP Star and Snowflake schemas
- Data quality tools and scripting languages such as Python R or SAS for advanced analytics support
- Project management and documentation tools strong communication skills
- In essence a Senior IICS Designer and Developer role is a blend of technical expertise in data integration across multiple heterogeneous sources (files tables APIs) project leadership and ensuring high-quality scalable data pipelines that support enterprise BI and analytics initiatives.
What we look for
- A Team of people with commercial acumen technical experience and enthusiasm to learn new things in this fast-moving environment
- An opportunity to be a part of market-leading multi-disciplinary team of 1400 professionals in the only integrated global transaction business worldwide.
- Opportunities to work with EY Consulting practices globally with leading businesses across a range of industries
What working at EY offers
At EY were dedicated to helping our clients from startups 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 thats right for you
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.
Employment Type
Full Time
