Senior Consultant Ab Initio

Year    KA, IN, India

Job Description

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

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD3827258
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    KA, IN, India
  • Education
    Not mentioned
  • Experience
    Year