Informatica Training in Pune

Start, Upskill, or Advance your career with Pune’s most trusted ISO 9001:2015 software training institute.

In Association with

IIT Guwahati

Credential Platform Partner

Wipro
5/5
Google
5/5
Total 8K+ Ratings
Ethan's Facebook Rating
Ethans's Google Reviews
Total 8K+ Ratings
DOWNLOAD BROCHURE

Get Free Career Counseling

One of our advisor will call you in less than 45 minutes*

Industry Oriented Curriculum

30 + Case Studies & Projects
Languages & Tools
120+ Live Sessions

Informatica Training in Pune

Our Informatica Training Program is expected to take two months with a total of 16 classes, each class is having three-four hours training. Its majoring covers: Introduction of Informatica, Services provided by Informatica, Introduction to Router and Joiner, Normalizer transformation, Workflow Structure and configuration, Normal and Bulk Load, Session and Email Task, Debugger, Session and Email Task, Concurrent and sequential Workflows, Overview of System Environment.
Lectures: 8 Weekends | Duration: 48 hours | Mode of Training: Classroom & Online
Register to confirm your seat. Limited seats are available.
DOWNLOAD CURRICULUM

Syllabus

Informatica Training Course in Pune

Module 1 - Introduction of Informatica

  • Advantages of Informatica compared with different coding technologies.
  • What is ETL?
  • Informatica Architecture.
  • Informatica Components i.e. Server, Client, Server Components
  • Informatica Installation.
  • Basics of Unix Commands.
  • Basic Unix Shell scripting.
  • Basics of Data warehouse training.
  • Data Mart and Data Modeling.
  • Star Schema and SnowFlake Schema.
  • Types of Facts and Fact Tables.
  • Types of Dimensions

Module 2 - Services provided by Informatica

  • Integration Service.
  • Repository Service.
  • Reader & Writer DTM.
  • Designer
  • Workflow Manager.
  • Monitor
  • Repository Manager.
  • Transformations

Module 3 - Introduction to Router and Joiner

  • Router and Joiner
  • Expression Transformation
  • Rank Transformation
  • Sorter Transformation
  • Aggregator Transformation
  • Lookup Transformation
  • Union T/F

Module 4 - Normalizer transformation

  • Update strategy.
  • Sequence Generator transformation.
  • Transaction control.
  • SQL Transformation.
  • Non reusable transformations.
  • Reusable transformations.
  • Power center workflow manager

Module 5 - Workflow Tools

  • Workflow Structure and configuration
  • Workflow Tasks.
  • Workflow Design and properties.
  • Advanced topics

Module 6 - Normal Load & Bulk Load

  • Incremental Load.
  • CBL Loading.
  • Target Load Ordering.
  • Dynamic Lookups.
  • SCD types, 1,2,3.
  • Mapplets & Worklets.
  • Limitations of Mapplets.
  • Pushdown Optimization.
  • Unit Testing.
  • Export and import of objects

Module 7 - Debugger

  • Versioning
  • Parameters & variables
  • Enable Test load
  • Commit Types
  • Over View PMCMD & PMREP Commands
  • Pre SQL and Post SQL
  • Target Override
  • PC workflow tasks

Module 8 - Session and Email Task

  • Command task
  • Control Task
  • Timer Task
  • Worklet
  • Decision Task
  • Event Wait
  • Event Raise
  • Assignment task
  • Link Conditions

Module 9 - Concurrent and sequential Workflows

  • Concurrent Workflows.
  • Sequential Workflows.
  • Stopping, Starting and suspending tasks and workflows
  • Scheduling of workflows.
  • Performance Tuning

Module 10 - Overview of System Environment

  • Identifying Bottlenecks .
  • Source Level
  • Target Level
  • Mapping Level
  • Database level
  • Data Warehouse Concepts

Features

Classroom Sessions

Ethans Pune offers highly professional and advanced training as per the industry need with a special focus on 100% practical and project based program, interactive sessions with Individual focus, online doubt clearing sessions, backup online recorded session, forum access for doubts and questions

Flexi Pass

Eight months free rejoining option within the same branch and same trainer from date of joining. Option available for branch change with minimum charges according to institute’s norms. Special discounts on joining multiple courses and referral bonus can also be availed. Lifetime WhatsApp technical discussion/placement group access.

Assignments

Hands-on assignments on each topic and modules, trainers provide these assignments according to the student's skill set and project requirements. Assignment duration will be approximately an hour a day. Assignment focuses on real time companies projects. Complementary Study Material with every course.

Certification

We are ISO 9001:2015 certified institution. Our certificate is recognized by many top companies. The certificate is provided on an assessment by our industry experts which makes your curriculum vitae, a holistic one and marks an edge on your profile. Increase the weightage of your resume by obtaining a course completion certificate on successful completion of the course and projects.

