ETL Developer Resume

PROFESSIONAL SUMMARY:

6+ years of working experience in Informatica Technologies
2 years of Insurance Domain Experience
4+ years of Healthcare Domain Experience
Work experience in Informatica 8x,9x, Power Exchange, Mainframe, Oracle 10g, Data Warehouse Administration Console ( Oracle DAC )
Have good knowledge of understanding the Abinitio graphs and components.
Good knowledge to create Sessions, Reusable worklets and workflow in Workflow Manager and scheduled the workflow at specified frequency.
Having Knowledge in Installing and upgrading Informatica.
Creating and configuring Informatica domain and repository, User and group creation along with respective roles and privileges.
Having Knowledge of connected and unconnected lookups
Having knowledge in the implementation of Data Warehouse applications mainly Extraction, Transformation and Loading process using ETL tool Informatica power center 8x/9x.
Having Informatica Power Exchange working knowledge and Mainframe data set creation and comparison with two data sets.
Having knowledge on datamap creation using Informatica Power Exchange.

TECHNICAL SKILLS:

ETL Tools: Informatica 8X, Informatica 9X,Abinitio

Other Tools: Toad, Putty, SQL Developer,Citrix,DAC,Cognos Decision stream 7.1,WINSCP,Mainframe,Informatica Power Exchange

Databases: Oracle 9i,10g

Platform: Windows XP, Windows 7

Domain: Insurance, Health Care

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Software: Informatica 9.5, Abinitio, Oracle 10g,SQL Developer, UNIX,Putty, WINSCP

Responsibilities:

Analyze and reverse engineer Ab Initio graphs.
Understand the requirements and prepare Low Level Design document.
Convert the requirements, LLDs into Informatica mappings.
Design and schedule Informatica sessions and shell scripts.
Develop and execute Unit test cases.

Confidential

Systems Analyst

Software: Informatica 8.6,Oracle 10g,Putty,WINSCP

Responsibilities:

1.Maintenance and Enhancement of Feeds 2.Informatica Monitoring Automation
Analyzing the Business Requirement Specification Document from the Client.
Extensively used Informatica Designer to develop Jobs for extracting, integrating, transforming and loading data into Oracle database.
Involved in code review and testing review.
Prepared Test cases for the Mappings.
Developed standard and re - usable mapplets and mappings using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router.
Testing and debugging of code
Fixing the Issues that come out of Integration Testing
Communicating with the client for weekly status report
Used the Workflow Manager to creating, validating and running the workflows, sessions.
Monitoring the workflows using the Workflow Monitor.
Applied performance-tuning logic to optimize session performance.

Confidential

Systems Analyst

Software: Informatica 8.6,Oracle 10g,Putty,WINSCP

Responsibilities:

Ensure the tasks are being completed on time without defects.
Preparing the Metrics report based on the data available.
Identify the process improvement areas in R&M and implement them.
Co ordinate with QRs and complete the PPM every month.
Daily ETL Load Process, Monitoring the daily job loads and sending status sheets.
Used most of the transformation such as the Source Qualifier, Expression, Lookup, Filter, Router, Sequence Generator, Joiner and Update Strategy.
Designing mapping or mapplet using different transformations and validate the mapping.
Imported data from various sources, Transformed and Loaded into Data ware Targets using Informatica.
Analyze relationships among several aspects of a problem and to recognize several likely causes of events and consequences of actions.
Investigate data discrepancies reported by the user and finding the root cause of such data discrepancies.
Bug identification and Fixing.
Enhancement according to new requirements.
Analysis of certain existing mappings, which were producing errors and modifying them to produce correct results.
Perform Defect Pareto Analysis on the Defects identified during a mentioned period.
Plan for Future Action Items to facilitate process and quality improvement
Involved in performance tuning of source, target and mappings.
Assist in designing reusable ETL components, such as mapplets and worklets, to make the processing more efficient and easier to maintain.
Unit Acceptance testing to ensure that data is loaded as per ETL specifications.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship