We provide IT Staff Augmentation Services!

Informatica Developer Resume Profile

Richmond, VA

Summary

A self-motivated and result oriented professional with in-depth experience in full system life cycle Software Development, System Integration, Data Modeling - logical and physical, and various implementations using leading edge technologies in Data warehousing, Client server and legacy systems. Successfully performed tasks in various roles under tight deadlines like developing, supporting after go live and business analyst depending upon the phase of the project life cycle for projects in industries like Finance and Service oriented.

Professional Experiences:

  • I have total 9 yrs. of IT experience in doing analysis, design, development and implementation of Business Application systems for different sectors like Financial, Manufacturing and Service oriented.
  • I have 8 years of Strong Data warehouse ETL experience using Informatica Power center Designer, Power center Workflow Manger, Power center Workflow Monitor.
  • I have 4 years of Data modeling experience using Star Schema/Snowflake Schema modelling. As a senior Informatica resource, I involve in the Data modelling meetings to understand the relation between the different entities Dimension tables and Fact tables and attributes.
  • Thorough understanding of Kimball and Bill Imon methodologies.
  • I have 4 years of Business Intelligence experience in Business Objects, Actuate, and MS Access Reports.
  • I have very wide range of database experience, working on Oracle, MS SQL Server, flat files, XML files, COBOL files, SQL, XML, DB2, Teradata, PL/SQL, SQL Plus, SQL Loader and Developer 2000.
  • Completed documentation in relation to detailed work plans, mapping documents and high-level data models.
  • I have handled 1 TB data independently and have used DVO for data manipulation ETL- Informatica for large set of data to fulfill the business requirement.
  • I have installed Informatica DVO and have skills to configure too.
  • I have performed data masking, data validation and unit testing.

Technical Skills:

Data Warehouse Tools : Informatica PowerCenter 9.0.1, 8.6.1, 8.5, 8.1.1/ 7.1. ,

BODI 11.7, BODS 3.0, Data Validation Option Informatica DVO

Data base : Oracle, DB2, XML, Teradata, SQL Server, COBOL.

Message Systems : MQ Series, JMS.

Business Intelligence Tools : Business Objects XI R2, 6.5/6.0., Cognos, Actuate 8.

Programming Languages : SQL, PL/SQL, UNIX shell scripts, C, C ,

TSQL, TOAD, COBAL.

Operating Systems : UNIX, Windows NT/2000

Work Summary

Confidential

Informatica Developer

Responsibilities:

  • Work with business users, project management, and ETL team to understand and clarify analytic reporting needs and design appropriate solutions
  • Migrate source data to data warehouse and populate data marts to support reporting and analytics
  • Design Data mapping documents and work with team as to comply with business requirements with different Informatica transformations
  • Prepare functional specification for the development work
  • Handled responsibility as Data Analysis role and involved on reverse engineering tasks
  • Perform Independent user testing in Quality Center
  • Schedule Informatica jobs with Control-M
  • Support ETL errors and capture the bottle necks and assist in performance tuning
  • Tune cubes, support generation of Universe s and reporting solutions
  • Make recommendations for design and tuning of warehouse aggregations to streamline
  • Responsible for Unit and Regression testing of the Informatica mappings created as per business requirements
  • Assists as a technical mentor in training for less-experienced development staff
  • Responsible on performance tuning

Environment: InformaticaPowerCenter 9.0.1, Informatica Power Exchange 9.1.1, Business Objects XI R2, DVO 9.5.0 Oracle 11g/9i, SQL Server 2008R2EE, Microsoft Student Management Studio, Mercury Quality Center, SQL Developer, Flat files, TOAD, Visio, PL/SQL, SQL, UNIX AIX , Unix Sell Scripting, Soap Ui Pro 4.5.0, Windows 7.

Confidential

Informatica Developer

Responsibilities:

  • Worked on Affordable Care Act Project ACA
  • Meet with business stakeholders and technical teams to gather analyze the requirements
  • Developed a Process Flow Diagram as to conduct a baseline discussion with the clients and stakeholders
  • Worked on Requirement traceability Matrix document in conjunction with Client's requirement and technical team members
  • Heavily worked with Data Modelers, ETL team and Test leads as per the project's needs
  • Responsible for creating different Power center mappings using transformations like Joiner, Union, Update Strategy, Connected lookup, Unconnected lookup, Aggregator, Filter, Router, Normalizer etc.
  • Worked with business analysts to identify appropriate sources for data sources for data warehouse and to document business needs for decision support systems.
  • Responsible for Unitand Regressiontesting of the Informatica mappings created as per business requirements
  • Use of Oracle tool, SQL Developer andToad to run the sql queries and validate data
  • Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
  • Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
  • Developed a Plan for InformaticaData Validation Optionopportunities for the project
  • Developed solutions with the use of different functionalities of DVO
  • Demonstrated proto-type for the clients
  • Upon approval, implement DVO solutions
  • Work closely with IRS, Implementation and Testing team
  • Maintenance and support after the implementation of DVO
  • Seek more opportunities and develop solutions with the use of DVO in different areas of Project
  • Used Soap UI Pro for web service testing Project areas: Premium Tax Credit and Income and Family Size Verification

