EH-FY26-Consulting-AI & Data-Consultant- Ab Initio

Strategy & Analytics

Strategy

Our Strategy practice brings together several key capabilities that will allow us to architect integrated programs that transform our clients’ businesses, including Corporate & Business Unit Strategy, Technology Strategy & Insights, Enterprise Model Design, Enterprise Cloud Strategy and Business Transformation.

Strategy professionals will serve as trusted advisors to our clients, working with them to make clear data-driven choices about where to play and how to win, in order to drive growth and enterprise value.

Strategy will help our clients:

• Identify strategies for growth and value creation
• Develop the appropriate business models, operating models, and capabilities to support their strategic vision
• Maximize the ROI on technology investments and leverage technology and Cloud trends to architect future business strategies

AI&Data

In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment.

The Analytics & Cognitive team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. Together with the Strategy practice, our Strategy & Analytics portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets.

Analytics & Cognitive will work with our clients to:

• Implement large-scale data ecosystems including data management, governance and the integration of structured and unstructured data to generate insights leveraging cloud-based platforms
• Leverage automation, cognitive and science-based techniques to manage data, predict scenarios and prescribe actions
• Drive operational efficiency by maintaining their data ecosystems, sourcing analytics expertise and providing As-a-Service offerings for continuous insights and improvements

Abinitio Consultant

The position is suited for individuals who have demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.

Education and Experience

• Education: B.Tech/M.Tech/MCA/MS/MBA
• 6-9 years of experience in design and implementation of database migration and integration solutions for any Data warehousing project.

Required Skills

• Good knowledge of DBMS concepts, SQL, and PL/SQL.
• Good knowledge of Snowflake system Hierarchy.
• Good knowledge of Snowflake schema’s/tables/views/stages etc.
• Should have Strong hands-on experience with ABINITIO development.
• Should have strong problem solving and analytical capabilities.
• Should have hands-on experience in the following: data validation, writing custom SQL code, managing the Snowflake account /users/roles and privileges.
• Should have experience in integrating using Abinitio with Snowflake, AWS S3 bucket
• Should have experience in integrating any BI tool like Tableau, Power BI with Snowflake.
• Should have experience in fine tuning and troubleshooting performance issues.
• Should be well versed with understanding of design documents like HLD, LLD etc.
• Should be well versed with Data migration and integration concepts.
• Should be self-starter in solution implementation with inputs from design documents
• Should have participated in different kinds of testing like Unit Testing, System Testing, User Acceptance Testing, etc.
• Should have hands-on development experience with various Ab Initio components such as Rollup, Scan, j join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, etc.
• Good knowledge on Designs, codes, tests, debug and document software and enhance existing components to ensure that software meets business needs.
• Should have participated in Preparing design document for any new development or enhancement of the data mart
• Constant communication and follow up with stakeholder.
• Good knowledge in developing UNIX scripts.
• Should have hands-on Different databases like Teradata, SQL Server.
• Should have experience on Autosys.
• Experience in all aspects of Agile SDLC, and end to end participation in a project lifecycle

Preferred Skills

• Exposure to Data Modelling concepts is desirable.
• Exposure to advanced Snowflake features like Data sharing/Cloning/export and import is desirable.
• Participation in client interactions/meetings is desirable.
• Participation in code-tuning is desirable.
• Exposure to AWS platform is desirable.