- Home
- ETL Testing Training
ETL Testing Training
About the Courses
.NET (pronounced dot net) is a software framework developed by Microsoft primarily for Windows operating system. It contains two main components – Framework Class Library (FCL) and Common Language Runtime (CLR). FCL includes large class library which supports many other programming language codes to be run on .NET. FCL provides functions and classes for user interface, data access, database connectivity, cryptography, web application development, numeric algorithms, and network communications. CLR is the software environment like Virtual machine where all the programs written are executed. CLR provides services such as security, memory management, and exception handling. .NET framework led to different versions of .NET, each one specially designed for other platforms like embedded devices, web browser plugins and mobile computing. .Net Micro framework for embedded devices, Silverlight as web browser plugin and Mono for cross-platform and mobile devices. Microsoft developed a special integrated developed environment (IDE) for .NET called Visual Studio.
Why to enrol in .NET Training at Trishana Technologies, Bangalore?
Trishana Technologies is far ahead of all other training institutes in terms of placement, quality training, and infrastructure. We offer 100% placement assistance, state-of-the-art smart classrooms and lab, simple and precise training materials and leading experts in .NET as trainers. We offer three different .NET courses namely C#.NET course, ASP.NET course, and ADO.NET with each one concentrating on one of the popular technologies used in .NET. However, all the three courses cover the basics of .NET extensively including FCL, CLR, CTS and CLS. Our meticulously crafted syllabus and quality training materials will offer you extensive theoretical knowledge and our elaborate practice sessions will help you master programming skills. We will provide software support to all our students who want to practice at home. With our hard work and dedication, we have achieved great placement in all our previous batches and will continue to do so.
Key Features
Free
Live Demo
Hands on
Practicals/Project
One year
Course Validity
100%
Placement Assistance
Individual
Attention
24 X 7
Expert Support
Training from
Industrial Experts
Certification
for Course
Curriculum
DWH: Data Ware Housing Concepts
- What is Data Warehouse?
- Need of Data Warehouse
- Introduction to OLTP, ETL and OLAP Systems
- Difference between OLTP and OLAP
- Data Warehouse Architecture
- Data Marts
- ODS [Operational Data Store]
- Dimensional Modelling
- Difference between relation and dimensional modelling
- Star Schema and Snowflake Schema
- What is fact table
- What is Dimension table
- Normalization and De-Normalization
ETL Testing
- ETL architecture.
- What is ETL and importance of ETL testing
- How DWH ETL Testing is different from the Application Testing
- SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)
- Challenges in DWH ETL Testing compare to other testing
- Incompatible and duplicate data.
- Loss of data during ETL process.
- Testers have no privileges to execute ETL jobs by their own.
- Volume and complexity of data is very huge.
- Fault in business process and procedures.
- Trouble acquiring and building test data.
ETL Testing Work flow activities involved
- Analyze and interpret business requirements/ workflows to Create estimations
- Approve requirements and prepare the Test plan for the system testing
- Prepare the test cases with the help of design documents provided by the developer team
- Execute system testing and integration testing.
- Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
- How to detect the bugs in the ETL testing
- How to report the bugs in the ETL testing
- How to co-ordinate with developer team for resolving the defects
Types of ETL Testing
- Data completeness.
- Data transformation.
- Data quality.
- Performance and scalability.
- Integration testing.
- User-acceptance testing.
Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Power Center Admin Console
Informatica Concepts and Overview
- Informatica Architecture
Sources
- Working with relational Sources
- Working with Flat Files
Targets
- Working with Relational Targets
- Working with Flat file Targets
Transformations – Active and Passive Transformations
- Expression
- Lookup –Different types of lookup Caches
- Sequence Generator
- Filter
- Joiner
- Sorter
- Rank
- Router
- Aggregator
- Source Qualifier
- Update Strategy
- Normalizer
- Union
- Stored Procedure
- Slowly Changing Dimensio
- SCD Type1
- SCD Type2 — Date, Flag and Version
- SCD Type3
Workflow Manger
- Creating Reusable tasks
- Workflows, Worklets & Sessions
- Tasks
- Session
- Decision task
- Control Task
- Event wait task
- Timer task
Monitoring workflows and debugging errors
- Indirect Loading
- Constraint based load ordering
- Target Load plan
- Worklet ,Mapplet ,Reusable transformation
- Migration, ML migration and Folder Copy.
- Scheduling Workflow
- Parameter and variables
- XML Source, Target and Transformations
- Performance Tuning
- Pipeline Partition
- Dynamic Partition
- Pushdown optimization
- Preparation of Test Cases
- Executing Test case
- Preparing Sample data
- Data validation in Source and target
- Load and performance testing
- Unit testing Procedures.
- Error handling procedures.
Career opportunities in ETL Testing
- ETL Test Engineers
- ETL Testing Engineer for Informatica
- Big Data ETL Testing professionals
- Test specialist: Data management
- DWH Test Engineers
Request a Free Demo
Upcoming Batches
OCT 03 | Mon-Fri (45 Days) | FILLING FAST 7AM -11AM, 4PM - 9.30PM. |
OCT 01 | SAT-SUN (45 Days) | FILLING FAST 9AM to 1PM & 2PM to 9.30PM |
ETL Testing Certification
About more than 1000 top companies has recognized Trishana Technologies certifications globally.
Download the certificate once you,
- Complete our ETL Testing training program
- After successfully Completing the Realtime Industry projects
- Successful completion of given assignments
Certification images
Testimonials
vidya mohan
Trainer toufiq. took aws and devops for me. as a fresher devops topics are vast for me. but i gained good and clear knowledge from him. mock exam was really helping me to clear global certificate for aws .
Bangalore
- AWS and Devops Certified
Spandana Talluri
I done Python online classes under Jalavathi trainer. Training sessions was completely practical oriented, reasonable course fees and even more flexible timings too. She shared all the useful soft copies documents whenever i required. Thank u so much especially cleared my doubts whenever i asked to you. Such a nice management they coordinated very well!! Thanks Trishana technologies team!!!
Bangalore
- Python Certified
Swathi sri
I attended a couple of python demo class in some other institutes in Bangalore before knowing about Trishana Technologies but after i attended here i liked my trainer Kiran sir way of teaching, trainer experience ,amazing classroom infrastructures . Completely satisfied with all the things they assigned to me. Thank u so much for such a wonderful experience of learning. This is the best Python training institute in Bangalore.
Bangalore
- Python Certified
Malaika chinthan
Absolutely recommend Trishana technologies for Python training. Best Python Training in Bangalore. Course lasted close to 50 hours including good amount of time spent on application of theoretical knowledge. Trainer was able to clarify all the doubts and has in depth knowledge on Python and data science. Don't miss Trishana if you are looking to upskill in Python.
Bangalore
- Python Certified
Ajeet Joseph
Best AWS training in Bangalore. I can confidently say that Trishana Technologies provides the best Solutions Architect training in Bangalore. The course is designed with future needs and the syllabus is 80% job oriented with 20% emphasis on theory. Excellent place to become a certified solutions architect.
Bangalore
- AWS Certified
Vinod Kumar
I learned Python online course here. My training based on mostly hands on practical session. Thanks to Trishana Technologies for giving such opportunity to learn. I refer Trishana Technologies is the best Python online training institute in Bangalore.
Bangalore
- Python Certified
Ram Babu
I joined for aws online courses here.. My trainer is very experienced in teaching the concepts based on industrial oriented. Timings was so flexible and course fees was so reasonable. Thanks to my trainer and Trishana team.Surely, i can refer all my friends to join the aws course here!!
Bangalore
- AWS Certified
Mark cassie
I took python - online training here, trainer Jalavathi was very supportive. it helped me a lot to upgrade. its full of practical class..
Bangalore
- Python Certified
Preethi Sharma
It was such a nice experience by learning AWS course from trainer Raghu. He is a nice experienced person in teaching things and even more friendly while clearing the queries which i faced during and after the training as well. Soft copies, Interview tips and answers also provided during my training! Simply amazing infrastructure! This is the best AWS training institute in Bangalore!!
Bangalore
- AWS Certified
Karthik Raja
Best institute to learn selenium course in Bangalore. I did selenium course through online live classes. Instructor teaching was excellent which was very helpful for me to crack the interview. Thanks to trishana Technologies.
Bangalore
- Selenium Certified
Gimmy rathor
Best online classes for aws course. i took couple of demo. but not satisfied. trishana trainer toufiq is best tutor in delivering the content. with the great knowledge.
Bangalore
- AWS Certified
Sonali Banerji
I took python online training, services was good, and trainer kiran also has a good knowledge about python as well as a data science. most of the classes are test cases only. it really helped me. thank you
Bangalore
- Python Certified
Seethapathy Ranjith
Excellent institute to learn Python course in Bangalore. Had a pleasant experience right from the beginning. Training is practical and content is spread well over the two months.
Bangalore
- Python Certified
Anusha rani
Took data science course in trishana technologies, bala really helped me to choose the course as a fresher. trainer kiran sir taught me very well.
Bangalore
- Data Science Certified
Rohini setty
I take online class for data science bcoz of this covid situation. training was absolute fine and worthy, 2months 14k. thanks to trainer kiran and bala
Bangalore
- Data Science Certified
Model