Uploaded File
no photo
Sr. ETL Developer
10 years experience W2 Plano, TX
Available immediately
Actively seeking
no photo
Sr. ETL Developer
Average rating
Profile views
Auditing DB2 ETL Informatica Informatica Powercenter Project Management UNIX AIX Metadata SQL
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 Informatica Developer Metadata Project Management SQL Developer AIX Windows Server Auditing
Hadoop Engineer 08/13 - 09/14
Hadoop Flume Hive Sqoop MapReduce Data Management Oozie Hbase Pig Java Database Upgrades
Hadoop Developer 03/12 - 08/13
Hadoop Hive Sqoop MapReduce MySQL Oozie Pig Eclipse Flume Hadoop Developer Hbase HDFS Java SQL Project Management

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