SUMMARY

• Over 6+ years of experience in Information Technology with strong business understanding of Banking, Insurance, Finance and Pharmaceuticals - Healthcare, Logistics and Marketing.
• 5+ years of Data Warehousing experience using Informatica Power Center 9.6/9.5/8.6/8.1/7.1.
• 1+ years of experience in Informatica Data Quality (IDQ)
• Data modeling experience in dimensional modeling using star and snowflake schema across the Data Warehouse requirement. Strong knowledge in logical and physical data modeling.
• Extensive experience in Business Intelligence tools like Business Objects and Cognos
• 5+ years of experience in dealing with various data sources like Oracle, SQL Server, Excel, Flatfiles, DB2.
• Excellent working knowledge of UNIX shell scripting and job scheduling.
• Excellent problem solving, analytical, written and communication skills with ability to work both in team as well as an individual.
• Have sound knowledge in life cycle development of Data Warehouse: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Good experience in migrating the code across various environment and maintain the code in production
• Good understanding of relational database management systems like Oracle,SQLServer and Teradata
• Expert level experience in designing and developing code for queries, stored procedures using triggers, cursors and other utilities provided by Oracle.
• In-depth knowledge of PL/SQL with the experience in constructing the triggers, functions, user defined datatype, procedures etc.

PROFESSIONAL EXPERIENCE

Confidential, Morrisville, NC

Sr. Informatica Developer

Responsibilities:

• Responsible for requirements gathering, analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Responsible for internal design of Informatica mappings to achieve the desired business results
• Worked with different source systems- Oracle, flat files.
• Fine-tuned existing Informatica maps for performance optimization.
• Involved in the Unit testing and System testing.
• Worked on bug fixes on existing Informatica Mappings to produce correct output.
• Developed InformaticaSCDtype-I, type-II mappings and tuned them for better performance.
• Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Used reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Experience in creating Informatica Data profiles (IDQ)
• Experience in creating Informatica data visualization mappings
• Work with the DBAs re: the load performance of the ETL/database and put plans in place to address performance issues as they appear
• Defined Tidal job dependencies for automation of ETL process

Environment: Informatica Power Center 9.5, IDQ 9.5 Oracle, Toad, UNIX Shell Scripting, Flat Files, Mercury Quality Center, Tidal

Confidential, Morrisville, NC

Sr. Informatica Developer/Production Support

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems
• Identified Data Elements & Attributes both from the system requirements and reporting stand point along with the Hierarchy, Relationship between the different Dimensions & Facts
• Analyzed the different source system interfaces data from flat files & Relational DB in scope for the project based on which wrote the Integration & technical Source-Target Data Mapping rules to be loaded to the Data Warehouse
• Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment
• Handled some of the data issues in the jobs, during the release of the project to send the correct data to the business users
• Involved in Production support of the whole application & created Deployment guide, Run book, Production guide
• As a part of the Production support team, worked on fixing the issues and the failure of the ETL processes considering the minimal time constarint for quick approach of rectification

Environment: Informatica Power Center 8.6, SQL Server, UNIX Shell Scripting, Flat Files, Mercury Quality Center

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved in Requirements gathering, Business Analysis of overall scope & designed/ documented end to end Solution Approach for the Cash Data Warehouse
• Analyzed and remediated the existing Informatica mapping logic for load processes and system standards.
• Analyzed various issues logged in Remedy to understand root cause and assigned the tickets to developers accordingly
• Created PL/SQL procedures and use them as part of Informatica code
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system
• Unit tested the developed code, created test SQLs, and handled UAT issues
• Supported migration of developed components to production by using BMC Remedy User for change requests.
• Compared the code across various environments by check-in and check-out in Tortoise SVN
• Used CVS and Remedy for version control
• Involved in technical peer reviews and unit test of the code
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments

Environment: Informatica Power Center 8.6, Unix shell scripting, Oracle, SQL, PLSQL, Teradata, flat files, Maestro scheduling

Confidential, Buffalo, NY

Informatica Developer

Responsibilities:

• Interfaced with Business users for gathering the business requirements and designed user friendly templates to communicate any further enhancements needed
• Various kinds of the transformations were used to create robust mappings to implement simple and complex business logic
• Worked closely with development managers to evaluate the overall project timeline
• Extracted subscriber records with demographic, group, and dependent information for members with certain types of medical benefits from Facets data base and populated into group and member flat file
• Retrieved Group demographic and Drug plan enrollment data from Facets and formatted it in Flex America Standard Flat File Format
• Developed method for producing entire multi-format output file in Informatica
• Extensively tested the code and documented the Unit Test Cases
• Assisted the testers in system and integration testing and preparing the test cases and test plan
• Prepared File layout and System Design Specification (SDS) technical document for future references

Environment: Informatica Power Center 8.1, Facets 4.51, Toad, UNIX Shell Scripting, SQL Server, Flat Files, Mercury Quality Center

Confidential, Birmingham, AL

Informatica Developer

Responsibilities:

• Extensively used Informatica tasks like Decision, Command, Event Wait, Event Raise, and Email.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Created User Defined Functions in Informatica 8.x to reduce code redundancy.
• Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.
• Worked on developing mappings and mapplets to extract and load the data from Oracle and Flat files
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Assisted the other ETL Developers in resolving complex scenarios.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.

Environment: Informatica Power Center 8.5, Oracle 10g, Toad 7.6, Autosys, DB2, Sun Solaris Unix 2.6, Unix Shell Scripting

Confidential, Manhattan, NY

Sr. ETL Informatica Developer

Responsibilities:

• Extensively used ETL to transfer data from different source system and load the data into the target database
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse
• Extracted data from Oracle and SQL Server and load the data into target database
• Handled slowly changing dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter in source qualifier and data flow management into multiple targets using router transformations
• Provided production support by running the jobs and fixing bugs
• Involved in creating the run book and migration document (from Development to Production)
• Provide immediate response from 24/7 on system alerts, ticket requests, and user requests
• Improving the performance of the mappings by indexing and tuning
• Analyzed scripts depending on the amount of work done on daily basis to enhance the performance of Informatica
• Taking the backup of the repository at regular interval depending on the amount of work done
• Document the process for further maintenance and support
• Worked on test cases and use cases

Environment: Informatica Power center 8.1, PL/SQL, Oracle 9i, Autosys, Toad, Flat file, SQL Server, Shell Scripting

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Analyzed the data coming from different sources and their relationships.
• Interacted with business community and gathered requirements based on changing needs.
• Analyzed the architecture for Data Warehouse - star schema/snowflake model.
• Developed mapplets and re-usable transformations to prevent redundancy of transformation usage and maintainability.
• Created various documents such as Source System Analysis (SSA), ETL technical design documents, test documents while maintaining Wachovia interim standards and SOX compliances.
• Monitor, troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Involved in writing Unix shell scripting, for automation of ETL process using Autosys for running the Batches and Sessions and scheduling them to run at specified time.
• Co-ordinated with Off-Shore team in India.
• Responsible for unit testing of mappings developed.
• Provided production support by running the jobs and fixing the bugs.

Environment: Informatica Power Center 7.1, Oracle10g/9i, PL/SQL, Flat file, Unix Shell Scripting, Autosys, TOAD, Visio