We provide IT Staff Augmentation Services!

Abinitio Etl Lead Developer Resume

SUMMARY

  • About 9 years of sound experience of technical and managerial activities which involves several business domains: Banking, Telecom and Logistic industry.
  • Have experience handling a team of 25+ resources. Experience in managing an onsite offshore team.
  • 9 years of experience in data warehouse space, skilled in multiple of the disciplines of data warehouse such as Data Modeling, ETL Abinitio Analyst, data management and BI reporting analyst in various development projects.
  • Involved in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high - volume environment and data processing at Terabytes level.
  • Capacity of designing solutions around AbInitio, with advanced skills in high performance and parallelism in AbInitio.
  • Good experience in understanding business requirements and translating these to schema requirements, good understanding of data profiling, meta data, ETL and reporting.
  • Strong UNIX, korn shell scripting experience.
  • Good Oracle, Teradata database knowledge
  • Experience in full software development life cycle of development projects.
  • Hands on in agile development.
  • Good interpersonal, communication, team handling and documentation skills

TECHNICAL SKILLS

Hardware Platform and OS: Windows 98/2000, UNIX

Tools: / Software: Ms Office, Abinitio, Toad, Mercury Quality Center

Languages: SQL, PL/SQL, Unix shell scripting

Database: Oracle, Teradata

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Abinitio ETL lead developer

Responsibilities:

  • Involved in analyzing the requirements and mapping the requirements into High level document and Detail design document.
  • Design ETL mappings to load data warehouse table
  • Involve in effort estimation and capacity planning.
  • Involve in developing Abinitio graphs based on design document, unix scripts to run the graph’s deployed unix scripts, SQL queries for extraction and loading of data in Data warehouse tables
  • Involved in internal and external code review for the quality of the deliverables.
  • Involved in Unit testing and System Integration testing. Coordinated in preparing Test Environment and Test Data.
  • Involved in creating Test Plan and Test scripts document.
  • Coordinated User Acceptance Testing. Investigated and resolved defects raised by Business Users.
  • Involved in tracking defects and maintaining defect logs.
  • Involve in versioning the Abinitio graphs to EME
  • Creating Packages for the set of artifacts to migrate from one environment to other environment
  • Involved in migration and deployment of code in production. Involve in creation of Implementation plan.
  • Ensure all relevant documents are available and uploaded in SharePoint link
  • Tracking and monitoring work status to ensure timelines
  • Attend and Facilitate checkpoint / status meetings.
  • Onsite-offshore coordination
  • Coordination with Business Users.

Confidential

Abinitio ETL Lead developer

Responsibilities:

  • Involved in analyzing the requirements and creating the Detail design document.
  • Involve in developing Abinitio graphs based on design document, unix scripts to run the graph’s deployed unix scripts, SQL queries for extraction and loading of data in Data warehouse tables
  • Involved in internal and external code review for the quality of the deliverables.
  • Involved in Unit testing and System Integration testing. Coordinated in preparing Test Environment and Test Data.
  • Involved in creating Test Plan and Test scripts document.
  • Coordinated User Acceptance Testing. Investigated and resolved defects raised by Business Users.
  • Involved in tracking defects and maintaining defect logs.
  • Involve in versioning the Abinitio graphs to EME
  • Creating Packages for the set of artifacts to migrate from one environment to other environment
  • Involved in migration and deployment of code in production. Involve in creation of Implementation plan.
  • Tracking and monitoring work status to ensure timelines
  • Attend and Facilitate checkpoint / status meetings.
  • Onsite-offshore coordination

Confidential

Abinitio ETL Developer

Responsibilities:

  • Involved in analyzing the business requirements and creating the Detail design document.
  • Involve in developing Abinitio graphs and PL/SQL programs based on design document, unix scripts to run the graph’s deployed Unix scripts, SQL queries for extraction and loading of data in Data warehouse tables
  • Involved in Unit testing and System Integration testing. Create Test Plan and Test scripts document.
  • Involve in versioning the Abinitio graphs to EME
  • Creating Packages for the set of artifacts to migrate from one environment to other environment
  • Involved in internal code review for the quality of the deliverables.
  • Ensure all relevant documents are available and uploaded in SharePoint link.

Confidential

Abinitio ETL developer

Responsibilities:

  • Involved in analyzing the business requirements and creating the Detail design document.
  • Involve in developing Abinitio graphs and PL/SQL programs based on design document, unix scripts to run the graph’s deployed Unix scripts, SQL queries for extraction and loading of data in Data warehouse tables
  • Involved in Unit testing and System Integration testing. Create Test Plan and Test scripts document.
  • Involve in versioning the Abinitio graphs to EME
  • Creating Packages for the set of artifacts to migrate from one environment to other environment
  • Involved in internal code review for the quality of the deliverables.
  • Ensure all relevant documents are available and uploaded in SharePoint link.

Confidential

Abinitio ETL developer

Responsibilities:

  • Analyzing the Business Requirements and System Specifications.
  • Involved in developing ETL codes according to design document.
  • Involved in different stages of development which goes with the User Story Evaluation, Impact Analysis, High Level design, Low Level design, construction and Unit Testing.
  • Involve in verifying the code standard as per the code review checklist.
  • Coordinating with the testing team in Test Environment preparation, System Integration testing, Regression testing
  • Reviewing the Testing documents including Test Specification, Test Plan, Test Summary Report.
  • Investigating and resolving the problem logged by testing team.
  • Migration and deployment of codes into Production Environment.

Hire Now