We provide IT Staff Augmentation Services!

Onsite Tech Lead Resume

EXPERIENCE SUMMARY:

  • Working as ETL Developer with 5.8 years of experience in Abinitio, Informatica, Mainframe, Unix & SQL.
  • Technically adept and confident software programmer with exceptional skills in coding and documentation.
  • Good knowledge of Data warehousing concepts and expertise in ETL Tools Abintio & Informatica and domain knowledge of MANTAS.
  • Had worked on code optimization in Abinitio to improve the weightage and running time of the Graphs.
  • Experience in SQL tuning and creation of Indexes for faster database access and used explain plan for better query performance.
  • Had taken initiative in identifying the project requirements, analyzing business risk & project risk and evaluating the same with the team in team meetings
  • Had taken responsibilities in analyzing, development, unit testing, integration testing and Production Support after release.

TECHNICAL SKILLS:

Good expertise in the ETL Tools: Ab Initio GDE 1.15.9 and Informatica 8.6

Also worked with the Ab Corp tools: BRE 1.15.2.5 and Data Profiler 1.15.2

Has worked in database: Oracle 9i & 10g and DB2 with tools TOAD & Pl/Sql Developer and Mainframe.

Has worked on the: Unix environment with good knowledge on shell scripting.

WORK EXPERIENCE:

Confidential

Technology: Ab Initio 3.04, Mainframe, DB2

Onsite Tech Lead

Responsibilities:

  • Discussing and understanding the business requirements from the Client and sharing the same with the off shore team .
  • Coordinating the development work and guiding the off shore team regarding the business requirements, mapping & code clarifications
  • Reviewing the ETL code and checking if the business logic has been properly implemented.
  • Scheduling the jobs through Mainframe scheduler and also verifying the output data both technically and functionally.

Confidential

Technology: Ab Initio 3.04, Mainframe, DB2

Sr Developer

Responsibilities:

  • Analyzed the scenarios and gave valuable technical inputs for the conversion process as per the business requirements.
  • Developed graphs and objects as per the requirements for the conversion.
  • Done the mapping changes for the conversion from CCA to Confidential source.
  • Was involved in Testing the Graphs through Mainframe scheduler and also verified the output data both technically and functionally.
  • Was involved in the history population process, tracking the output files and get the output data in the tables validated through LOB s.

Confidential

Technology: Ab Initio 1.15.9, DB2

Performance Analyst

Responsibilities:

  • Analyzed the scenarios and gave valuable technical inputs for improving the performance of Abinitio graphs.
  • Analysed the SQL queries for performance and suggested ways to improve running time through Index creation & used explain plan for better query performance.
  • Modified the design of Abinitio graphs to drop unwanted components which were taking longer time for execution.
  • Was involved in Testing the Graphs and plans by running automatic scripts using UNIX commands and also through front end in GDE.
  • Was involved in technical support to the client during & after the release into production and solved the production issues on time.

Confidential

Technology: Ab Initio 1.15.9, Abinitio BRE 1.15.2.5, Data Profiler 1.15.2, Oracle Pl/Sql, Unix

Senior Developer

Responsibilities:

  • Analyzed the scenarios and gave valuable technical inputs for design of graphs as per the business requirements.
  • Developed graphs as per the requirements and delivered objects (dml’s & xfr’s) into production to refine undulated data in the expected Confidential and CDL forms.
  • Was involved in Testing the Graphs and plans by running automatic scripts using UNIX commands and also through front end in GDE.
  • Profiled data using Ab Initio Data Profiler to generate datasets.
  • Applied business rules using Ab Initio Business Rule Environment by developing rulesets and generated xfr’s.
  • Was involved in technical support to the client during & after the release into production and solved the production issues on time.

Confidential

Technology: Informatica8.1, Oracle, Unix

Junior Developer

Responsibilities:

  • Developed scripts for generating reports from the controls
  • Designed the informatica mappings and workflows for report generation
  • Involved in unit testing for all the interfaces and had done the validations.
  • Had managed the share point for maintaining the latest code.
  • Provided technical support for the client after the release.

Confidential

Technology: Informatica 8.1, SQL, Unix

Junior Support

Responsibilities:

  • Monitoring the JOBS using Workflow monitor & checking for any Production issues or status alerts
  • Getting the business data from the source, validating and checking the correctness of the data before loading into the Database.
  • Learnt the MANTAS process for running jobs using Informatica.
  • Done the analyzing work for generating matches and alerts using Informatica using the scenarios and to alter the datasets to make the data to generate matches.
  • Done documentation for the “Scenario Execution Process”

Hire Now