We provide IT Staff Augmentation Services!

Senior Etl Lead Resume

Irving, TX

SUMMARY:

  • Over 11 Years of IT experience in delivering Business Intelligence solutions using tools like Ab - Initio, OWB in the domain of US Banking and Financial Services as well as Insurance.
  • Experience in Analysis, Design, Development, Implementation and Maintenance of ETL data warehouse applications.
  • Well versed with various Ab Initio Parallelism techniques and implemented Ab Initio Graphs using Parallelism and Multi File System (MFS) techniques.
  • Improved performance of Ab Initio graphs by using various Ab Initio performance techniques and components like Reformat, Join, Rollup, Scan, Normalize, Meta Pivot etc.
  • Integrated Ab-Initio with Hadoop HDFS and HIVE tables in recent projects.
  • Experience in ETL processes with large scale of Retail and Mortgage Customer Banking data with their demographic and PI data analysis integrated to Oracle and Teradata.
  • Experience in integration of various Data sources such as Flat files, XML files, Web Service call, JSON Files, HIVE Tables, COBOL Copybook.
  • Developed different reusable frameworks in Ab Initio.
  • Worked on Teradata Utilities like Multi Load, Fast Load, Fast Export and BTEQ.
  • Experience in Database Development using SQL in Oracle 9i/10g/11g, Teradata 13/14 and Sql Server 2009.
  • Good knowledge of Data Warehouse concepts and principles - Star Schema, Snowflake, SCD Types, Surrogate Keys, Normalization/De-normalization.
  • Basic knowledge in Hadoop Eco Systems.
  • Experienced in handling jobs using Autosys and Maestro scheduler.

TECHNICAL SKILLS:

  • Project Development Models: Waterfall, Prototyping and Agile
  • Languages: UNIX Shell Scripting and SQL
  • Databases and Tools: Teradata, Oracle 9i/8i/7.x/11g, MS SQL Server 2008, MS Access, Toad, SQL Assistant, Maestro and Autosys Schedulers, Service Now
  • ETL Tools: Abinitio - GDE 3.5.2.7, Co>Op 3.5.2.7, Oracle warehouse builder 10g
  • Service Support: Incident Management, Problem Management, Change Management, Release Management & Process Improvement

PROFESSIONAL EXPERIENCE:

Confidential, IRVING, TX

Senior ETL Lead

Responsibilities:

  • Involved in Analysis, Design, Development, end-to-end Implementation of this Project.
  • Prepare project setup and generic wrapper scripts to control and execution of psets.
  • Understanding the specifications for Data Warehouse ETL Processes.
  • Involved in Performance tuning of Ab Initio graphs.
  • Handling complex ETL code development, review and production support issue fix.
  • Create ETL design document, maintain the design patterns, and create ETL interfaces.
  • Involved in creation of sandbox environment and setup for performance and UAT testing.
  • Involved in code reviews, Unit testing and Integration testing.
  • Responsible for end-to-end project deliverables and mentoring the whole team technically Planning, Strategizing and Risk analysis of project modules prior to every release.

Environment: Ab Initio (GDE 3.5.2, Co>operating system 3.5.2.7), Autosys, Teradata, Windows XP and Linux.

Confidential, IRVING, TX

Senior ETL Lead

Responsibilities:

  • Involved in Analysis, Design, Development, end-to-end Implementation of this Project.
  • Prepare project setup and generic wrapper scripts to control and execution of psets.
  • Understanding the specifications for Data Warehouse ETL Processes.
  • Involved in Performance tuning of Ab Initio graphs.
  • Handling complex ETL code development, review and production support issue fix.
  • Create ETL design document, maintain the design patterns, and create ETL interfaces.
  • Involved in creation of sandbox environment and setup for performance and UAT testing.
  • Worked with XML as source for loading data into Data warehouse
  • Involved in code reviews, Unit testing and Integration testing.
  • Responsible for end-to-end project deliverables and mentoring the whole team technically Planning, Strategizing and Risk analysis of project modules prior to every release.

Environment: Ab Initio (GDE 3.5.2, Co>operating system 3.5.2.7), Autosys, Oracle, HDFS, Hive, Windows XP and Linux.

