Informatica Developer Resume

SUMMARY

Develop Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected lookup, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router. Writes and optimize SQL queries using Toad and SQL Server 2008. An excellent team player with business users, program managers, and team leads, architects and other team members maintaining healthy work environment.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
Extensive experience in ETL design, development and maintenance using oracle SQL, PL/SQL, SQL Loader, Informatica power center 9.x, & 10.
Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
Involved in extracting data from Flat Files and Relational database into staging area
Mappings, sessions, workflows from Developments to Test and then to UAT
Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a Star Schema
Developed Informatica Mappings using Aggregator, SQL Overrides in Lookups, source filer usage in source qualifiers, and data flow management into multiple target using Router.
Created sessions and extracted data from Various Sources, transformed data according to the requirement and loading into data warehouse.
Used Teradata as a source system.

Confidential

Data Analyst

Responsibilities:

Manipulated, cleaned & processed data using Excel, Access and SQL.
Loaded extracted and conducted data validation of client data.
Analyzed raw data, drawing conclusions & developing recommendations. Writing SQL scripts to manipulate data for data loads and extracts.
Performed daily system checks. Data entry, data auditing, created data reports & monitored all data for accuracy.
Monitored the automated loading processes to ensure complete and successful data loading.