We provide IT Staff Augmentation Services!

Etl Lead Resume

PROFESSIONAL SUMMARY:

  • A senior Talend/Informatica ETL developer with a strong background in Data Warehouse domain and 10 years 5 months of core IT experience in Software Engineering, process, methodoloies and management and 4+ year of experience in Bigdata specializing in
  • Strong experience in the Analysis, Design, Development, Implementation, Performance Tuning and Testing Client/Server applications using Talend Big Data versions 5.x and Informatica 8.x & 9.x .
  • Experience in migration of huge volumes of data from legacy system to BigData System using Talend.
  • Proficient in Talend Development, Worked on more than 500 Talend Jobs and Joblets with different Talend components like tRest, tExtractJSONField, tMap, tReplicate, tParallelize, tAggregateRow, tJava, tJavaflex, tgreenplumgpload, tNormalizer, tUniqRow, tMap, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar,, tJava, tJavaFlex and many more.
  • Worked on Flat files, XML files, various relational databases (like oracle, SQL Server, DB2, Sybase, Teradata, Greenplum, Hive) both with Talend and Informatica.
  • Working experience with NoSQL databases (MongoDB, Cassandra Database)
  • Working experience with Messaging System (RabbitMQ)
  • Experience in using cloud components and connectors to make API calls for accessing data from cloud storage (Salesforce, Amazon S3) in Talend
  • Conceptual knowledge on Bigdata (Currently working on Pivotal). Hands on experience in HAWQ and Hadoop File System (HDFS) and conceptual knowledge in Hadoop MapReduce.
  • Experience in developing Informatica mappings using transformations like Source Qualifier, Connected and Unconnected Lookup, Normalizer, Router, Filter, Expression, Aggregator, Stored Procedure, Sequence Generator, Sorter, Joiner, Update Strategy, Union Transformations.
  • Well - experienced on Development as well as GAMS Support for in both Talend and Informatica.
  • Experience in Scheduling tools like Informatica scheduler, Talend scheduler
  • Expert in designing ETL & development solutions Architecture with lowest possible cost without compromising performance.
  • Expert in performance analysis, memory analysis, code tuning both in Talend and Informatica.
  • Certified in Teradata V2R5.Good SQL knowledge on various versions of Teradata V2R5, R6, TD-12 and Oracle 9i, 11g, Greenplum and HAWQ.
  • Hands-On in Teradata Loader Utilities like Fastload, Mload, Fastexport, Tpump, TPT and BTEQ.
  • Acquired conceptually knowledge on Data warehousing, Data Modeling and basic knowledge on Master Data Management (MDM), Big Data concept and Operating System concept.

SKILL:

Operating System: Windows NT, Windows 7,Unix, Linux

Databases: HAWQ,Oracle8i,9i,10g,11g, Teradata V2R5,R6,TD 12,MS SQL Server 2000,MS Access

Languages: C,C++,SQL,PL/SQL, Shell Scripting

ETL Tool: Informatica 8.x,9.x,Talend 5x,Talend 6.1 Big Data Integration

CDC/Data Replication: CDC

BI Reporting Tool: Cognos Report Studio

Data Quality Tool: IQ Insight, Data Quality Inspector

3rd Party Tools/Packages: Toad, SQL Developer, SQL Assistant, PgAdmin, Putty, MS Office, Squirrel

WORK EXPERIENCE:

Confidential

ETL Lead

Responsibilities:

  • Analyze, design, implement and maintain high volume, multiple source system robust and fast ETL applications
  • Advanced ETL development using Talend Big data platform
  • Be a senior technical player on complex ETL development projects with multiple team members
  • Develop relevant functional and technical documentation.
  • Lead, design and develop data warehouse solutions using different architecture, design and modeling techniques
  • Work with business users to translate requirements into system flows, data flows, data mappings etc., and develop solutions to complex business problems.
  • Lead the creation of all design review artifacts during project design phase, facilitate design reviews, capture review feedback and schedule additional detailed design sessions as necessary.
  • Interact with Release Management, Configuration Management, Quality Assurance, Architecture Support Database Support, other Development teams and Operations as required
  • Lead and contribute to all phases of the software development life cycle for Enterprise Data applications including current production and any future applications
  • Performance Tuning of any running loads in Live Environment as required.
  • Create and enhance administrative, operational and technical policies and procedures, adopting best practice guidelines, standards and procedures

Confidential

ETL Lead

Responsibilities:

  • Responsible for Development of Talend ETL code and Involved in Execution of Test cases.
  • Discussing the technical way of development with the onsite team and with the customer directly.
  • Designed and developed ETL logic using Talend 5.2.2 using source as Oracle and Target as Vectorwise worked around various Component tmap, tconvert type, tjava row, tParallelize, tunite, tAggregate row.
  • Responsible for schedule the jobs in server using different type of trigger.
  • Monitor performance of existing loads and tune them as required.

Confidential

ETL Lead

Responsibilities:

  • Leading a team of 9 persons (4 From Mexico, 1 from USA, 4 from India).
  • Performance tuning of existing loads. It includes understanding of data flow, business & deep analysis of ETL code as well as Database code.
  • Review of any new ETL code, developed for PGS including its performance analysis.
  • Discussion with users to gather adhoc requirement.
  • Preparing TDD, BRD, HLD & LLD.
  • Involvement in Data Architect activities like maintaining map on source data for key users.
  • Defined & Created support Central workflow to track End-to-End activity starting from requirement gathering to Report Sign-Off.
  • Involved in POC activities on HVR project.
  • Testing of 3000 Cognos reports upgradation from version 9.0 to 10.0 using LCM (Lifecycle Manager) tool.

Confidential

ETL Lead

Responsibilities:

  • Communicated with business users to understand business.
  • Complete the GPG setup in all environments of Informatica 8.x and 9.x server.
  • Developed shell script to control the full data flow for the project.
  • Actively participated and complete the data validation manually and provided resultant to Customer.

Confidential

ETL Lead

Responsibilities:

  • Communicated with business users to understand business.
  • Actively participated in Warehouse design to store this Engine test data

Confidential

ETL team Member

Responsibilities:

  • Converted 150 MS-Macro code into the Oracle procedures and Informatica mappings.

Confidential

ETL team Member

Responsibilities:

  • Done Reverse Engineering for more than 150 Informatica mappings successfully.
  • Architected this project and was been involved in the ETL maintenance.

Hire Now