We provide IT Staff Augmentation Services!

Sr. Consultant / Etl - Developer Resume

EXPERIENCE SUMMARY:

  • Currently working as a Senior Consultant/ETL - Developer with 11.9 years of experience in Data Warehouse development using the ETL tool Ab initio
  • Strong knowledge of Data Warehousing concepts, ETL Methodologies and various Database technologies.
  • Good knowledge and experience in software development within Agile framework using scrum methodology.
  • Extensive experience in complete life cycle of Data Warehousing projects starting from design, development, and integration testing till Production implementation.
  • Good analytical skills in understanding the data and coming up with functional specifications and technical design.
  • Experience in leading teams, handled multiple roles - Consultant, Technical Lead, Software Developer.
  • Good working experience with multi cultured teams.
  • As a consultant demonstrated expertise in translating the customer requirements into formal requirements, design specific solutions and deliver the end product using Onsite/Offshore delivery model
  • Good communication skills, interpersonal skills, self-motivated, quick learner and a team player.

TECHNICAL EXPERTISE:

Primary Skills: Ab Initio, Data Warehouse Development, Oracle/Teradata SQL, Plan>IT,BRE, Control Center.

Secondary Skills: Informatica, Data Modeling, Data Warehouse design and Unix shell scripting.

Operating Systems: Windows 98/2000/XP/NT, UNIX,IBM AIX 5.3, Sun Solaris.

Languages: SQL, PL/SQL, Unix shell scripting.

Scheduling Tools: Autosys, Control-M and crontab.

Databases: Oracle and Teradata.

SCM Tools: CVS and EME.

Domain Knowledge: Banking, Health Care Insurance.

Documentation: Confidential ’s, HLD’s, Design Documents, MS Office

Data Modeling tools: Erwin Data modeler.

Defect Tracking Tool: HP-Mercury Quality Center

EXPERIENCE DETAILS:

Confidential

Environment: Ab Initio 3.x, Oracle, Unix, servicenow, Control Center, RLM

Sr. Consultant / ETL - Developer

Responsibilities:

  • Participate in the business team meetings to represent the technical team to help the business team with technical feasibility.
  • Responsible for co-coordinating between client and offshore teams.
  • Attend business meetings to analyze and understand the Business Requriremnent Document(BRD).
  • Prepeare Functional Requrirment Document(FRD) for all requrirments specified in the BRD.
  • Prepare High Level(HLD) and Low Level Desgin( Confidential ) documents for the given reuqirments by Business.
  • Develop data processing applications(graphs, plans, xfrs etc..) using various components of Ab Initio.
  • Create and schedule jobs in Control Center for all newly developed Objects.
  • Review & peer review the Ab Initio graphs to ensure optimum performance and fulfillment of requirements.
  • Manage the issues raised from QA and assign the work items to the team and take up critical work items.
  • Facilitate UAT.
  • Developing Run book and Project Implementation plans for the project deliverables.
  • Provide warranty support for the applications moved to PROD.

Confidential

Environment: Ab Initio 3.x, Teradata 12, Unix

Sr. Consultant / ETL - Developer

Responsibilities:

  • Work with the client teams to identify and understand various source systems and design the integration strategies.
  • Responsible for co-coordinating between client and offshore teams.
  • Attend daily standup meeting to address blockers related to the work items to the scrum master.
  • Provide day to day direction to the project team and regular project status to the customer.
  • Develop data processing applications using Ab Initio.
  • Creatng Control-M jobs for scheduling Ab Initio code processes.
  • Review & peer review the Ab Initio graphs to ensure optimum performance and fulfillment of requirements.
  • Manage the issues raised from QA and assign the work items to the team and take up critical work items.
  • Facilitate UAT.
  • Developing Run book and Project Implementation plans for the project deliverables.
  • Provide warranty support for the applications moved to PROD.

Confidential

Environment: Ab Initio 3.x, Teradata 12, Unix

Team Lead / ETL - Developer

Responsibilities:

  • Work with the client teams to identify and understand various source systems and design the integration strategies.
  • Design and Develop Ab Initio graphs for the data specifications provided by the client.
  • Review & peer review the Ab Initio graphs to ensure optimum performance and fulfillment of requirements.
  • Creating and scheduling the Control-M jobs for DEV,UAT and PROD environments.
  • Developing Run book and Project Implementation plans for the project deliverables.

Confidential

Environment: Ab Initio 2.15, Oracle, Unix, Autosys

Sr. Software Engineer / ETL - Developer

Responsibilities:

  • Work with the client to get business & technical requirements.
  • Developing Graphs in Ab Initio GDE.
  • Configuring Download and upload frame works to move files from one server to another server.
  • Writing unix wrapper scripts to run the graphs.
  • Unit testing of the developed graphs.
  • Creating and scheduling the Autosys jobs for DEV,UAT and PROD environments.
  • Support UAT (User Acceptance testing) and SIT (System Integration testing).

Confidential

Environment: Abinitio 2.14, Oracle, Unix

Asst. Systems Engineer/ ETL - Developer.

Responsibilities:

  • Development of Graphs to Load the data from feed to staging area.
  • Prepare Low level Design document ( Confidential ).
  • Involved in coding Ab Initio centralized graphs for reusability of code and ease of maintenance, usage of multifile system implementation, EME maintenance, wrapper automation, korn shell scripting according to requirement.
  • Involved in Unit testing of interfaces in TDM.
  • Perform Unit testing and peer review
  • Support UAT (User Acceptance testing) and SIT (System Integration testing)

Hire Now