ETL Testing with Informatica and Datastage
Ethans Tech is the market leader in Automation vertical and we assist working professionals testing tools to work on automation. We provide ETL testing training on weekdays and weekends from industry experts. Our course includes basic to advanced levels of Informatica, Linux, SQL, Data warehousing and Data Stage. Ethans Tech is a leading institute in Pune who help students to become Automation experts using Informatica.
ETL Testing Training Course in Pune
- Informatica Installation.
- Basics of Data warehouse training.
- Data Mart and Data Modeling.
- Star Schema and SnowFlake Schema.
- Types of Facts and Fact Tables.
- Types of Dimensions.
- Basics of Unix Commands.
- Basic Unix Shell scripting.
- Basics of SQL .
- Basic of open source database.
- Basic Concepts In Sql (Select, Update, Insert and Delete)
- What are the similarities between ETL tools and SQL
- Why to use ETL Tools and SQL together?
- Introduction to ETL and DW Concepts:
- What is Data Warehousing?
- Differences between OLTP and Data Warehousing
- Why we need two separate solution for real time and warehousing
- Data Acquisition
- DATA EXTRACTION
- How to extract data from several sources and load into same target table
- DATA TRANSFORMATION
- How to perform transformation logics on data
- DATA LOADING
- How to load data into final target table
- Data Marts
- Need and usage of data marts and types of data marts
- Dependent DM
- Independent DM
- DATA WAREHOUSING LIFE CYCLE
- Types of Tables:
- Fact Table
- Dimension table
- Star Schema
- Snowflake Schema
- Fact Constellation Schema
- SCD ( Slowly Changing Dimensions )
- Different types of SCD’s which developer develops and a tester has to test as per different types of data needs of clients
- Practical exercises on SCD
- TYPE1 SCD
- TYPE2 SCD
- TYPE3 SCD
- ETL Tool Implementation and Testing Concepts:
- How to design frequently used testing queries to validate the data in source and target for both of the reasons Data Quality and Correctness to ensure that expected data came into the final and mediator target tables or not.
- Overview Of Etl Tool Architecture
- How ETL tool works and what is the basic need of ETL tools in the market
- How ETL Tools work at back end
- Different ETL Tools in the market
- What types of tasks tester performs on ETL for testing purpose
- Informatica PowerCenter (Leading tool in the market)
- Coding and testing process in different transformation rules:
- SAMPLE Loading from source to target
- SORTER Transformation
- FILTER Transformation
- EXPRESSION Transformation
- JOINER Transformation
- UNION Transformation
- AGGREGATOR Transformation
- SEQUENCE GENERATOR Transformation
- SQL Transformation
- Testing Techniques in ETL
- MINUS Query
- COUNT Query
- UNION Query
- JOIN Query
- Informatica PowerCenter
- How developers work on PowerCenter
- Different components of PowerCenter
- Tasks developed in different components
- Data Stage
- What is Datastage
- Differences between Informatica PowerCenter and DataStage
- Components of DataStage
- Differences between ETL development process in Informatica and DataStage
ETL Testing Training Course Features
Ethans Pune offers highly professional and advanced training as per the industry need with a special focus on100% practical and project based program, interactive sessions with Individual focus, online doubt clearing sessions, backup online recorded session, forum access for doubts and questions
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.
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.
We are ISO 9001:2015 certified. Our certificate is recognised in many top companies. Increase the weightage of your resume by obtaining a course completion certificate on successful completion of the course and practical based 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.
ETL Testing Training Course FAQs
To have a basic understanding of the Data Warehousing concept and Database will be appreciated. If not, you should not worry, the program starts from the scratch and contains basic foundation concepts at the start.
If you are a technology lover, go for this course! Anyone can learn it out of interest. This technology is all about Automation in Informatica and DataStage. Whoever wants to find the insight of the data can learn this tool.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Sorry. Although we have crowds coming from different states, we don’t have any such hostel or PG facility as of now, but yes, we help them in finding one for themselves near the institute as there are many good options available that a student can choose as per his/her convenience and reside comfortably.
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.
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.
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.
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.
What our students
have to say
I have been an Ethan’s happy customer . I have enrolled ethans for Hadoop training, Python training and DevOps Certification Training. I highly recommend ethan’s to my friends.
Thanks for the assistance and support provided by ethan’s. The only word for training is “Awesome”. The excellent post class support and training methodology are icing on the cake.
The best thing about the classes is trainer always teach with day to day examples making the learning easy for conceptual understanding. Trainer are highly interactive and really connects with each and every individual during sessions. Really a good job by ethans to have such trainer at single place.
we are also
Ethans Tech – Wakad
Office 304, 305 Pride Purple Square, Above Maharashtra Electronics Kalewadi Phata - Wakad Pimpri-Chinchwad, Maharashtra 411057
Ethans Tech – Kharadi
Office 101, Below Hotel Classic Residency, next to Shell Petrol Pump, Durvankur Society Rakshak Nagar, Kharadi, Pune, Maharashtra 411014
Ethans Tech – Baner
Office No.: 3B, 3rd floor, Vasuda House, Near COSMOS Bank, Baner, Pune, Maharashtra