SREE GOUTHAM DWBI

INFORMATICA +

Provide training on informatica tool.
Explain real time scenarios and provide data to develop mappings.
Share knowledge on different projects like development, production, migration and upgradation.
Explain, how data flows from source to quebes/reports.
Explain mapping spec docs, requirement docs and naming standards.
Exapain about 3rd party schedulers control-m, auotsys, tws and how scripts will call informatica jobs.
Eole of unix scripting in informatica.
Explain production support project issues.
Explain development project cycle, development of mappings, testing/integration testing and code deployment.
Prepare you on interviews part as well(database, informatica tool, unix, tws/control-m).
Resume preparation.
Informatica installation free.

TABLEAU

Tableau desktop latest version.
Visualisation concepts.
Data warehousing concepts.
basic visualisations.
Advanced visualisation techniques.
Tableau server.
Examples for daily practice.
Resume preparation.
Interview preparation covering sql and data warehousing questions.
Scheduling report generation.
Tableau development life cycle and real time scenarios.

TERADATA

Best practices for writing and tuning Teradata SQL.
Explain Real time scenarios and issues faced during.
Explain how to perform ETL operations using Teradata utilities.
Share Knowledge on different kinds of projects like.
Development, Production, Migration.
Challenges faced during migrating data from one database(Like Sybase, Oracle etc) to Teradata. Explaing with examples..
Explain how different types of data flows from source to Target tables.
FSLDM and use of this modelling in Banking domain.
Teradata query analysis, performance tuning and testing including use of DBQL analysis and other performance indicators.
Role of UNIX scripting in invoking Teradata Utilities.
Explain real time production support issues.
Writing test scripts for testing an application with different scenarios.
Writing test scripts for testing an application with different scenarios.

MOBILE TESTING

Understanding the Android core framewor.k
Explaining iOS concepts and dependencies.
Mobile applications testing key areas learnings.
Adnroid SDK tools and their usages like monitor.bat, DDMS, uiautomatorviewer.
Brief understanding on Kernel level testing and collection of kernel logs.
Collection of logcat and filtering the logs.
Root cause analysis on Android and iOS apps issues using logcat and iOS logs.
Collecting crash logs iOS and Android.
Different approaches on testing Native, Hybrid and Web Applications.
Performance testing on application using third party tools like Charles Proxy, Wi-fi and cellular network throttling.

MOBILE AUTOMATION TESTING

Learnings on Appium selenium based mobile automation tool.
Understanding of Native Application and Hybrid Application automation.
Using Android SDK tools like UIAutomator.
Learning on creating the framework with live Android Application.
Getting knowledge on Touch Actions and Identifying elements within the application.
Finding the elements using XML viewer.
Working with live Android applications.
Configuring Maven and POM dependencies.
Automating Mobile Web Applications.

UNIX SCRIPTING

PROVIDE TRAINING BASIC AND ADVANCED COMMANDS OF UNIX.
EXPLAIN AWK AND NAWK COMMANDSs.
TRAINING ON ADVANCED SCRIPTING.
EXPALIN ROLE OF UNIX SCRIPRTING IN ERP AND DWBI APPLICATIONS.
UNIX/LINUX COMMANDS TO CALL ETL JOBS.