Real-life Case Studies

Ethans provides multiple use cases on real time projects. It helps students to understand the business requirements, analysis of requirements and challenges on real time implementation. We make them industry ready.

Job Assistance Program

On successfully completing a course with Ethans, you could be eligible for a job assistance program. Under this program we help students to build a perfect resume and optimize online profiles for job calls. Alumni group of 5000+ students help share the opportunities. 3000+ freshers/professionals received jobs in top companies in India or across India with good salary packages.

Informatica Training Course FAQs

What are the prerequisites for Informatica Training?

Informatica doesn’t require any prerequisites. Program starts from the scratch and contains basic foundation concepts at the start.

Who should go for Informatica training?

Informatica is strictly for those who have project requirements, this technology is almost obsolete from the market and not recommended for new skills addition.

What if I have queries after I complete this course?

You will have access to the technical discussion forum lifetime, which will help you in resolving most of your doubts and queries. Eventually, you can connect with your respective faculty directly, else reach out to the nearest Ethans help desk for further assistance.

Who are the instructors?

Our faculties are all extensively experienced IT Industry experts and real time corporate trainers from renowned MNC’s with marvelous knowledge in the subject matter. In addition to their standard duties of imparting knowledge, faculties also undertake consulting assignments for leading Indian and Multinational Companies that gives practical exposure based on real time scenarios from their world of experience. Ethanians that upskill are able to vividly recall classes even after years. Such is the impact of our remarkable trainers on the students.

Will Ethans be providing any study materials?

Yes, Ofcourse. You will be provided with both, hard copies of the study material upon enrollment and soft copies will be shared by the respective faculties over the cloud during the program.

What types of courses are available at Ethans?

Ethans is a Market leader in Cloud, Automation and Analytics (such as Python, Data Science – Machine Learning, Artificial Intelligence, AWS, Azure, GCP, DevOps, Hadoop, Selenium, Robotics Process Automation, etc.) helps working professionals and freshers in enhancing skills in multiple technologies as per the market demand.

Does Ethans provide Job Assistance?

Yes. Ethans being one of the top notch institutes, has a wide network in the market. We do have collaboration with multiple companies that helped 3000+ freshers to get place and working professionals to switch their domains in top companies across India. On course completion, one becomes eligible for the placement assistance.

Does Ethans provide weekend classes for professionals?

There are multiple institutes which are providing software training courses, but only Ethans offers professional training on various demanding technologies with flexible timings over the weekdays as well as on weekends depending on the requirements of working professionals.

What are the profiles and experiences of trainers at Ethans?

We have a big pool with a strong and renowned team of professionals having extensive expertise in the technology they deliver. Our trainers are quite supportive and render an amicable learning environment which invigorates the student’s growth in an optimistic way. They are all with huge industry and teaching experiences. Some of them hold more than two decades of experience of the same industry.

Do I need to pay the complete fee lump sum or I can have an installment facility too?

We are open for both, lump sum and installments. Best to pay it in one go, but we avail maximum two installments. First installment is to be cleared on the very first day of the class and the second one, within 21 days from the batch commencement date.

The fee which I will pay is refundable or transferable?

No. Fees once paid is non-refundable and non-transferable at any case, as we assure best training quality at Ethans Tech. We do not let go of any of our valuable students and ensure to deliver the quality that meets one’s requirements and is worth it. Each one of you is important to us.

Does Ethans provide free Demo classes before joining a course?

Yes, Obviously. It’s mandatory and your right to know everything regarding our institute before enrolling. We keep on conducting multiple free demo sessions on numerous technologies every week at all the respective branches of Ethans. It gives you awareness, knowledge, makes things crystal clear and also helps one to decide upon the technology he/she wishes to opt for.

What are the facilities and infrastructure at Ethans?

As of now, Ethans has presence at three locations in Pune (Pimple Saudagar/Kharadi/Baner) and in Noida as well. Looking forward to expanding gradually across India with all your support. Ethans has state-of-the-art-infrastructure that accelerates a pleasant and academically vigorous and stimulating environment for the students and the faculty.

Does Ethans provide Online Training?

Yes. Ethans renders Online training too. It’s a virtual and absolutely interactive training by the identical faculties that educate at our different branches with the help of a specific software which is best to intercommunicate online. You will be obtaining uniformly the same study material and assessment in online training as in the classroom. Educating yourself from Ethans Tech either by classroom or online means is the same, as the instructors don’t change. Now, it depends on the students, which mode to prefer based on their comfort levels.

Does Ethans provide facility to repeat the batch?

