Finance - Data Integeration Consultant jobs at Ey in India, Chennai

The opportunity : Senior Consultant-TMT-Assurance-ASU - TR - Technology Risk – Chennai, Mumbai, Gurgaon

ASU - TR - Technology Risk :

1) Ensuring their accounts comply with the requisite audit standards

2) Providing a robust and clear perspective to audit committees and

3) Providing critical information for stakeholders.

Our Service Offerings include External Audit, Financial Accounting Advisory Services (FAAS), IFRS & US GAAP conversion, IPO and other public offering, Corporate Treasury - IFRS 9 accounting & implementation support etc.

Your key responsibilities

• Conduct comprehensive IT audits to address and ensure compliance with established controls and regulatory requirements, including Internal Controls over Financial Reporting (ICFR)
• Identify and review IT General Controls (ITGCs) to safeguard organizational assets and IT Application Controls (ITACs) to ensure accuracy of financial reporting
• Execute SOX compliance activities, including risk assessments, controls testing, and remediation efforts
• Prepare and assess Service Organization Control Reports (SOCR) to validate the effectiveness of IT controls objectives
• Conduct IT process reviews through stakeholder interviews, data validations, and document analysis
• Apply IT-related and internal control knowledge to deliver high quality engagement
• Review Change Management processes, ensuring that changes are thoroughly reviewed, tested and approved
• Review Access Management procedures to ensure proper access levels and permissions.
• Evaluate and address Segregation of Duties (SOD) concerns to prevent unauthorized access and potential conflicts
• Collaborate with cross-functional teams to identify control gaps and develop effective remediation plans
• Stay abreast of industry trends, regulatory changes, and emerging technologies related to IT controls and compliance
• Prepare and communicate audit findings, recommendations, and status updates to key stakeholders and management.

Technical Excellence

• Proven experience of IT controls, ITGCs, ITACs, SOX 404 controls testing and IT auditing
• Strong knowledge of Change Management, Access Management, SOD, business process IT controls and ICFR principles
• Familiarity with Service Organization Control Reports (SOCR) and related frameworks.
• Familiarity with ERPs such as SAP, Oracle, Dynamics 365 etc.
• Excellent analytical and problem-solving skills with attention to detail.
• Effective communication and interpersonal skills for collaborating with internal teams and external auditors.
• Relevant professional certifications such as CISA, CISSP, CISM, CRISC, CCSK and others (if relevant).
• Ability to adapt to a fast-paced environment and manage multiple priorities

Skills and attributes for success

• A recognized university degree in business, information technology, computer engineering, or other relevant discipline
• Experience of 4-6 years of IT audit, Internal audit, IT risk advisory for a professional services firm, or within industry
• Project management and strong communication skills
• Ability to build and develop relationships
• Ability to adapt to different client situation and bring best outcome in difficult situations
• Leadership, teamwork, and client service skills
• Demonstrated integrity within a professional environment
• Good networking skills

What we look for

People with the ability to work in a collaborative manner to provide services across multiple client departments while following the commercial and legal requirements. You will need a practical approach to solving issues and complex problems with the ability to deliver insightful and practical solutions. We look for people who are agile, curious, mindful and able to sustain postivie energy, while being adaptable and creative in their approach.

What we offer

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

CNS - Risk - Process & Controls :

Financial Services Risk - helps clients in the financial sector to identify, manage and monitor the risks in their business. It is done through a transformative and agile approach including process and procedures, risk, data modeling and analytics, reporting to stakeholders and third parties, business requirements (for software selection and IT implementation), analysis of assets and liabilities, and capital and liquidity management.

Technical Excellence

Identify & internally escalate and potential red flags related to the engagement.

• Preparation of reports/deliverables/status updates/audit committee presentations.
• Demonstrate the ability to multi-task and manage multiple projects as directed by the managers.
• Handling data analytics - Access, ACL etc.

• Proactively identify and escalate counselees not being chargeable on engagements.

• Awareness of internal auditing standards issued by IIA and ICAI.

Fresh qualified

People with the ability to work in a collaborative manner to provide services across multiple client departments while following the commercial and legal requirements. You will need a practical approach to solving issues and complex problems with the ability to deliver insightful and practical solutions. We look for people who are agile, curious, mindful, and able to sustain positive energy, while being adaptable and creative in their approach.If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

CNS - Risk - Process & Controls :

Financial Services Risk - helps clients in the financial sector to identify, manage and monitor the risks in their business. It is done through a transformative and agile approach including process and procedures, risk, data modeling and analytics, reporting to stakeholders and third parties, business requirements (for software selection and IT implementation), analysis of assets and liabilities, and capital and liquidity management.

Technical Excellence

• Internal Audit, IFC, ERM, Business Process Re-engineering

Qualification

• CA

Experience

• CA (Newly Qualified)

People with the ability to work in a collaborative manner to provide services across multiple client departments while following the commercial and legal requirements. You will need a practical approach to solving issues and complex problems with the ability to deliver insightful and practical solutions. We look for people who are agile, curious, mindful, and able to sustain positive energy, while being adaptable and creative in their approach.If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

Visa and Immigration - Strategic Visa and Immigration (V&I) Consultant (Manager) (Multiple Positions) (1656470), Ernst & Young U.S. LLP, Hoboken, NJ.

Full time employment, Monday – Friday, 40 hours per week, 8:30 am – 5:30 pm.

MINIMUM REQUIREMENTS:

Must have Bachelor’s degree in Business, Human Resources, Law, Criminal Justice or a related field, plus 7 years of related work experience (of which at least 5 years must be progressive, post-baccalaureate) related work experience.Alternatively, will accept Master’s degree in Business, Human Resources, Law, Criminal Justice or a related field, plus 6 years of related work experience.

