Senior Consultant- Ab Initio

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 AI and Data offering 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. The portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets.

AI and Data professionals 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 Senior 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 schemas/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.