We provide IT Staff Augmentation Services!

Etl/technical Lead (infromatica) Resume

Raritan, NJ

Experience Summary:

  • 11 years of rich experience in software development life cycle comprising 4 years’ in SQL & PL/SQL, 7 years in Informatica PowerCenter and 1 year in Data Modeling.
  • Experience in handling multiple project for customer account.
  • Extensive experience using different SDLC methods like Agile, Waterfall, and Spiral Model.
  • Developing data conversion/migration roadmap.
  • Building team competencies through focused development efforts.
  • Design and recommend ETL and analytics solutions in DWH and BI space.
  • Experience working at client place at multiple geography in onsite-offshore model as well as Individual contributor.
  • Expertise in Requirement Understanding and Analysis, ETL Design, Technical Design Docs (HLD, LLD).
  • Extensive experience in ETL release management at all environments– migrating objects from Dev to Test to Prod.
  • Experience in integrating various data sources like Oracle, SQL Server, DB2 UDB, Flat File, SAP and Sales force.
  • Proficiency in data warehousing techniques like SCD, CDC and surrogate key assignment.
  • Experience in code review (of Informatica mappings, PL/SQL, Shell scripts with standard best practices used in the industry).
  • Strong experience in preparing test plans and test cases.
  • Expertise in SQL, PL/SQL procedures/functions, triggers and exceptions.
  • Experience in UNIX Shell Scripting.
  • Expertise in Data modelling (Relational and Dimensional modelling).
  • Worked extensively on concepts like Star-Schema Modelling, fact and dimension tables modelling of data at all the levels: logical & physical and generating DDL scripts.
  • Implemented IBM IIW/IAA model for Claim center and policy.

Technical Skills:

ETL Tools: Informatica PowerCenter 9.x, 8.x, PL/SQL

Databases: Oracle11g/10g/9i/8i, MS SQL Server 2005/2008, MS Access 7.0/2000

Data Modelling: Erwin

Development/Productivity Tools: PL/SQL, SQL*Plus, Toad, HP Quality Center

Functional Areas: Manufacturing, Healthcare and Life sciences, Energy & Utilities, Banking and Finance, Salesforce.com

Scheduling Tool: Control M

Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: Windows NT/2003/2008,XP,7,8 Linux and HP-UNIX

Professional Experience:


Role : ETL/Technical Lead (Infromatica)

Project Name : Smart Grid Management Systems

Environment : Oracle-11g, Informatica 9.1,

Onsite Experience: 6+ Months, USA

Responsibilities :

  • Requirement gathering, analysis and tracking.
  • Preparing Functional Specification documents.
  • Logical and Physical Data Modelling.
  • ETL Architecture.
  • Preparing Technical Design Documents.
  • Input to project planning and estimations.
  • Task assignment (delegation, partitioning, coordination between tasks)
  • Conducting code review and addressing the technical issues.
  • Tuning code for optimal performance.
  • Defect Tracking (Reviews and Testing).
  • Preparing Weekly Status Reports and presenting to customer/stakeholders.
  • Production support and maintenance of ETL environments.


Role : ETL Architect / Data Architect

Onsite Experience: 2 Months, UK


  • Requirement gathering, analysis and tracking.
  • ETL design and preparing high/low level technical design documents.
  • Designed EDW and Central data mart as per IBM IAA/IIW model to implement claim centre.
  • Created the source-target mapping doc to sync data definitions of GWCC data with IBM IIW model.
  • Supported the ETL and Reporting team to understand the source-target mapping.
  • Planning, configuring, and deploy code in various environment (Dev/UAT/PROD).
  • Task assignment and delivery responsibilities.
  • Onsite-offshore co-ordination.
  • Addressing the technical queries of the team.
  • Providing technical guidance to team and addressing technical queries.
  • Preparing the Weekly Status Reports and Activity tracker.


Role : ETL Architect / ETL Lead / Technical Lead / Senior Developer

Environment : PL/SQL, Oracle 9i


  • Input to Project Planning, Estimation, Monitoring and control.
  • Identifying and mitigating project risk. Namely scope, schedule and resource risk.
  • Onsite-offshore co-ordination.
  • Task assignment (delegation, partitioning, and co-ordination between tasks).
  • Technical Leadership to the development team.
  • Customer reviews and status updates.
  • Contributing in Process / flow enhancement.
  • Standardization of delivery metrics and best practices implementation.
  • Debug, monitor and troubleshoot data sourcing solutions
  • Conceptual, Logical and Physical Data Modelling.
  • ETL Architecture.
  • High and Low level technical design.
  • Developed complex mappings using Normalizer Transformation.
  • Developed mapping for incremental data extraction from upstream
  • Created reusable mapplets used in upstream data extraction mappings.
  • Created and scheduled workflows to be executed as per the schedule provided by business team.
  • Created email tasks to send success/failure emails to mailer list.
  • Developed PL/SQL procedures required in the ETL process.
  • Creating partition at session level to improve the performance.
  • Tuning and optimizing the Informatica SQ query.
  • Coding of main business rules through backend Triggers, Stored programs and Packages using PL/SQL
  • Code review of the module to ensure it meets the functional requirements.
  • Unit, Integration and user acceptance testing,
  • Planning deployment strategy.
  • Defect tracking, monitoring and control including fixes, reviews and testing.
  • Participate and handle release management

Confidential, Raritan, NJ

Role : PL/SQL Developer and SCEPTRE Support team member

Environment: PL/SQL


  • Understanding the system and the data flow within the system
  • Tuning and optimizing the database objects.
  • Database related tickets, such as service request for database related changes and admin edit,
  • Expedited Change Controls (ECC) for emergency changes that cannot wait for a new release
  • Change Requests- minor/major enhancements or feature addition
  • New developments and modification of the application for better functionality and additional business logic.


Role : Developer

Project : Ebizframe Customization

Environment: Oracle, PL/SQL


  • System Study
  • Requirement Understanding
  • Coding main business rules through backend Triggers, Stored Subprograms and front-end procedures and functions.
  • Development and Customization.

Hire Now