On enrollment at Ethan’s Tech, you are provided with a flexi pass that avails eight months free re-joining option within the same branch and under the same trainer from the date of enrollment. We also provide online recorded sessions as backups. Options available for branch change with nominal charges as per the norms and regulations of the institute.

Does Ethans provide Institutional Certification after the course?

Yes. Certificate is issued to the respective student, after the course completion and assessment which is valid in multiple companies and apparently, it becomes an edge in your curriculum vitae in order to showcase your skill set.

Does Ethan's conduct training at Corporates?

Yes, we are frequently engaged in corporate training being the market leader with a big pool of corporate trainers having a wide network with collaboration with several top MNC’S that ultimately becomes an add-on for placing our students with such references.

What is the admission procedure at Ethans?

Basically, there are two ways of registering with Ethans Tech, Online and Offline. In terms of Online, you just need to visit the enrollment tab on your website – www.ethans.co.in which will redirect you to the enrollment form, wherein you need to fill all your essential details and proceed further by paying Rs. 2000/- as the registration fees (inclusive of your standard course fees) For Offline admission, you can can contact and visit any of your nearest Ethans branch and carry out the further formalities under the guidance of the team at Ethans Desk.

 

Looking for Industry Expert Counseling?

We are a team of 10+ Years of Industry Experienced Trainers, who conduct the training with real-time scenarios. The Global Certified Trainers are Excellent in knowledge and highly professionals. The Trainers follow the Project-Based Learning Method in the Interactive sessions.

Related Courses

Lectures: 8 Weekends Duration: 48 hours

Our Sharepoint Training Program is expected to take two months with a total of 16 classes, each class is having…

Lectures: 8 Weekends Duration: 48 hours

Our UFT Training Program is expected to take two months with a total of 16 classes, each class is having…

Unix Shell Scripting Training in Pune

Lectures: 5-6 Weekends Duration: 30-35 hours

Our Unix Shell Scripting Training Program is expected to take five weeks with a total of 10-12 classes, each class…

Informatica Training Locations

Our Testimonials

Hi, it was a great and quality experience to get upskilled in Python from Ethans Tech. The program is well designed and the trainer was highly experienced and good at presenting the concepts clearly by presenting real-time scenarios. The Admin team is very helpful and they are always available whenever you need any help regarding coding or the software. Therefore, I would highly recommend Ethans Tech.

    Renuka Gudela Palteru
    Renuka Gudela Palteru

    Sr. Team Manager at Gallagher

    The courses are premium and great commandments. Instructors are always there to clear the queries and prompt you when you open an issue if you are having any trouble. Added bonus - you get the software, study material, and certification of the course you opt for! I have enrolled in so many courses and they always offer the best course each and every time I enrolled. Love these guys. Salute to their service !!

      Upender Negi
      Upender Negi

      Network Design Specialist at BT, UK

      The training is really marvelous and we are about to start a POC that would really help us in implementing the real-time scenarios. Overall the session is good and interactive. Thanks for all the classes organized. I am immensely satisfied with the course content, they offered pre-recorded classes and 8 months of post-class assistance from experts. I exceptionally recommend Ethans Tech, as it’s the best for corporate leanings and all cutting-edge technologies/tools/languages.

        Priyanka Tomar
        Priyanka Tomar

        Consultant at Credit Suisse

        I am a last-year College student and my keen Interest is in Cloud Technology, In Feb’20 - Joined the Amazon courses training program from Ethans which gave me 100% Practical Hand-on training along with covered the Programming languages, Big Data Hadoop, AWS, Azure, SQL DataBase which help me to get prepared for Internship and Job. One of the best Institutes!

          Gayatri Soni
          Gayatri Soni

          Intern at Ethans Tech

          Classroom sessions were delightful. Don't have a command of Linux and Python, and because of that feeling of lagging somewhere, would have more wonderful learning, if I had a command of those languages. Overall experience is superior for learning.

            Md Ashraf Khan
            Md Ashraf Khan

            Technical Service Engineer Expert, Fujitsu

            It was a great learning experience from Ethan's teaching Skills are pitched perfectly. The trainers were well Experienced and motivational. They always make sure that each and every student should be crystal clear with every topic, and they are always ready to help, this is what helps them offer the best service to their students. Thanks, a bunch of Ethans for developing my interest in coding.

              Anhadpreet Singh
              Anhadpreet Singh

              Student at Guru Nanak Dev Engineering College, Ludhiana

              Ethans in Media

              Start up

              Start-ups tap training needs of techies

              Ethans Tech, a Pune-based start-up that provides training to software engineers, has seen a three-fold...

              Is AWS Good for Beginners

              Is AWS good for beginners?

              Amazon Web Services is the acronym AWS. It is an industry leader in Platform as a Service (PaaS)…

              × How can I help you?