Srinivas Uttaravilli

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

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

✕

x

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

ETL Testing Training

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in ETL Testing Training

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?

Contact

Gallery (2)

Training room at my institute

OUR RECENT PLACEMENTS ON ETL T...

Documents (1)

Reviews

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

No Reviews yet! Be the first one to Review

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.