UrbanPro
true

Overview

Expertise: Expert in ETL testing and working as an ETL Testing Professional for over eight years with CMMI Level 5 companies and topmost Clients offering the best of the best services to all significant clientele.
Transforming an individual into a complete ETL Testing Professional for 5 years by smart and in-depth practical training with a demonstration of the live environment and real-time examples.
People who are migrating from Manual Testing to ETL Testing can be a part of our specialised training that helps you to migrate to ETL Testing with ease and comfort.
PROFESSIONAL EXPERIENCE:
-Hands-on eight years real time experience in CMMI Level5 companies in ETL testing.
-Having five years of training experience in ETL Testing.
-Expertise in writing SQL queries using SQL Server, Oracle and Teradata databases.
-Having good experience in OLAP features.
-Ample exposure on Banking, Retail, Healthcare, OIL gas and Insurance Domain.
-Good Knowledge in Enterprise Data warehousing Concepts.
-Extensive work experience in writing Test plan, Test Cases, Defect Reporting & Test Summary Reports.
-Experienced in QC (Quality Center) & MTM (Microsoft Test Management) Test Management tool.
-Extensive work experience in Smoke Testing, System Testing and Regression Testing and User accepting testing.
-Has testing experience in Informatica Power Center and Data stage and AB Initio.

Intro Video

  • ETL , ETL Testing

Languages Spoken

Telugu

English

Education

JNTU Hyderabad 2007

Bachelor of Technology (B.Tech.)

Address

Kukatpally, Hyderabad, India - 500057

Verified Info

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.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Teaches

ETL Testing Training

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?

ETL Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in ETL Training

8

Documents (1)

Reviews

No Reviews yet!

FAQs

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.

Answers by Srinivas Uttaravilli (1)

Answered on 29/03/2016 Learn IT Courses

Data warehouse related technologies like INFORMATICA, DATA STAGE in software development and ETL Testing in software testing.
Answers 14 Comments
Dislike Bookmark

Teaches

ETL Testing Training

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?

ETL Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in ETL Training

8

No Reviews yet!

Answers by Srinivas Uttaravilli (1)

Answered on 29/03/2016 Learn IT Courses

Data warehouse related technologies like INFORMATICA, DATA STAGE in software development and ETL Testing in software testing.
Answers 14 Comments
Dislike Bookmark

Srinivas Uttaravilli describes himself as ETL Corporate Trainer. He conducts classes in ETL and ETL Testing. Srinivas is located in Kukatpally, Hyderabad. Srinivas takes Regular Classes- at his Home and Online Classes- via online medium. He has 8 years of teaching experience . Srinivas has completed Bachelor of Technology (B.Tech.) from JNTU Hyderabad in 2007. HeĀ is well versed in Telugu and English.

X
X

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*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more