SUMMARY

• Over 8+ years of experience in Information Technology with strong business understanding of Banking, Insurance, Finance and Pharmaceuticals - Healthcare, Logistics and Marketing.
• 8+ years of Data Warehousing experience using Informatica Power Center 9.6/9.5/8.6/8.1/7.1 , Data Quality (IDQ) (8.x, 9.x) .
• 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.
• Expertise in working with Teradta and vertica.
• 8+years experience in dealing with various data sources like Oracle, SQL Server, Excel, Flat files, DB2.
• Excellent working knowledge using Facet Domains, UNIX shell scripting and job scheduling.
• Expertise in Installing and Maintaining Informatica PowerCenter, Metadata Manager, Data Explorer and Data Quality.
• 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.
• Good experience in working in Data Mart environment and Data modeling.
• 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 and SQL Server
• 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.
• Utilized Informatica Data Quality (IDQ) extensively for loading the data into Informatica MDM Hub.
• Involved in creating custom and auto profiles using IDQ and also involved in creating IDQ rules.
• Experience in improving the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
• Installed, maintained and provided production support from infrastructure perspective forInformatica Data Quality 9.x, Informatica Information Lifecycle management (ILM 9.x).
• Provided subjects matter expertise in Informatica 9.x, Power Center, PowerExchange, Cloud Data Integration, Informatica Data Quality (IDQ), Information Lifecycle Management (ILM)( TDM 9.x, DA 6.x), Informatica Proactive Monitoring for PowerCenter Operations (2.x)and JAWs (4.x,5.x).
• Installed and configured the following IDQ 9.x components on AIX UNIX Servers DQ Content Basic, DQ Content Accelerator and DQ Content IMO.
• Responsible for internal design of Informatica mappings to achieve the desired business results
• Worked with different source systems- Oracle, flat files,XML sources.
• 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 Informatica SCD type-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.
• Validate data accuracy in production, Develop plans to remediate the data if errors are found
• 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.6, 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.
• Expert in parsing XSD and EDI files and API'S to generate Xml, flat file and sends them to end users.
• Expert in bteq/vsql scripts to process data and load bulk data from flat files to vertica.
• 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.
• Created mappers and parsers in informatica B2B Data Transformation.
• Expert in set up trading partners.
• 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 Lead 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.
• Created end points in Data exchange and set up trading partners.
• 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