Uploaded File
no photo
Kancharla
Sr. ETL Developer
Plano, TX
Available immediately
Actively seeking
no photo
Kancharla
11
views
Sr. ETL Developer
0
Recommendations
Average rating
11
Profile views
Oozie MapReduce Sqoop Hadoop Hive Informatica Powercenter Oracle SSIS SQL Server DB2
Remove Note
View Note
Recent Experience
Informatica Developer 09/14 - present
Informatica Powercenter Informatica ETL PL/SQL Oracle SQL SSIS SQL Server DB2 XML Teradata Analysis Business Requirements Data Analysis UNIX
Hadoop Engineer 08/13 - 09/14
Hadoop Flume Hive Sqoop MapReduce Data Management Oozie
Hadoop Developer 03/12 - 08/13
Hadoop Hive Sqoop MapReduce MySQL Oozie Pig
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.

Top 5 Skills
SkillsProficiencyLast Used
Oozie
2014
MapReduce
2014
Sqoop
2014
Hadoop
2014
Hive
2014
Education and Certifications
Preferences
Availability:Immediately
Willing to relocate?:No
Prepared to Travel:Up to 25%
Employment Type:Contract
Security Clearance:No clearance
Citizenship:H-1B Visa