add photo
Kancharla
venkikancharla@gmail.com
469-682-3672
Plano, TX 75023
Informatica Developer
14 years experience W2
0
Recommendations
Average rating
263
Profile views
Summary

  • Over 9 years of Demonstrated experience in Retail industry, as an ETL INFORMATICA Developer, UNIX Developer.
  • Involved in various stages of Software Development Life Cycle (SDLC) such as, Requirement analysis, Design, Development, Testing, Implementation and Maintenance.
  • Expert in responsibilities associated with Data such as Data analysis, Data validation, Data modeling and Data cleaning.
  • Hands-on experience in analyzing business and data, such as gathering user requirements, developing technical specifications and creating data models.
  • Adept in creating and maintaining documentation related to Technical design and specifications, Business rules, Data mappings, ETL processes and Testing.
  • Vast knowledge in Business Intelligence (BI), Data warehousing, Dimensional modeling and Design methodologies and Hybrid concepts.
  • Proficiency of ETL development in INFORMATICA Power Center (Admin, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Metadata Manager) for Extracting, Cleaning, Managing, Transforming and Loading data.
  • Good knowledge in Unix shell scripting and application maintenance on all Unix
  • Having knowledge on all Hadoop eco system components like map reduce using java/python, PIG, HIVE, HBASE, and SQOOP.
  • Trained by MapR on HBASE, HIVE and HDFS ecosystems.
  • Having hands on experience in using Hadoop Technologies such as HDFS, HIVE, SQOOP, Impala, Flume and Solr.
  • Having hands on experience in writing Map Reduce jobs in Hive, Pig.
  • Having experience on importing and exporting data from different systems to Hadoop file system using SQOOP.
  • Having experience on creating databases, tables and views in HIVEQL, IMPALA and PIG LATIN.
  • Strong knowledge of Hadoop and Hive's analytical functions.
  • Having good experience on all flavors of Hadoop (Cloudera, MapR etc.)
  • Good Knowledge at Information Retrieval Concepts.
  • Accomplished in optimizing performance issues and adding complex business rules by creating re-usable transformations and robust Mappings/Mapplets.
  • Immense experience working with RDBMS, such as Oracle, MS SQL, etc. and other non-relational data sources such as flat files and XMLs.
  • Proficient in SQL and PL/SQL especially writing complex queries and procedures.
  • Well versed in working-with and developing Reporting Applications in OBIEE.
  • Skilled in designing UML diagrams using tools such as MS Visio for Entity Relationship modeling, component diagrams, class diagrams and flowcharts.
  • Vast practice in preparing and working-with Test scenarios, Test cases and Debugging. Experienced in developing definitions and processes for test phases including unit test, product test, integration test and system test.
  • Leading a team of 10 members at offshore, managing day-to-day planning, operations and problem-solving to meet level of service and production.

Experience
Education
Skills
Auditing
2021
6
DB2
2021
6
ETL
2021
6
Informatica
2021
6
Informatica Powercenter
2021
6
Project Management
2021
6
UNIX
2021
6
Windows
2021
6
AIX
2021
5
Metadata
2021
5
SQL
2021
5
SQL Developer
2021
5
Windows Server
2021
5
Analysis
2021
4
Business Requirements
2021
4
Data Analysis
2021
4
Informatica Developer
2021
4
Oracle
2021
4
PL/SQL
2021
4
SQL Server
2021
4
SSIS
2021
4
Teradata
2021
4
XML
2021
4
Data Marts
2012
2
Flume
2014
2
Hadoop
2014
2
Hbase
2014
2
Hive
2014
2
Java
2014
2
MapReduce
2014
2
Oozie
2014
2
Pig
2014
2
Scripting
2012
2
Shell Scripts
2012
2
Sqoop
2014
2
SVN
2012
2
Adobe Flash
2012
1
Application Development
2011
1
Box
2011
1
Data Cleansing
2011
1
Data Management
2014
1
Data Modeling
2011
1
Data Validation
2011
1
Data Warehousing
2011
1
Database Upgrades
2014
1
Eclipse
2013
1
Erwin Data Modler
2011
1
Functional Testing
2011
1
Hadoop Developer
2013
1
HDFS
2013
1
Integration Testing
2011
1
Load Testing
2011
1
MySQL
2013
1
OPTIM
2013
1
Performance Testing
2011
1
Regression Testing
2011
1
Snowflake
2011
1
Solutions Architecture
2011
1
System Testing
2011
1
Test Case Preparation
2011
1
Test Planning
2011
1
Unit Testing
2011
1
Business Intelligence
0
1
Data Mapping
0
1
ETL Developer
2016
1
IDE
2011
1
impala
0
1
MapR
0
1
OBIEE
0
1
Python
0
1
UML
0
1