We provide IT Staff Augmentation Services!

Informatica Developer Resume

3.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Over 7 years of IT experience in doing analysis, System Design, Development and maintenance.
  • Over 5 years of strong Data Warehousing ETL experience of using Informatica Power Center 8.x/7.x/6.x, Mappings, Mapplets, Transformations, Autosys, OLAP, OLTP and Data Marts.
  • Solid experience in Designing/Developing/Optimizing/Tuning mappings using Informatica.
  • Sound experience in Oracle, MS SQL Server, flat files, COBOL files, SQL, DB2, PL/SQL and SQL*Loader.
  • Extensive experience in error handling and debugging.
  • Expertise in tuning the performance of the mappings and sessions in Informatica and determining the bottlenecks.
  • Experience in working with VLDB (Very Large Databases).
  • Involved in documentation related to detailed work plans, mapping documents and high-level data models. Worked with Production support team for maintaining the mappings, sessions and workflows.
  • Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development, Scrum, eXtreme Programming (XP), Lean Analysis, mixed methods, RAD and RUP
  • Involved in full life cycle development of Data Warehousing.
  • Experience includes good domain knowledge of Insurance, Banking, Healthcare and Financial System.
  • Worked in a fast paced team environment with excellent communication skills.

TECHNICAL SKILLS:

Data Warehouse Tools : Informatica Power Center 8.6.1, 8.1.1/ 7.1,
Informatica Power Exchange
Database : Oracle, SQL Server, Teradata, DB2, XML, COBOL.
Business Intelligence Tools : Business Objects XIR2, XIR3, 6.5/6.0, Cognos.
Programming Languages : SQL, PL/SQL, UNIX shell scripts, C, C++
Operating Systems : UNIX, Windows NT/2000.

PROFESSIONAL EXPERIENCE:

Confidential, NYC
ETL Developer Jan 11-Present

OTC Clearing: The project deals with the reporting of OTC cleared and Bi-lateral deals for both Prime Brokerages and Non-Prime Brokerage clients.There are other initiatives associated with the overall OTC Clearing project which will be managed and executed by other teams. These projects serve as a source of data for CRC(Client Reporting Centre) for its Non-Margin reporting purposes. CRC has to be integrated with the other streams for successfully implementing the non-margin reporting functionalities across different clients.

Responsibilities:

  • Work with the Business analysts for gathering functional requirements and analysis.
  • Design and develop mappings, workflows to pull data from different source systems like Arctic (MS SQL Server Views), GMI (Flat Files) and Aurora (Flat Files).
  • Involved in designing the whole flow, right from the interface with the source systems to the final delivery of the reports.
  • Involved in Unit Testing and Performance tuning of Informatica mappings
  • Deployment of ETL and DB changes to higher environments.
  • QA and UAT support
  • Used Debugger for debugging Mappings
  • Data quality checking and interacting with the business analysts
  • Analyzed the impact of changes on the existing systems
  • Design and Development of Unix shell Scripts
  • Generated reports using Cognos

Environment: Informatica8.6.1, Oracle11g, SQL Server 2008, Flat Files, PL/SQL, SQL, TOAD 10.2, HP Quality Center, Cognos, UNIX, Windows XP.

Confidential, Chicago Nov 09 to Dec 10
Informatica Developer

Worked as a team member of DI-COE (Data Integration Center of Excellence) which was shared services portfolio and offers ETL Infrastructure, development needs to various other portfolios in the organization.
Project: - Claim Data warehouse (CDW). Worked on enhancements for CDW project which provides Policy Transactions, Premium and Claims Transactions data to the business users. Users want to measure profit over time by coverage, coverage item type, and geographic, demographic and sales distribution channels.

Responsibilities:

  • Analysis of application requirements in consultant with the business users and other technical team members.
  • Design of data flows using Informatica PowerCenter.
  • Responsible for arranging periodic status calls with offshore coordinating development efforts and making sure everything is well organized.
  • Developing complex Informatica mappings using different types of transformations like Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression, Normalizer and Update strategy transformations for large volumes of Data.
  • Unit and Regression testing of the Informatica Mappings
  • Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
  • Worked with session logs, Informatica Debugger and Performance logs for error handling when session fails.
  • Defining Mapping / Session parameters to maintain standards and reusability.
  • Performance tuning of longrunning jobs.
  • Worked on Autosys to Schedule jobs.
  • Effectively utilized Business Objects for reporting purpose.

Environment: Informatica PowerCenter 8.6.1/8.1, Power, Oracle 11g/10g, SQL Server 2008, TOAD, Business Objects, Flat files, PL/SQL, Autosys, UNIX, Windows XP.

Confidential, Pittsburg
Informatica developer Feb 09 to Oct 09