Must have 6 years of combined experience working in U.S. mobility and/or U.S. immigration.

Must have 6 years of combined experience working in a U.S. immigration role, either within a corporation or in a law firm, supporting a foreign national population of 500 or more people.

Must have 6 years of experience advising on immigration policies and solutions to talent team, business leadership executives and foreign national populations.

Must have 6 years of combined experience providing solutions to business immigration matters relating to H-1B, L1, TN, E-3, J and H-1B1 visas.

Must have 6 years of combined experience providing solutions to business immigration matters relating to PERM and EB1 employment based green cards, and marriage based green card applications.

Must have 6 years of combined experience in Excel, Assignment Pro, and/or INSZoom.

Must have 5 years of experience tracking critical expiration dates to ensure continuous work authorization for foreign nationals.

Must have 2 years of experience mentoring junior team members, by coaching and providing on-the-job training.

Must have Global Mobility Speciality-T (GMST), Project Management Professional (PMP), Global Professional in Human Resource qualification from the HR Certification Institution, or SHRM-CP or SHRM-SCP qualification from the Society for Human Resource Management.

Employer will accept any suitable combination of education, training or experience.

What we offer

We offer a comprehensive compensation and benefits package where you’ll be rewarded based on yourperformance and recognized for the value you bring to the business. The base salary for this job is $156,645 per year. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options. Join us in our team-led and leader-enabled hybrid model. Our expectation is for most people in external, client serving roles to work together in person 40-60% of the time over the course of an engagement, project or year. Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.

: You’ll develop the mindset and skills to navigate whatever comes next.
: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
: We’ll give you the insights, coaching and confidence to be the leader the world needs.
: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.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.

This particular position at Ernst & Young in the United States requires the qualified candidate to be a "United States worker" as defined by the U.S. Department of Labor regulations at 20 CFR 656.3. You can review this definition at at the bottom of page 750. Please feel free to apply to other positions that do not require you to be a "U.S. worker".

Key responsibilities:

• Design and develop data extraction using PowerCenter.
• Design and develop data transformation, and loading (ETL) processes using IDMC
• Is aware of setting up of PowerCenter, PowerCenter navigator.
• Lead and contribute in design, coding, testing, and deployment of the migration engine.
• Oversee the development of ETL jobs, workflows, and mappings in IDMC.
• Lead a team of ETL developers, data engineers, and analysts.
• Work closely with business analysts, data architects, and database administrators.
• Provide technical mentorship and enforce best practices in ETL development.
• Monitor and tune Informatica workflows for high performance.
• Troubleshoot ETL job failures and data discrepancies.
• Maintain technical documentation for all migration processes.

Skills and Experience:

• Experience in handling structured and semi-structured data
• Should have 5-7 years of experience.
• Strong knowledge of Oracle, SQL Server, DB2 and IDMS (mainframe)
• Proficiency in SQL, PL/SQL, stored procedures, and performance tuning.
• Expertise with Informatica Cloud (IICS) and cloud data migration.
• Familiarity with DevOps practices and tools (e.g., CI/CD, Gitlab)
• Deep understanding of architectural principles, frameworks, and best practices
• Knowledge of database design and data modelling

Nice to Have:

• Banking domain knowledge (Core Banking).
• Familiarity with Data migration process in a banking implementation project.
• Experience with data masking, encryption, and security compliance.
• Knowledge of virtualization technologies and storage architectures.
• Familiarity with Agile methodology

Ideally, you’ll also have

• Client management skills

What we look for

• People with technical experience and enthusiasm to learn new things in this fast-moving environment

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

Summary of Technologies:

• ETL Tools: Informatica PowerCenter, Informatica IDMC
• Databases: Oracle, DB2, IDMS
• Programming Languages: PL/SQL, SQL
• Data Modeling and Documentation Tools: Standard data modeling tools, data flow tools
• Data Warehousing Technologies: Data warehouse architecture and design
• Performance Tuning Tools: Oracle Database tuning tools, SQL tuning tools

Roles 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 have

• Education: 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 have

• Client management skills

What we look for

• People with technical experience and enthusiasm to learn new things in this fast-moving environment

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

CNS - Risk - Process & Controls :

Financial Services Risk - helps clients in the financial sector to identify, manage and monitor the risks in their business. It is done through a transformative and agile approach including process and procedures, risk, data modeling and analytics, reporting to stakeholders and third parties, business requirements (for software selection and IT implementation), analysis of assets and liabilities, and capital and liquidity management.

Technical Excellence

• Assist seniors & managers in developing new methodologies and internal initiatives.
• Identity & internally escalate and potential red flags related to the engagement.
• Preparation of reports/deliverables/status updates/audit committee presentations.
• Demonstrate the ability to multi-task and manage multiple projects as directed by the managers. Handling data analytics - Access, ACL etc.
• Awareness of internal auditing standards issued by IIA and ICAI.
• Manage the engagement budgets and support superiors in developing marketing collaterals, business proposals and new solution/methodology development.
• Attention to detail and mentoring young interns and analysts within the practice.
• Identify and escalate potential business opportunities for the firm on existing client
• Is a client-facing role.

- 3 to 5 years experience

People with the ability to work in a collaborative manner to provide services across multiple client departments while following the commercial and legal requirements. You will need a practical approach to solving issues and complex problems with the ability to deliver insightful and practical solutions. We look for people who are agile, curious, mindful, and able to sustain positive energy, while being adaptable and creative in their approach.If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.