Kukatpally, Hyderabad, India - 500057.
1
Details verified of Srinivas Uttaravilli✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
Intro Video
Telugu
English
JNTU Hyderabad 2007
Bachelor of Technology (B.Tech.)
Kukatpally, Hyderabad, India - 500057
Phone Verified
Email Verified
Report this Profile
Is this listing inaccurate or duplicate? Any other problem?
Please tell us about the problem and we will fix it.
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in ETL Testing Training
8
Teaching Experience in detail in ETL Testing Training
Started with providing Knowledge transformation to the new joinees and conducting Learning and Development training's on ETL Testing. I have been giving training(Internal/online/classroom) in ETL testing since 5 years. Sharing my knowledge and experiences. It keeps me learning new things every day. I would like to cover the following topics during my training in ETL Testing. Data warehousing concepts ************************************* - What is data, information and Database? - What is data ware house , architecture and advantages? - Why we need Data Warehouse? - Types of Data Warehouse? - What is the difference between Database and Data ware house? - What is Data mart and its types? - Differences between Data mart and Data Warehouse - Data Warehouse Top-Down and Bottom-up implementation approaches? - Top -down vs Bottom -up approaches? -Data Warehouse Architecture? -ETL (Extraction Transformation Loading) approach with IT Standards - Over view on Data merging,Data cleansing,Data scrubbing Data Aggregation? - What is OLTP and OLAP? - Differences and Similarities between OLTP and OLAP? - What is Dimension and Fact tables and types? - What is Star Schema and Snowflake schema and differences? SQL Topics *************** - What is the data base and uses? - What is the table? - Data types and types? - DDL, DML and DCL comments with syntax? - what is PK and FK and relations between those? - What is surrogate key? - Aggregate functions with and with out group by? - All ORACLE Functions - All Joins(SELF, INNER,LEFT OUTER,RIGHT OUTER and FULL OUTER) - Union and Union- all - Rank() and Dense Rank() - CASE statement and DECODE QC Topics ************* -What is QC and advantages? - Different tabs in QC and in detail explanation -How we are capturing and executing test cases in QC? - How to import and Export results in QC - In detail explanation about Defect life cycle management in QC? - How we are storing test cases in Test plan and executing the same in Test lab? Unix ****** Basic useful Unix commends Best practices for ETL Tester in real time **************************************************** - What is Mapping and Design documents? - What is PDM( Physical data model) document? - How a ETL Tester starts his work on a Daily basis in real time? - What are the documents required to start testing? - What is Requirement and analysis phase? - What is Test plan and Test strategy and our inputs on the same? - What is Development and QA environment? differences? - How to finalize test scenarios and test cases and where to write and execute? - When to start testing and how to co ordinate with Development team during test execution to resolve the bugs/Defects? - what does a ETL tester do when a developer develops code? - What is Onshore/ offshore Model? - How would be the team structure? Onshore- Offshore communication Best practices *************************************************************** - What is status and stand up calls? - what is weekly connect call? - what is scrum plan and scrum meetings? SDLC( Software development Life cycle) Methodologies *********************************************************************** -Water Fall - V Model - Agile - Waterfall vs Vmodel vs Agile Resume preparation: ************************* - What are the ETL Tester roles and responsibilities? - What are ETL tools are being used - Domain knowledge Interview preparation ************************* - will provide concept wise martial with interview questions and answers - will conduct mock interviews( fact to face/Telephonic) - Tips to attempt telephonic/face to face interviews?
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in ETL Training
8
1. Which classes do you teach?
I teach ETL and ETL Testing Classes.
2. Do you provide a demo class?
Yes, I provide a free demo class.
3. How many years of experience do you have?
I have been teaching for 8 years.
Answered on 29/03/2016 Learn IT Courses
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in ETL Testing Training
8
Teaching Experience in detail in ETL Testing Training
Started with providing Knowledge transformation to the new joinees and conducting Learning and Development training's on ETL Testing. I have been giving training(Internal/online/classroom) in ETL testing since 5 years. Sharing my knowledge and experiences. It keeps me learning new things every day. I would like to cover the following topics during my training in ETL Testing. Data warehousing concepts ************************************* - What is data, information and Database? - What is data ware house , architecture and advantages? - Why we need Data Warehouse? - Types of Data Warehouse? - What is the difference between Database and Data ware house? - What is Data mart and its types? - Differences between Data mart and Data Warehouse - Data Warehouse Top-Down and Bottom-up implementation approaches? - Top -down vs Bottom -up approaches? -Data Warehouse Architecture? -ETL (Extraction Transformation Loading) approach with IT Standards - Over view on Data merging,Data cleansing,Data scrubbing Data Aggregation? - What is OLTP and OLAP? - Differences and Similarities between OLTP and OLAP? - What is Dimension and Fact tables and types? - What is Star Schema and Snowflake schema and differences? SQL Topics *************** - What is the data base and uses? - What is the table? - Data types and types? - DDL, DML and DCL comments with syntax? - what is PK and FK and relations between those? - What is surrogate key? - Aggregate functions with and with out group by? - All ORACLE Functions - All Joins(SELF, INNER,LEFT OUTER,RIGHT OUTER and FULL OUTER) - Union and Union- all - Rank() and Dense Rank() - CASE statement and DECODE QC Topics ************* -What is QC and advantages? - Different tabs in QC and in detail explanation -How we are capturing and executing test cases in QC? - How to import and Export results in QC - In detail explanation about Defect life cycle management in QC? - How we are storing test cases in Test plan and executing the same in Test lab? Unix ****** Basic useful Unix commends Best practices for ETL Tester in real time **************************************************** - What is Mapping and Design documents? - What is PDM( Physical data model) document? - How a ETL Tester starts his work on a Daily basis in real time? - What are the documents required to start testing? - What is Requirement and analysis phase? - What is Test plan and Test strategy and our inputs on the same? - What is Development and QA environment? differences? - How to finalize test scenarios and test cases and where to write and execute? - When to start testing and how to co ordinate with Development team during test execution to resolve the bugs/Defects? - what does a ETL tester do when a developer develops code? - What is Onshore/ offshore Model? - How would be the team structure? Onshore- Offshore communication Best practices *************************************************************** - What is status and stand up calls? - what is weekly connect call? - what is scrum plan and scrum meetings? SDLC( Software development Life cycle) Methodologies *********************************************************************** -Water Fall - V Model - Agile - Waterfall vs Vmodel vs Agile Resume preparation: ************************* - What are the ETL Tester roles and responsibilities? - What are ETL tools are being used - Domain knowledge Interview preparation ************************* - will provide concept wise martial with interview questions and answers - will conduct mock interviews( fact to face/Telephonic) - Tips to attempt telephonic/face to face interviews?
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in ETL Training
8
Answered on 29/03/2016 Learn IT Courses
Post your Learning Need
Let us shortlist and give the best tutors and institutes.
or
Send Enquiry to Srinivas Uttaravilli
Let Srinivas Uttaravilli know you are interested in their class
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.