Informatica Developer Resume

Preferred Industry Ü Information Technology

Over 3 years of experience in Data Warehousing and BI Technologies.
Expertise in implementing complex Business rules by creating robust mappings and reusable transformations using Informatica Power Center.
Extensive experience in Data Warehousing, ETL (Extraction, Transformation, Loading) using Informatica PowerCenter.
Expertise in Business Intelligence Tools to provide advanced Business Insights and Management Reporting.
Experience in various tools and technologies such as Databases, Data Warehousing Tools and Business Intelligence Tools.

Core Strengths
Project and Operations Management
Database Design and Analysis
Enterprise Solutions
Systems Implementation
Clients Needs Analysis
Continuous Process Improvement
Business Process Reengineering

Technical Acumen

ETL Tools
Business Software

Informatica Power Center 8.xx
SAS Enterprise Miner, XL Miner, IBM Rational Modeler, Erwin, Business Objects XI R3, Cognos Suite

Microsoft Products

Visio, MS Project, MS Office (Excel, Word, and PowerPoint)

Databases

MS SQL Server 2008, Oracle 10g/11g, and MS Access 2007

Languages

SQL, PL/SQL, UML

Credentials

Master of Information Technology and Management
Bachelor of Science in Electronics and Telecommunication Engineering
SAS Institute Graduate Certificate in Business Intelligence and Data Mining

Related Experience

Student Worker | Confidential, Richardson, Texas | May 2010-May 2011

Managed smart card publishing.
Data extraction from database using SQL Queries.
Facilitated distribution of smart cards.
Involved in Car Parking Management for UT Dallas

Informatica Developer | Confidential, | Maharashtra, India | Jul 2008-Mar 2009 and
Confidential, Maharashtra, India | Apr 2008-Jul 2009

Worked with Business Analyst, Subject Matter Experts to gather business requirements and define project scope.
Identified source systems, connectivity, tables, and fields, ensure data suitability for mapping.
Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files and Oracle source database and loading to Oracle target database.
Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression and Sequence Generator transformations.
Monitored Workflows and Sessions using Workflow Monitor.
Experience in creating Entity Relationship database models using MS Visio and Erwin.
Created SQL queries consisting of complex joins, aggregate functions and advanced SQL functions.
Created adhoc reports and dashboards in Excel, Business Objects, Cognos as per requirements.
Expertise with analytical reporting using Advanced Excel features like Pivot tables, lookup, formulas and charts.
Precise Documentation was done for all mappings and workflows.
Co-ordination with different vendors who are handling different sections of the project.

Academic Projects

Database Management Systems

Designed and implemented a database using the entity relationship modeling technique with understanding of relationships, data types, tables and queries
Forms and Reports creation using SQL Server 2008 and access database.

System Analysis and Project Management

Modeled an information system using Unified Modeling Language (UML) diagrams.
Analyzed an existing system and identified the causes of an information related problem, and designed a new system using class, sequence, ERD, Use Case diagrams to mitigate these problems.

Key Achievements

Awarded Dean's Excellence Scholarship for academic excellence by the School of Management, UTD
Promoted to Deputy Manager Level in Reliance ADA Group of Industries for portraying excellent technical, management, communication and customer support skills.
Distinction in Under-Graduate Engineering degree and Master's Degree at University of Texas at Dallas.

Affiliations and Activities

SAP User's Group at University of Texas at Dallas.
Association of Information Technology Professionals at University of Texas at Dallas.
Volunteer for spring 2010 Career Expo held at University of Texas at Dallas.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship