We provide IT Staff Augmentation Services!

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.

Hire Now