Confidential, is a diversified financial service company that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. The Data Mart was primarily designed to provide Marketing Managers with the complete understanding of customer pattern (market based analysis) and their preference (Trend Analysis). This data warehouse was later extended to cater the needs of Sales, Marketing and Human Resources.

Responsibilities:

  • Worked with Business Analysts in requirements gathering, business analysis and project coordination.
  • Analyzed the source data coming from different sources like Oracle, flat files, XML, SQL Server and worked with business users and developers to develop the model.
  • Developed data Mappings between source systems and warehouse components.
  • Worked closely with data analysts & multiple business users identify key information that will enhance business decision-making.
  • Assisted in Designing of logical Data model using Erwin Tool.
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
  • Used SQL loader effectively to improve ETL performance when dealing with large loads.
  • Performed Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
  • Using of SQL tools like TOAD to run SQL queries to validate the data.
  • Responsible for Using Autosys and workflow Manager Tools to schedule Informatica jobs.
  • Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor

Environment: Informatica Power Center 8.1.1/7.2, Oracle 10g/11g, TOAD, SQL Server 2005, DB2, Flat Files, PL/SQL, Cognos, Autosys, UNIX, Windows XP.

Confidential, VA
Informatica Developer Jan 08 to Jan 09

Confidential, is the nation’s leading provider of saving, planning and paying for education programs. Their Core business is Student Loans. Data Improvement Project (DIP) is to address issues with access and consistency of information for business stakeholders. In DIP, data populated from different sources like Flat files, MS SQL Server, DB2 and RDBMS to Oracle database and Flat files.

Responsibilities:

  • Working with the Business analysts for gathering functional requirements and analysis.
  • Responsible for taking Strategic decisions for Complex Process including analyzing 20 years old huge financial legacy data.
  • Working with DBA and Data Modelers.
  • Responsible for Detail design of each interface.
  • Used different types of transformations like Source Qualifier, Normalizer, Connected and Unconnected LOOKUP, Router, Joiner, Filter, Aggregator, Expression and Update strategy transformations to develop complex Informatica mappings.
  • Performed Unit and Regression testing of the Informatica Mappings created.
  • Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
  • Performance tuning the Informatica mappings to increase the performance.
  • Troubleshooting database, workflows, mappings, source and target to find out the bottlenecks and improved performance.
  • Responsible to co-ordinate with Product, SIT, CAT, Performance test teams to fix the Informatica Code defects and various performance related issues.

Environment: Informatica PowerCenter 8.1.1, Power Exchange, Oracle 10g/11g, DB2, Flat files, MS SQL Server, Cognos, Control-M, TOAD 9.0, PL/SQL, SQL, UNIX (AIX), Unix Sell Scripting, Windows NT.

Confidential, FL
ETL Informatica Developer Feb 06 – Dec 07

Confidential, is the largest not-for-profit health care organization in the region. Its network of services extended with Baptist Hospital of Miami, Baptist Children's Hospital, South Miami Hospital, Homestead Hospital, Mariners Hospital, Doctors Hospital and Baptist Cardiac & Vascular Institute. The project deals with decision support system, where the information about various entities are integrated and stored in data marts (Point of Service and Care Discovery). These data marts assists various department managers in their decision making process by trending and forecasting.

Responsibilities:

  • Worked with business analysts to identify appropriate data sources for Data Warehouse
  • Analyzed the source data coming from different sources like Oracle, flat files, XML, DB2, SQL Server and worked with business users and developers to develop the model.
  • Responsible for creating, testing and validating the Informatica mapping against the predefined ETL design standards.
  • Responsible for Unit and Regression testing of the Informatica Mappings created.
  • Involved in creating simple to complex mappings using transformations like expression, router, source qualifier, update strategy, joiner, lookup, filter, sorter, normalizer and aggregator.
  • Optimized the mappings and debugged the existing mappings to fix various issues in production.
  • Analyzed the various bottlenecks at source, target, mapping and session level.
  • Involved in performance tuning to get optimal performance.
  • Created UNIX wrapper scripts and shell scripts for individual sessions to automate the process.
  • Involved in user acceptance testing and system testing while creating and validating the test scenarios and business requirements.
  • Involved in deployment of Informatica mappings and sessions from development to test and then to production.
  • Documented the entire process for future maintenance and support.

Environment: Informatica Power Center 8.1/7.1, Power Exchange, Oracle 8i/9i, SQL Server 2005, Business Objects, COBOL, PL/SQL, SQL, UNIX (AIX), Unix Shell Scripting, Windows XP.

Confidential, India
Software Engineer Aug 04 to Nov 05

Responsibilities:

  • Interacted with end users for gathering requirements.
  • As a part of 3-member team, was involved in design, development and implementation of the module.
  • 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 9i, MS Excel, PL/SQL, HTML, UNIX, C, C++, Windows 98.

EDUCATION:

Bachelors of Technology in information technology

We'd love your feedback!