EY - GDS Consulting - AI And DATA - IICS - Senior

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. 

EY-Consulting - Data and Analytics – Senior - IICS Developer

EY's 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. EY’s 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 EY’s 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 client’s 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.

• 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.

• 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.

• 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.

• 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.

• 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.

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, 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 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.