Transcription
InventateqADVANCEDINFORMATICA ETLCOURSE CURRICULUMYOUR JOB HUNTING ENDS HEREStart your career with Informatica ETL Course that getsYour dream job!E-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR1
Become a ExpertIn Informatica ETLIt is only skills and not degree that can help you grow. But if you are one of thoseindividuals who believe in getting certified along with skills then we have got youcovered. After completion of the training not only will you become an expert in InInformaticaInventateqIndustry Recognized INVENTATEQ CertificateE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR2
GET TRAININDAND InventateqGE T EMPLOYEDCLASS ROOM TRAININGONLINE TRAININGCORPORATE TRAINING11,409 Trainees500 Batches4.9/5RatingsE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR3
11,409 Success StoriesHere is what they say about INVENTATEQ.I was working in Mainframes domain since 4 yrs. and now Iwant to switch my technology to Data Warehousing and then Istarted searching for best institutes in google, I got Inventateqand joined the course and my trainer was Kumar, he is asuperb trainer with rich experience in informatica tool. Aspromised, they provided Career Oriented Training on ETL Toolwhich has helped me to switch my JOB. Thanks to InventaTeqand FacultyAMITCHOUDARYI liked the trainer and his in-depth knowledge aboutInformatica course curriculum and he is a real time workingprofessional. It's affordable, pay via card or cash payment. Ican say it's a well-known training with wide topics coverage. Ican suggest it to my friends and colleagues as well.CHANDRA SEKARInventateqI attended Informatica ETL Course in Inventateq institute. Thefacilitation and support are excellent. Instructor has in-depthknowledge on the subject. They have provided practical andprofessional materiel is very useful while I am practicing onproject work.ASWIN KUMARExcellent trainer for Informatica and a thorough practicalbased teaching. You will be completely satisfied with the wayof teaching and explanation, that is my guarantee. Thanks,Inventateq for the great coaching with job-oriented conceptsand affordable fee.SHALINI SHAIKE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR4
12,409 Success StoriesHere is what they say about INVENTATEQ.It was highly informative and Hands on learning experience.I learned many basics to advanced concepts in detail. Thecourse content was thorough and almost all the topics werecovered by trainer KUMAR Sir. Overall, it was a greatexperience with Inventateq.ASWINI NI don't recommend it to everyone but those who are seriousto learn informatica ETL tool, it is highly recommendable andtry to make it interactive, ask him more questions. Trainerhas ample experience and knowledge, he will surely clear allyour doubts. I utilized my opportunity by attending regularlyand taking more assistance from the trainer and yes, KumarSir is the best trainer for informatica.PRIYANKAInventateqInventateq is Best institute for Informatica course inBangalore. Affordable fee and punctual trainer. I can say gofor it if you are expecting a best informatica ETL Training InBangalore.SANJEEV ANANDI have been trained on Informatica ETL Course here. I willdefinitely recommend joining for the course as trainer hasgot great skills and abundant knowledge on the concepts.Thanks to INVENTATEQ for the support. Amazing place tolearn .JAGADEESHE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR5
Training entateqATTEND INTERVIEWRESUME PREPARATTIONYOU GOT THE JOB!E-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR6
01DATA WAREHOUSING1.What is Data warehouse?2.Characteristics of Data warehouse.3.What is Data warehousing?4.Principles of Data warehouse.5.Benefits of DWH.6.What is Online transactional systems (OLTP)?7.Difference between OLTP and DWH.8.Architecture of DWH.9.Approaches of Data warehousing.10.DWH Lifecycle:11.Data Modeling12.Dimension table13.Fact Table14.Schemas15.Star schema16.Snowflake schema17.Fact less Fact18.Confirmed Dimension19.ODS20.Cube21.Hierarchies22.Slowly changing Dimension Concepts23.OLAP’sInventateqE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR7
02INFORMATICA1.Introduction to Informatica2.Products of Informatica (Installation of Informatica)3.Configuring Informatica4.Configuring Informatica Repository Server5.Informatica Architecture6.Informatica Client Tools7.Designer (Components)8.Source Analyzer9.Workflow Manager (Components)Inventateq10. Workflow Monitor11. Repository Manager12. Repository Server Admin Console13. Informatica Server Tools14. Repository Server15. Server16. Transformations17. Source Qualifier18. Filter19. Expression20. Aggregator21. Joiner22. RouterE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR8
23. Rank23. Sorter24. Sequence Generator25. Union27. Xml Source Qualifier28. Lookup (Connected/Unconnected)29. Stored Procedure (Connected/Unconnected)30. Update Strategy31. Transaction Control32. Normalizer33. Mapplet Input34. Mapplet Output35. ConceptsInventateq36. SQL Override37. Working with files (Sources, Target)38. File Repository Concept39. Constrained Based Loading40. Parameters41. Mapping Parameters42. Mapping Variables43. Session Parameters44. Incremental Aggregator45. Application Source Qualifier46. Debugging47. Slowly Changing Dimension2 Implementation48. Target Load planE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR9
03. Data Warehousing Concepts Data Warehouse Concepts, Design. Need of Data Warehouse. Introduction to OLTP, ETL and OLAP Systems. Data Warehousing Architecture. Dimensional Modeling. Data Marts and ODS. Star Schema and Snowflake Schema. SCD (slowly changing dimension). Types of Fact and Dimension Tables. FAQ’sInventateq04. Oracle Concepts Introduction to Oracle. Basic Concepts in SQL. Data Types. Select statement usage. Joins. Sub Queries. Performance Tuning Tips & Tricks. FAQ’SE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR10
05. ETL Testing Introduction Introduction to ETL. ETL Architecture. What is use of testing. What is quality & standards. Responsibilities of a ETL Tester. DataStage Architecture.Inventateq06. Software Development Life Cycle Waterfall model V-model Agile model & methodologyE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR11
07. Testing Methodologies Whitebox testing. Blackbox testing. Regression Testing. ETL Testing Work Flow Process. How to Prepare the ETL Test Plan. How to design the Test cases in ETL Testing. How to reporting the Bugs in ETL Testing. ETL Testing Responsibilities. How to detect the bugs through database queries. ETL Performing Testing & Performing Tuning.08. Other AdvantagesInventateq Real-time Scenarios. Deployment Process. Project Experience. Resume Preparation. Mock Interviews. FAQ’s. Job AssistanceE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR12
OUR HIRING PARTNERED COMPANIES LISTInventateqE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR13
POPULAR COURSES FROMINVENTATEQ100% JOB ORIENTED TRAINING COURSES WE PROVIDE Digital Marketing BigData Hadoop Course(SEO/Social Media/PPCGoogle Adwords) Software Testing Course,Manual Testing, QTP, UFT,Loadrunner Best SEO Training Spark and Scala Course Block Chain Training Courses AWS Training DevOps Training Artificial Intelligence Courses Cloud Computing Training Angularjs and Node JS Tally ERP & GST Accounting Data Science CoursesTraining Weblogic Trainingclasses Java course RPA Training .NET Technologies Machine Learning CertificationTraining Internet of Things IoTTraining Microsoft Azure Training SOA Suite 11g C C CourseInventateq Oracle DBA Training Tableau Oracle SQL, PLSQL, DBA, PHP MYSQL, PythonInformatica Selenium TrainingD2k, Apps ETL Testing Course Human Resources Classes IBM Cognos 10 BI & PPC Training Institute Microstartegy Course Autodesk Revit Training Cisco CCNA Networking Autodesk CAD 2d and 3d SAS Training Learn ODI 11gCourse Catia Training Softskill Courses Python Training Wiring Harness Training ITIL Certificate Training Abinitio Classes Content Writing Training SAP Courses Web Designing Course Siebel CRM Courses OBIEE Data Warehousing -Cognos TM1 Qlikview (Deisgner,Developer, Publisher,Server) IBM Websphere Data Stage Classes Clear Case TrainingE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR14
6 CENTERS AND COUNTINGBTM LAYOUT#687, 1st Floor, 29th Main, 3rd Cross,Coming from Silkboard, take left at AXAcompany signal, opp to OI Play school,Bangalore, Karnataka.Call us : 080 - 42108236Mail Us: inventateq.btm@gmail.comJAYA NAGARNo. 16, 2nd Floor, 11th Main Road,Jayanagar 4th 'T' Block,Next to Jayanagar Head Post-office,Bangalore – 41.Call us: 080 - 41502315Mail Us:inventateq.jayanagar1@gmail.comKALYAN NAGARNo. 509, 4th Main, Kammanahalli Main Rd,HRBR Layout 3rd Block, HRBR Layout,Kalyan Nagar, Bengaluru, Karnataka 560043Near McDonald's, Opposite to Petrol Bankand AptechBangalore, Karnataka 560043.Call us 91-6366644707Mail Us: inventateq.kalyannagar@gmail.comMARATHALLINo.43, 3rd Floor, Marathahalli, from OldBrand Factory towards Old Airport,Nextto Axis Bank,Bangalore, KarnatakaCall us: 080 - 42024661Mail Us:inventateqq.marathahalli@gmail.comRAJAJI NAGARNo. 18, 2nd Floor, Mahakavi KuvempuRd, near Navrang Theatre Road, Oppositeto Nethradhama Hospital MKK Road, 1stBlock, Rajajinagar, Bengaluru,KA-560010.Call us 080 - 41713019Mail y main road, No 2, 11th MainRoad, G1 Es El En Manasarover, Vijayanagar Opposite to Grand Mall, NearChennai Silks, Next to VenkateswaraSuper Market, VELACHERY, Chennai,Tamilnadu-600042Call us 91-9840021877 044-43324939Mail Us: inventateq.chennai@gmail.comE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR
IT ISTIMEYOU GETSTARTEDWITH FREEInventateqDEMO CLASSESwww.inventateq.com76-76-76-5421Weekdays Batches,Weekend Batchesinfo@inventateq.comE-MAIL: info@inventateq.com CALL: 7676765421 BTM MARATHAHLLI JAYANAGAR RAJAJI NAGAR16
3. Configuring Informatica 4. Configuring Informatica Repository Server 5. Informatica Architecture 6. Informatica Client Tools 7. Designer (Components) 8. Source Analyzer 9. Workflow Manager (Components) 10. Workflow Monitor 11. Repository Manager 12. Repository Server Admin Console 13. Informatica
