We provide IT Staff Augmentation Services!

Informatica Etl Developer Resume

4.00/5 (Submit Your Rating)
Hire Now

PROFESSIONAL SUMMARY

  • Experience in Repository Configuration, creating Informatica Mappings, Mapplets, Sessions, and Worklets, Workflows, processing tasks using Informatica Designer / Workflow Manager to move Data from multiple source systems to target.
  • 3 years experience in performing Informatica/ETL processes wif Informatica Power Center 10.1. Experience in all phases of teh Data Warehouse project life cycle including Requirement Gathering, Design, Development and Testing Experience in Oracle Data Integrator, SQL developer & Microsoft SQL Server.

TECHNICAL SKILLS

  • Informatica PowerCenter 10.1
  • TSQL Microsoft Excel
  • Oracle SQL Developer
  • Dropbox Microsoft SQL Server
  • Microsoft Word
  • Microsoft SharePoint
  • Microsoft Power Point
  • Microsoft Outlook
  • Troubleshooting and debugging
  • CorelDRAW Graphics Suite

PROFESSIONAL EXPERIENCE

Confidential

Informatica ETL Developer

Responsibilities:

  • Develop mappings dat perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in teh mappings.
  • Finished 6 months project ahead of schedule in 4 ½ months
  • Completing multiple projects simultaneously ahead of deadlines
  • Executing unit tests and validating expected results; iterating until test conditions has passed
  • Multi - master replication of data to backup instances and data warehouse testing and development environments
  • Created complex mappings dat involved implementation of Business Logic to load data in to staging area.
  • Created Worklets, Workflow and Tasks to schedule teh loads at required frequency using Workflow Manager.
  • Created reusable email tasks in Workflow manager for process exception handling.
  • Participatedin user meetings, gatheird Business requirements & specifications for teh data warehouse design. Translate teh user inputs into ETL design docs.
  • Optimized performance tuning at source, target, mapping and session level.
  • Implemented slowly changing dimension methodology for accessing teh full history of accounts.
  • Participated in-weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting teh proceedings.
  • Participate in bi weekly sprints to initiate new timeline for work delivery and process improvement techniques to ensure end users are driving any new changes to teh project.

Confidential

Junior ETL Informatica Developer

Responsibilities:

  • Work wif various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation based on user’s requirement.
  • Develop and maintain cache mechanism for different transformations defined in teh mappings
  • Created re-usable and non-reusable sessions for ETL Jobs dat runs individually or concurrently.
  • Created a scheduled workflow dat executes multiple sessions defined for it in teh workflow properties.
  • Define and research source systems and identify target output for ETL delivery.
  • Created a passive and active pass through mappings using teh distinct feature in teh Source Qualifier.
  • Manually Create table wif primary keys definition in teh source analyzer and generate a script dat creates a table structure in teh Database for non-existing tables based on requirement.
  • Define primary keys into dimension tables dat act as foreign keys in teh fact table in teh target analyzer.
  • Create a scheduled workflow dat executes multiple sessions defined for it in teh workflow properties
  • Requirement and systems specifications gathering from clients through face to face meetings to understand project stages and implementation procedures.
  • Designed a separate mapping for teh dimension and fact tables in-order to free teh workspace and also create a separate session in teh workflow manager.
  • Worked on scheduling tool and versioning to check in & check out informatica file objects.
  • Designed mappings using teh Target Load Plan to determine which table teh integration service loads first into teh target.

Confidential

Pharmacist

Responsibilities:

  • Communicated wif patients in a manner dat provided compassion but kept medical information private.
  • Provided blood pressure and blood glucose tests to patients.
  • Entered data and prescriptions into patient profiles using Datascan.
  • Answered customer questions regarding refills, insurance troubleshooting and status updates on prescriptions.
  • Proficiently processed and dispensed written, oral and electronic prescriptions.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship