Uploaded File
no photo
Sr. ETL Developer
Plano, TX
Available immediately
Actively seeking
no photo
Sr. ETL Developer
Average rating
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

  • 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
Education and Certifications
Willing to relocate?:No
Prepared to Travel:Up to 25%
Employment Type:Contract
Security Clearance:No clearance
Citizenship:H-1B Visa