Confidential, IRVING, TX

Senior ETL Lead

Responsibilities:

  • Detail analysis of application features and functions to assess scope and impact for technical needs.
  • Preparing high level design and walkthrough of technical documentation for Business approvals.
  • Build Ab-initio Graphs based on technical design.
  • Co-ordinate with Offshore development team to provide direction, expertise, feedback on daily basis on project activities.
  • Provide update to delivery management team through effectively communicating project progress, expectations, assumptions and dependencies in timely and clear fashion throughout the project.
  • Data validation support during Unit testing and Integration testing.
  • Migration of code from Dev/QA servers to production and implementing the same.
  • Ensure the quality of the deliverables on time.
  • Worked with XML as source for loading data into Data warehouse
  • Provide support for User acceptance testing and post implementation activities.
  • Responsible for managing the Development and maintenance to achieve the highest level of customer (end user) acceptance and satisfaction within Service Level Agreements (SLA).
  • Involved in various data store operations like, code check-in, code checkout, creating project parameters according to the environment settings for this application.

Environment: Ab Initio (GDE 3.3/3.2 Co>operating system 3.2.4), Autosys, Sql Server, Windows XP and Unix AIX-6.1.

Confidential, IRVING, TX

ETL Lead

Responsibilities:

  • Detail analysis of application features and functions to assess scope and impact for technical needs.
  • Preparing high level design and walkthrough of technical documentation for Business approvals.
  • Build code based on technical design.
  • Co-ordinate with Offshore development team to provide direction, expertise, feedback on daily basis on project activities.
  • Provide update to delivery management team through effectively communicating project progress, expectations, assumptions and dependencies in timely and clear fashion throughout the project.
  • Data validation support during Unit testing and Integration testing.
  • Involved in various EME data store operations like creating sandbox, code check-in, code checkout, creating project parameters according to the environment settings for this application.
  • Migration of code from Dev/QA servers to production and implementing the same.
  • Ensure the quality of the deliverables on time.
  • Worked with XML as source for loading data into Data warehouse. Worked in Teradata loading utilities like Multi Load and Fast Load.
  • Create Autosys JIL scripts for scheduling batch process.
  • Provide support for User acceptance testing and post implementation activities.
  • Responsible for managing the Development and maintenance to achieve the highest level of customer (end user) acceptance and satisfaction within Service Level Agreements (SLA).

Environment: Ab Initio (GDE 3.1.4/3.2 Co>operating system 3.2.4), Autosys, Teradata 14, Windows XP and Unix AIX-6.1.

Confidential, IRVING, TX

Senior ETL Developer

Responsibilities:

  • Detail analysis of application features and functions to assess scope and impact for technical needs.
  • Preparing high level design and walkthrough of technical documentation for Business approvals.
  • Build code based on technical design.
  • Co-ordinate with Offshore development team to provide direction, expertise, feedback on daily basis on project activities.
  • Provide update to delivery management team through effectively communicating project progress, expectations, assumptions and dependencies in timely and clear fashion throughout the project.
  • Data validation support during Unit testing and Integration testing.
  • Involved in various EME data store operations like creating sandbox, code check-in, code checkout, creating project parameters according to the environment settings for this application.
  • Migration of code from Dev/QA servers to production and implementing the same.

Environment: Ab Initio GDE 3.0.5/3.1.4 , Autosys, Teradata 12/13, Windows XP and Unix AIX-6.1

Confidential, IRVING, TX

ETL Developer

Responsibilities:

  • Detail analysis of application features and functions to assess scope and impact for technical needs.
  • Preparing high level design and walkthrough of technical documentation for Business approvals.
  • Build code based on technical design.
  • Co-ordinate with Offshore development team to provide direction, expertise, feedback on daily basis on project activities.
  • Provide update to delivery management team through effectively communicating project progress, expectations, assumptions and dependencies in timely and clear fashion throughout the project.
  • Data validation support during Unit testing and Integration testing.
  • Migration of code from Dev/QA servers to production and implementing the same.

Environment: Ab Initio GDE 3.03, Maestro, Teradata, Windows XP and Unix AIX-6.

Hire Now