UrbanPro
true
Praven Sekhar ETL trainer in Secunderabad/>

Praven Sekhar

A S Rao Nagar, Hyderabad, India - 500062.

Contact
Referral Discount: Get ₹ 250 off when you make a payment to start classes. Get started by Booking a Demo.

Details verified of Praven Sekhar

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Overview

ETL Tools - Informatica Power Center (v 9.6.1), Talend Data Fabric / Cloud, SSIS ➢ Worked on multiple source & target systems such as Mainframe files, Delimited and Fixed width files, and Oracle and SQL databases to extract and load data. ➢ Worked with Sources like SAP S4/HANA, ODP in Talend to extract Full and Incremental loads using tSAP components. ➢ Worked with Talend in creation of using ELT components to better use Snowflake Computing capabilities. ➢ Good experience in using tMap/tELTMap components in Talend to transform data using various available pre-built functions. ➢ Designed components in Talend to control Snowflake virtual warehouses. ➢ Experienced in using Talend Data Fabric tools (Talend DI, Talend MDM, Talend DQ, Talend Data Preparation, ESB, TAC). ➢ Good experience working with MSSQL, Oracle, Snowflake, SAP, Azure and XML based Talend components. ➢ Experienced in Data Ingestion projects to inject data into Data lake using multiple sources systems using Talend Bigdata. ➢ Experienced in scheduling Talend jobs using Talend Management Console (TMC) - Talend Cloud 7.2. ➢ Experience in better utilization of Talend Orchestration Components. ➢ Transformations – Source Qualifier, Expression, Connected and Unconnected lookup’s, Joiner, Router, Update Strategy, Aggregator, Normalizer, Stored Procedure and others along with its configurable properties. ➢ Implemented Solutions that use SCD types, stored procedures and Source Qualifiers. ➢ Good Knowledge on Workflow, Session, Mapplet and Worklet configurations and integrations. ➢ Vast experience in understanding Informatica metadata tables that store detailed level of configurations, schedules, workflows and transformations. ➢ Experienced in ETL Talend Data Fabric components and used features of Context Variables, MySQL, Oracle, Hive Database components. ➢ Vast experience in automating jobs during critical data migration activities from On Prem to Cloud. ➢ Knowledge on extracting data from direct file locations through FTP mechanisms, Databases & Indirect file loads. ➢ Developed a Utility to extract and parse multiple parameter files in minutes, integrate with metadata and give key information to back track dependencies. ➢ Pre , Post Success , Failure commands , Parameterization , Partitions etc.,
Information classification: Internal
Databases – Oracle, MS SQL, Snowflake ➢ Good understanding on Snowflake Architecture. ➢ Vast experience in better utilizing Snowflake Components – Tables, Stage (Internal & External), Creating Views and Secure views, Functions and Procedures. ➢ Good experience in administering Snowflake account to use RBAC for respective users. Good understanding on creating Virtual Warehouses and Administer to perform better using available Scaling policies. ➢ Experience in designing framework on better utilization of Snowflake capabilities like Result cache, Zero Copy Clone and Time Travel. ➢ Developed various frameworks to understand internal working functionality of Snowflake (How Internal Stages, and Temporary tables are used) ➢ Query Knowledge - DDL & DML Statements, Joins, Union & Intersect, Distinct, Rank, Row number (), ORDER BY, PIVOT, TRANSLATE etc., ➢ Good knowledge on implementing PL/SQL blocks – Loops, Cursor, Functions, Procedures, and Packages & Triggers. ➢ Good experience in designing optimal queries to give faster results. Reporting & Visualizations – Power BI ➢ Data Import using Excel , Oracle , SQL Server , Azure Data Lake Store , Azure Databases etc., ➢ Knowledge on transformations based on business layer terminology, Developing business model etc., ➢ Implemented custom logics to navigate from one report to other using Dynamic links. ➢ Good understanding on DAX expressions, calculated columns, tables and measures. ➢ Implemented Parameterization concepts to filter datasets and select data source inputs on adhoc basis. ➢ Knowledge on publishing reports to cloud – Individual Workspace and App Workspace , Creation of Dashboard tiles etc., ➢ Good knowledge on Roles and report security. Data Migration ➢ Part of Migration Design architecture to move On Prem Data on MS SQL to Snowflake Cloud Data Warehouse. Other Knowledge Areas ➢ Basics of Cloud concepts – IAAS , PAAS , SAAS ➢ Microsoft Azure – Compute , Network , Datab

Languages Spoken

English Proficient

Education

javaharalal nehru technical university 2014

Master of Engineering - Master of Technology (M.E./M.Tech.)

Address

A S Rao Nagar, Hyderabad, India - 500062

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 Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in ETL Training

8

ETL Training Tools

Talend

MSBI Training

Class Location

Online (video chat via skype, google hangout etc)

Willing to travel

Tutor's Home

Years of Experience in MSBI Training

8

Data Warehouse Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Data Warehouse Training

8

Microsoft Power BI classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Power BI classes

8

Reviews

No Reviews yet!

FAQs

1. Which classes do you teach?

I teach Data Warehouse, ETL, MSBI and Microsoft Power BI 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.

Teaches

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

ETL Training Tools

Talend

MSBI Training

Class Location

Online (video chat via skype, google hangout etc)

Willing to travel

Tutor's Home

Years of Experience in MSBI Training

8

Data Warehouse Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Data Warehouse Training

8

Microsoft Power BI classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Power BI classes

8

No Reviews yet!

Praven Sekhar conducts classes in Data Warehouse, ETL and MSBI. Praven is located in A S Rao Nagar, Secunderabad. Praven takes at students Home and Regular Classes- at his Home. He has 8 years of teaching experience . Praven has completed Master of Engineering - Master of Technology (M.E./M.Tech.) from javaharalal nehru technical university in 2014. He is well versed in English.

X

Share this Profile

Recommended Profiles

Mahesh

Mahesh photo Kphb Colony, Hyderabad

Ambedkara

Ambedkara photo Dummingkuppam, Chennai

Revanth

Revanth photo Begumpet, Hyderabad

Sandeep T

Sandeep T photo Chanda Nagar, Hyderabad

Venkat

Venkat photo T Nagar, Chennai

Aravinth

Aravinth photo Btm Layout 2nd Stage, Bangalore

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.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

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