Etl Developer Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Ten Plus years of work experience in IT industry.
- Areas of Expertise include Business Intelligence, ETL Tool Ab Initio, Unix Shell scripting and Oracle Database.
- Extensively worked on AbInitio Conduct - It, Multi file system, Meta Programming, conditional Components, Partitioning and Departitioning components. Knowledge of Continuous flow components.
- My main area of experience has been project delivery of various sizes. I have worked in the domain of Financial services, Insurance, Retail, Banking and Life science & Healthcare.
- Good Knowledge of Data Warehousing Concepts.
- Ability to understand and resolve Data warehouse issues.
- Exposure to ETL Tool Informatica, Teradata.
TECHNICAL SKILLS
ETL Tool: Ab-Initio GDE 3.2/3.0/1.14/1.13/1.11 Co-operating System 3.2/2.15/2.14/2.13/2.11 , Informatica
Operating Systems: Windows 2000/NT/XP, HP UNIX, UNIX (Solaris), AIX.
Programming Languages: UNIX Korn Shell Scripting, SQL, PL/SQL
Source code control: Ab Initio Repository (EME)
Database: Oracle, Teradata, DB2
Scheduling Tool: TWS, Autosys
PROFESSIONAL EXPERIENCE
Confidential
ETL Developer
Responsibilities:
- Analysis of Requirement and functionality and prepare the Mapping document in design phase.
- Work with source teams to get the data and load the data into the COMRAD system.
- Worked on Citi’s Annual Risk Assessment Reporting which involved building a centralized and automated system for collection of data from multiple sources. This will assist the Risk Assessment Team to analyze the data and complete the Risk assessments in a precise and efficient way.
- Designed the graphs based on the transformations and mappings provided in the requirement.
- Designed the generic graph to load the data from different regions. Extensively used metaprogramming techniques.
- Code Automation and Scheduling the jobs using AUTOSYS.
- Prepared the technical design document.
- Preparation of Test Cases and Unit Testing of the graphs.
- ETL troubleshooting (Problem Determination/Resolution). Problem solving ability to provide time critical production fixes without impacting the financial data integrity.
Confidential
ETL Developer
Responsibilities:
- Work with the global/Regional business owners to understand the requirement and get a BRD walk through.
- Design & Development of end-to-end ETL applications,
- Work with Front end(Reporting) teams to understand their data display capability.
- Developing generic solutions to handle ever growing need of data processing from multiple sources.
- Designing graphs based on the transformations and mappings provided in the requirement and load data into the tables.
- Estimation and Design for the systems to be enhanced/ developed following standard models
- Strong working knowledge of Data Warehousing techniques and Concepts experience including ETL processes, Star Schema/Snowflake Schema.
- Scheduling the jobs using AUTOSYS.
- Preparation of Test Cases and Unit Testing of the graphs.
- ETL troubleshooting (Problem Determination/Resolution). Problem solving ability to provide time critical production fixes without impacting the financial data integrity.
Confidential
ETL Developer
Responsibilities:
- Project co-ordination with the business users for requirement analysis.
- Design & Development of end-to-end ETL applications,
- Designing graphs based on the transformations and mappings provided in the requirement and load data into the tables.
- Automation of the Jobs execution after creation of Webforms.
- ETL performance tuning, ETL design consulting, ETL Code Migration.
- Creation of wrapper scripts to execute the process from the backend.
- Preparation of Test Cases and Unit Testing of the graphs.
- Code Review of the Project to verify whether it abides to the Kaiser standard.
- Submission of quarterly Mandatory secondary Payer Report to Centre of Medicare services (CMS).
- Use of different Ab Initio components and different functions.
- Unit Testing the Graphs once development is complete.
- ETL troubleshooting (Problem Determination/Resolution). Problem solving ability to provide time critical production fixes without impacting the financial data integrity.
Confidential
ETL Developer
Responsibilities:
- Estimation of work and prepare project plan, Low level design and detailed design documents in order to get a clear understanding of the design flow.
- Developed Ab Initio Graphs, plan> It and wrapper scripts.
- Designed and developed the code for Data Migration from one database to another.
- Involved in manual testing and unit testing to check whether the data in both the databases is in sync.
- Participated and took effective role in Knowledge sharing and meetings with the client.
- Perform ETL software upgrades, ETL source code control management.
- Use of IQMS for quality purpose to log the defects, track them and fix them.
- ETL troubleshooting (Problem determination/ Resolution).
- Ab Initio code migration using .SAV package once Testing is complete.
- Ab Initio performance tuning techniques to enhance the performance of the Ab Initio graphs.
- Successfully deployed the graphs from the Development Repository to Testing Repository and Production Repository.
Confidential
ETL Developer
Responsibilities:
- Understanding the complete business flow.
- Communication with the Client on regular basis for requirement gathering and analysis.
- Designing graphs and mappings through Ab Initio in order to Import and export the data using transformations.
- Design, Planning & Development of end-to-end ETL applications, Work distribution among team members
- Involved in UNIX shell scripting.
- Designing graphs for Data Migration from one module to another.
- Data Modelling, Data Warehouse/ Data Mart Design.
- Preparation of low level design and high level design.
- Creation and modification of new and existing database objects and the corresponding loading scripts as per the requirements.
- Used .SAV package to migrate the Ab Initio code from dev server to prod server.
Confidential
ETL Developer
Responsibilities:
- Understanding the existing business model and customer requirements.
- Providing support and enhancing the applications.
- Implementation of the application changes.
- Designed and developed the Codes for maintaining the Databases for various Entities and Procedures that had the entire complex Business Logic.
- Worked on improving the performance of Ab Initio graphs by using various Ab Initio performance technique’s like using lookups instead of Joins.
- Validations of the codes to ensure the changes are compatible to business rules. This helped the system testing and E2E testing in a smoother way. Giving regular updates in scrum calls and Client calls. Also arranging calls to discuss the issues with the E2E team and probable resolution for that in a quick time. This had made the delivery in a much smoother way.
- Used IQMS for quality purpose to log the defects, track them and fix them.
- Created wrapper scripts to run the graphs.
- Used CVS for version controlling.
- Created Test plans and Test scripts for manual testing.
- Involved in code migration to production server.
- Monitored the job and resolved the CRs.
Confidential
ETL Developer
Responsibilities:
- Understanding the existing business model and customer requirements.
- Worked in the Update Module, as a part of the Update team.
- Involved in creation of best practice document for Ab Initio.
- Worked as an ETL Developer, understood the client requirements and translated it into codes.
- Involved in the preparation of High Level documents.
- Designing ETL activity graphs through Ab Initio & Teradata Utilities. Used most of the AI components.
- Updating DMLs and XFRs to the existing Graphs according to the customer requirement.
- Ab Initio performance tuning techniques to enhance the performance of the Ab Initio graphs.
- Preparation of Test Plans, Test cases and Test scenarios for Unit Testing once development is complete.
- Used EME for check in & check out graphs and version controlling.
- Running scripts of Ab Initio graphs in UNIX environment.
- Created and tested TERADATA and UNIX scripts.
- Involved in code migration to production server.