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

Same job available in 7 locations

Bengaluru, Karnataka, India

Chennai, Tamil Nadu, India

Gurugram, Haryana, India

Hyderabad, Telangana, India

Kolkata, West Bengal, India

Mumbai, Maharashtra, India

Pune, Maharashtra, India

Back to search results
Back to search results

Position Summary

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.

 
Our purpose

Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. 
Our people and culture

Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work.
Professional development

At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse   learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India.
Benefits to help you thrive

At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you.
Recruiting tips

From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.

Requisition code: 300129