Environment: Informatica PowerCenter 9.0.1, Informatica Power Exchange 9.1.1, Business Objects XI R2, DVO 9.5.0 Oracle 11g/9i, SQL Developer, Flat files, TOAD, Visio, PL/SQL, SQL, UNIX AIX , Unix Sell Scripting, Soap Ui Pro 4.5.0, Windows 7.

Confidential

ETL Developer

Responsibilities:

  • Responsible to meet with business stakeholders and other technical team members to gather and analyze application requirements
  • Responsible for Design database solutions to satisfy application business and technical requirements
  • Responsible to implement database solutions using available database development tools like BPM, Informatica PowerCenter.
  • Responsible for providing written status reports to management regarding project status, task, and issues/risks
  • Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
  • Responsible for Unit and Regression testing of the Informatica Mappings created according to the business requirements.
  • Using of SQL tools like TOAD to run SQL queries to validate the data.
  • Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
  • Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
  • Responsible for Performance tuning of Informatica code for better performance.
  • Used Version control provided by Informatica on each and every object used. In this way, each and every version of the process will be available for recovery or research purposes.

Environment: Informatica PowerCenter 8.6/8.1, Informatica Power Exchange 8.1.1, Business Objects XI R2, Oracle 10g/9i, Flat files, TOAD, Visio, PL/SQL, SQL, UNIX AIX , Unix Sell Scripting, Windows XP.

Confidential

Informatica Developer

Responsibilities:

  • Performed data manipulations using various Informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Update strategy and Sequence generator etc.
  • Extensively used Xml source qualifier, Mid-stream XML parser transformation, Mid-stream XML generator transformations, as our main source type was XMLFiles.
  • Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
  • Extensively utilized the Debugger utility to test the mappings.
  • Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
  • Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
  • Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
  • Used Unix Scripting and Scheduled PMCMDto interact with Informatica Server from command mode.
  • Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.
  • Defined Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
  • Validated XSD using XML Spy.
  • Used CONTROL M Tool to schedule Informatica jobs
  • Generated Ad-hoc reports using Business Objects XI R2.

Environment: Informatica PowerCenter 8.6.1/8.1.1, Informatica Power Exchange 8.6, Micro Strategy, Business Objects XI R2, Oracle 10g/11g, Mainframe sources VSAM , DB2, Flat files, XML, MQ, JMS MQ, Benthic, XML Spy, RFHUtil v6.0.0, Oracle SQL Developer, TOAD 9.0, CONTROL M, Mercury, Java, Visio, PL/SQL, SQL, UNIX AIX , Linux,Unix Sell Scripting, Windows XP.

Confidential

ETL Informatica Developer

Responsibilities:

  • Worked with business analysts to identify appropriate sources for data sources for data warehouse and to document business needs for decision support systems.
  • Performed data manipulations using various informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Update Strategy, Sequence generator, etc.
  • Extensively used Data profiler to analize the source data.
  • Worked with the ETL architect to perform the load balance test and stress test.
  • Worked with marketing people to understand the requirements in a closer way.
  • Worked with fixed width and delimited flat files as major part of the data is coming from the flat files.
  • Worked with the data architects to understand the conceptional, logical and physical models of the mart.
  • Extensively utilized the Debugger utility to test the mappings.
  • Written SQL overrides in source qualifier according to the business requirements.
  • Extensively involved in Database tuning and Database performance.

Environment: Informatica Power Center 7.1, Control-M, Oracle10g, TOAD, SQL Server 7.0, PL/SQL, SQL Loader, DB2, MS Access, Erwin, UNIX, Windows 98/00/NT/XP.

Confidential

Software Engineer

Responsibilities:

  • As a part of 3-member team, was involved in design, development and implementation of the module.
  • Provided Production Support and 24x7.
  • Developed Stored Procedure to support front-end application to display potential customers for the campaign.
  • Tuned stored procedures and triggers identified for better performance.
  • Creating Tables, indexes constraints and improved database performance.
  • Involved tuning and applying the SQL statements and PL/SQL processes.
  • Creation of different kinds of reports about Tables, Views, Synonyms etc from the Oracle Database.
  • Involved in complete documentation using MS Office.

Environment: Oracle 7, MS Access, MS Excel, PL/SQL, HTML, CGI, C, C , Sun Solaris, Windows 98

Hire Now