We provide IT Staff Augmentation Services!

Etl Lead Resume

SUMMARY

  • Around 12+ years of IT experience in ETL Development, Enhancement, Maintenance, Production support, Data Modeling including Business requirement, system requirement gathering of Enterprise Data warehouses
  • Worked at various client facing roles with extensive experience of working at client side.
  • Sound experience as ETL Lead with active participation in Project Assessment, Project planning, Task creation, execution and monitoring, Estimation and managing stakeholder communication.
  • Experience in Extraction, Transformation and Loading of data using Informatica and UNIX from heterogeneous source systems like Flat files, XML, Mainframe Files, Oracle, SQL Server, Teradata Netezza,TOAD
  • Automation, Scheduling and monitoring of jobs with scheduler Control - M
  • Hands on experience using Informatica Power Center 9.x/8.x and Business Objects .
  • Expertise in doing the RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization of the mappings, sessions and workflows .
  • Ability to adjust to the people, circumstances & responsibility, with a Drive for results through self-motivation & self-candor.
  • Management skills include Team Management, Project Planning, Monitoring, and self-starter with good communication skills and ability to work independently and as part of a team.

TECHNICAL SKILLS

  • Informatica
  • SQL Server
  • Teradata
  • Control-M
  • Netezza
  • UNIX
  • Oracle
  • Business Objects
  • TOAD
  • SQL Developer
  • Hive
  • Data Warehousing
  • ETL

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead

Responsibilities:

  • Interaction with Client to understand the Business Requirements and data model.
  • Design and Develop ETL for the project.
  • Design, develop BTEQ scripts for the project
  • Coordinate End to End Development cycle for the project.

Confidential

ETL Lead

Responsibilities:

  • Interaction with Client to understand the Business Requirements and data model.
  • Suggest Improvement to the existing data model to have enhanced functionalities.
  • Performance tuning of legacy ETLs.
  • Worked as Techno functional lead, attended requirement gathering sessions and meetings.
  • Involved in Data profiling and data quality teamwork.
  • Responsible for monitoring all the sessions that are scheduled for run, investigation of the failed session and debugging the corresponding mappings.

Confidential

ETL Lead

Responsibilities:

  • Tech Lead and interacting with the Client to understand the business requirements. Involved in analyzing requirements to refine transformations.
  • Suggest Improvement to the existing data model to have enhanced functionalities.
  • Coordinate environment set up for self and team.
  • Design, Develop ETL for the project.
  • Coordinate the End to End Development cycle for the project.

Confidential

ETL Lead

Responsibilities:

  • Lead and guide an Informatica based ETL architecture to handle complex business rules while balancing the fulfillment of stringent performance requirements.
  • Suggest Improvement to the existing data model to have enhanced functionalities.
  • Develop solution in a highly demanding environment and provide hands-on guidance to other team members.
  • Conduct impact assessment and determine the size of effort based on requirements.
  • Develop full SDLC project plans to implement ETL solution and identify resource requirements.

Hire Now