We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

5.00/5 (Submit Your Rating)

Farmington Hills, MI


  • 6 years of expertise experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Powercenter8.6.1/ 7.x/6.2.
  • Five years of experience in data warehousing application using ETL tool Sql, Unix, etc.
  • Expertise in implementing complex mapping transformation rules enabling loading data from Source to target Databases in a complex, high volume environment.
  • Experience in Production Support of complex applications involving complex graphs, daily execution of batches and defect management.
  • Experience in working in Unix Environment.
  • Strong Analytical, Designing, Testing and Problem solving skills.
  • Strong adherence to quality and standards.
  • Accelerate and Enhance a Wide Range of Projects
  • Informatica Data Services supports a full range of data integration projects and initiatives.
  • Able to interact effectively with other members of Business Engineering, Quality Assurance, Usersand other teams involved with the SystemDevelopment Life cycle
  • Expertise in preparing various documents related to projects such as High level design documents, low level design documents, Unit Test Cases, etc.
  • Excellent Communication skills in interacting with various people of different levels of the project.
  • Managed multiple tasks within Banking & Financial Service industries in a high - transaction processing environments with excellent analytical, business process, written and verbal communication skills.


ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Informatica Power Exchange.

BI Tools: BusinessObjectsXIR2/6.5(DesktopIntelligence,WEBI,Desinger),Cognos,Informatica Data Analyzer/Power Analyzer

Data Profiling Tools: Informatica Data Explorer(IDE)

RDBMS: Oracle 11i/10g/9.x/8.x, Teradata V2R5,DB2, Netezza4.6.8,SQL Server 2005,MS Access

Design / Application Tools: Erwin, Microsoft Visio (Visio Soft Diagram), TOAD, SQL Navigator, SQL Developer etc.Control-M, Tivoli

Languages/Scripting: SQL, PL/ SQL,UNIX Shell Scripting

Operating Systems: UNIX/LINUX, MS-DOS, Windows NT/2000/XP

Methodologies: Ralph Kimball and Bill Inmon methodologies


Confidential, Farmington Hills, MI

Sr. Informatica Developer


  • Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
  • Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
  • Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
  • Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
  • Demonstrated expertise utilizing ETL tools, including Oracle Data Integrator, Informatica, and RDBM systems like Oracle, DB2, Sybase and SQL Server.
  • Used various transformations like Source Qualifier, Joiner, Lookup, sql,router, Filter, Expression and Update Strategy.
  • Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
  • Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used Data Migration tools
  • The migration was implemented following the Kimball Methodology using MS SQL Server 2005, Analysis Services 2005, and Integration Services 2005
  • Documented Informatica mappings in Excel spread sheet.
  • Tuned the Informatica mappings for optimal load performance.
  • Mapping & design of Planet press documents/forms from SIS (AS/400 system) DB files
  • Created various Data Marts from Data Warehouse and generated reports using Cognos.
  • Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
  • Analyzed, identified, fixed bad data and imported data fromSales Force - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
  • Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
  • Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
  • Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 9.1, Power Exchange 8.1.2, Informatica Repository Manager, Oracle10g/9i, Cognos8.xDB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,SQL

Confidential, NJ

Informatica Developer


  • Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
  • Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data Consolidation, standardization, matching Trillium for the unstructured flat file data.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
  • Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
  • Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
  • Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
  • Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
  • Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
  • Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
  • Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
  • Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
  • Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
  • Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 7.1.2, Erwin3.5, SQL Scripting, Sybase,UNIX Korn Shell Programming Oracle 10g/9i, DB/2, PL/SQL, Transact-SQL.

Confidential, Charlotte, NC

Informatica Developer


  • Prepared a detailed Technical Design Document after analyzing the Functional Specifications and the Architectural Diagram. The Technical Design Document captured all functional and technical requirements.
  • Worked with different sources like Oracle, SQL Server, DB2 and flat files.
  • Performed Data Cleansing before loading it on data warehouse.
  • Developed numerous Complex Informatica Mappings, Mapplets and reusable Transformations.
  • Designed and created complex source to target mapping using various transformations inclusive of but not limited to Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
  • Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
  • Wrote PL/SQL Procedures for data extractions, transformation and loading.
  • Developed Workflows with various Tasks and Parameter files.
  • Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait, Control).
  • Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
  • Reviewed with utilities i.e. Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE).
  • Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
  • Modified pre-existing scripts and used them to automate scheduling process using Autosys.
  • Preparation of Test Cases for testing each of the interfaces which were used by the QA team.
  • Extensively used Informatica Metadata Reporter to analyze and manage repository efficiently.
  • Performed Code review to ensure that ETL development was done according to the company’s ETL
  • standard and that ETL best practices were followed.
  • Documentation of Technical specifications, business requirements and functional specifications for the Informatica mappings created for the building of the entire data warehouse.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server 2005, Oracle Designer, Teradata V2R4 / V2R5, Toad, PL/SQL, Linux, Erwin and Windows 2000 / XP.

Confidential, Seattle, WA

ETL Developer


  • Major involvement in creating and tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in Work flow monitor
  • Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator and Router Transformations.
  • Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
  • Designed the ETL processes using Informatica to load data from Flat Files, XML Files and Excel files to Oracle Staging area.
  • Designed and developed Mappings with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator.
  • Used Change Data Capture (CDC) to implement Incremental Data Extraction so that only the modified and new records will be extracted to the destination rather than full extraction
  • Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
  • Created Tasks and Workflows using Task Manager and Workflow Designer

Environment: Informatica Power Center, Work Flow Manager, Oracle 10g, Erwin, TOAD, XML, UNIX.

We'd love your feedback!