SUMMARY

• 8+ years of software development and sustenance experience which includes Requirement Analysis, Design, and Development, Testing, Infrastructure migration and Release Coordination for Data warehousing applications.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Experience in interacting with Business users in analyzing the Business requirements and transforming them into documenting, designing, and rolling out the deliverables.
• Strong experience in Extraction, Transformation, Loading data from various sources into Data Warehouses using Informatica, UNIX, Oracle, Teradata, DB2 and Netezza .
• Experience in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT & Dimensions tables, Physical & logical data modeling and De-normalization.
• Experience in data conversion of various data sources like SQL Server, Fixed Width and Delimited Flat Files
• Hands on experience with mappings from varied transformations such as Lookups (connected and unconnected), Router, Aggregator, Sorter, Filter, Update Strategy, Normalizer, Sequence Generator, Joiner.
• Expertise in design and implementation of Mapplets and slowly changing dimensions - (SCDs Type I & II).
• Working in an environment where the database size is around 125 Terabytes.
• Extensively worked on advanced Informatica concepts like pipeline partitioning, concurrent workflows.
• Excellent understanding of Client/Server architecture makes a valuable asset to any project.
• Experience in working with mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Used oracle explain plan feature to identify the query execution cost, tuned the queries based on the oracle optimize plan and created Materialized views for dimension tables for good query performance
• Experience in Scheduling, Failure Reporting, Audit Trails, Data Cleansing, backup and purge strategies and Performance Testing Benchmarks.
• Experience in Unix Shell Scripting, SVN and scheduling jobs through AutoSys.
• Experience in installing, upgrading and configuring Informatica Power Center on multiple environments. Upgraded Informatica Power Center Repository from 8.x to 9.0.1, 9.1 to 9.6, Autosys, Oracle 11g and vast knowledge on data migration from legacy systems.
• Expertise in implementation of SFTP, FTP services to retrieve Flat Files from the external sources
• Experience working with onsite-offshore model, 5+ years of experience in leading a team size of 12-15 resources along with coordination, mentoring and performance evaluation.
• Extensively worked in AIP portal such as generation of dormant reports, maintenance of user profiles in database and created several automated tools which save time and manual effort.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

TECHNICAL SKILLS

Programming Languages: Oracle 10g,11g,Netezza,Teradata, SQL, PL/SQL, VB, Unix Shell Script.

Tools: & Utilities: Informatica8.1.1,8.6,9.01,9.6.1,powercenter,Metadatamanagement, Notepad++,Textpad,Putty,winSCP,SVN,Toad,Tectia,SQLDeveloper, Agnity,JIRA,HP Quality Center,Autosys iXp,Winscp

Operating Systems: Windows 9x/2000/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Whippany NJ

Senior Informatica Developer

Responsibilities:

• Perform Requirements gathering, analysis, design, implement, test and deploy applications using Informatica-power center, Teradata and UNIX Shell Scripting.
• Prepared Estimation based on the complexity and object details and Schedule, Plan Resources and Task Tracking using the utilization tracker.
• Responsible for developing, support and maintenance for the ETL processes using Informatica PowerCenter 9.x. Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings.
• Extensively worked on different types of transformations like expression, filter, aggregator, lookup, stored procedure, sequence generator and joiner etc.
• Extensively worked on performance tuning at all levels of the Data warehouse. Implemented performance tuning by using lookup caches, gathering stats, dropped indexes and re-created them after loading data to targets and increased the commit interval.
• Created parameter files and Unix Scripts for operations like file validation, report generation, data cleansing and file processing.

Environment: Informatica Power Center 9.6, Teradata 15.0, UNIX, Putty, Procmon, Winscp,JIRA

Confidential, Charlotte

Senior Informatica Developer

Responsibilities:

• Perform Requirements gathering, analysis, design, implement, test and deploy applications using Informatica-power center, Oracle,Netezza,Sql Server and UNIX Shell Scripting.
• Prepared Estimation based on the complexity and object details and Schedule, Plan Resources and Task Tracking using the utilization tracker.
• Responsible for developing, support and maintenance for the ETL processes using Informatica PowerCenter 9.x. Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Experience in integration of heterogeneous data sources like Oracle, Netezza,DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area using Informatica mappings, workflows and session objects.
• Extensively worked with various look up cache like Static Cache, Dynamic Cache, Persistent Cache, and Shared Cache.
• Developed various mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings.
• Extensively worked on different types of transformations like expression, filter, aggregator, lookup,stored procedure, sequence generator, XML parser and joiner etc.
• Extensively worked on performance tuning at all levels of the Data warehouse. Implemented performance tuning by using lookup caches, gathering stats, dropped indexes and re-created them after loading data to targets and increased the commit interval.
• Created parameter files and Unix Scripts for operations like file validation, report generation, data cleansing and file processing.
• Created shell script to connect Informatica repositories and autosys server to execute the jobs and report generation.
• Implemented SFTP, FTP services to retrieve Flat Files from the external sources, Created shell script to connect external servers using SSH, SFTP and FTP process.
• Created Oracle/Netezza DML routine entries and SQL packages for the operational maintenance of data flow.
• Extensively worked in the Oracle exchange partition concepts, HCC and compression processes for the fact data loads.
• Increased Code Reusability using Shortcuts, Mapplets, Reusable Transformations and Reusable Sessions to reduce redundancy in code.
• Involved in code reviews developed by team mates before moving the code into QA.
• Migrated Workflows, Mappings, and other repository objects from Development to higher environments and coordinated for SIT and UAT sign off.
• Created test cases and involved in Unit testing, System Testing, User Acceptance Testing to verify accuracy followed by regression testing and completeness of ETL process.
• Involved in monitoring the workflows and optimizing the load times using session partition, concurrent workflow concepts.
• Created Autosys JIL (Job information Language) to schedule the jobs through autosys scheduler.
• Extensively worked on infrastructure migration/up gradation project like Informatica 9.5 to 9.6.1, Autosys 4.5.1 to R11, oracle, Netezza,DB2 which involves extensive testing of 200 Jobs and generation of performance reports and data validations.
• Involved in design and implementation of dashboard application for the entire project which has end to end information of the compliance project.
• Involved in release management process, code packaging and providing sign off for the deployment.
• Involved in Creation of automated tools like mapping generator, JIL creator, Data copy, UTP creator and Informatica code migration which saves time and manual effort.
• Created Run books for warranty support team and schedule meeting to explain the approach and troubleshooting techniques.
• Worked on other tools like WinSCP for transferring the files from Windows to UNIX and vice-versa, Putty for connecting to UNIX and run the scripts.

Environment: ETL, Informatica Power Center 9.x,Oracle 11g, PL/SQL,Netezza,DB2, Sql Server 2008,UNIX, HP - Quality Centre, Autosys,Tectia

Confidential, Charlotte

Senior Informatica Developer

Responsibilities:

• Perform Requirements gathering, analysis, design, implement, test and deploy applications using Informatica-power center, Oracle,Netezza and UNIX Shell Scripting.
• Prepared Estimation based on the complexity and object details and Schedule, Plan Resources and Task Tracking using the utilization tracker.
• Responsible for developing, support and maintenance for the ETL processes using Informatica PowerCenter 9.x. Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Experience in integration of heterogeneous data sources like Oracle, Netezza, SQL Server and Flat Files (Fixed & delimited) into Staging Area using Informatica mappings, workflows and session objects.
• Extensively worked with various look up cache like Static Cache, Dynamic Cache, Persistent Cache, and Shared Cache.
• Developed various mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings.
• Extensively worked on different types of transformations like expression, filter, aggregator, lookup, normalizer,Java,stored procedure, sequence generator, and joiner etc.
• Extensively worked on performance tuning at all levels of the Data warehouse. Implemented performance tuning by using lookup caches, gathering stats, dropped indexes and re-created them after loading data to targets and increased the commit interval.
• Created parameter files and Unix Scripts for operations like file validation, report generation, data cleansing and file processing.
• Created shell script to connect Informatica repositories and autosys server to execute the jobs and report generation.
• Implemented SFTP, FTP services to retrieve Flat Files from the external sources, Created shell script to connect external servers using SSH, SFTP and FTP process.
• Created Oracle/Netezza DML routine entries and SQL packages for the operational maintenance of data flow.
• Extensively worked in the Oracle exchange partition concepts, HCC and compression processes for the fact data loads.
• Increased Code Reusability using Shortcuts, Mapplets, Reusable Transformations and Reusable Sessions to reduce redundancy in code.
• Involved in code reviews developed by team mates before moving the code into QA.
• Migrated Workflows, Mappings, and other repository objects from Development to higher environments and coordinated for SIT and UAT sign off.
• Created test cases and involved in Unit testing, System Testing, User Acceptance Testing to verify accuracy followed by regression testing and completeness of ETL process.
• Involved in monitoring the workflows and optimizing the load times using session partition, concurrent workflow concepts.
• Created Autosys JIL (Job information Language) to schedule the jobs through autosys scheduler.
• Extensively worked on infrastructure migration/up gradation project like Informatica 8x to 9x, Autosys 4.5.1 to R11, oracle 11g, Netezza which involves extensive testing of 200 Jobs and generation of performance reports and data validations.
• Involved in release management process, code packaging and providing sign off for the deployment
• Involved in Creation of automated tools like mapping generator, JIL creator, Data copy, UTP creator and Informatica code migration which saves time and manual effort.
• Created Run books for warranty support team and schedule meeting to explain the approach and troubleshooting techniques.
• Worked on other tools like WinSCP for transferring the files from Windows to UNIX and vice-versa, Putty for connecting to UNIX and run the scripts.

Environment: ETL, Informatica Power Center 8.x, 9.x,Oracle 11g, PL/SQL,Netezza, UNIX, HP - Quality Centre, Autosys,Tectia

Confidential

Developer

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Lookup, Filter, Expression, Sequence Generator and Router to develop robust mappings in the Informatica Designer.
• Extensively worked with Lookup transformation both Connected and Unconnected.
• Developed mapping parameters and variables to support SQL override.
• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and oracle/Netezza tables to target tables.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance.Converted the store procedure and UDF in oracle and also migrated the informatica mappings and workflows into netezza.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Modified existing mappings for enhancements of new business requirements.
• Preparation of UTP (Unit Test Plan) with all required validations and test cases.
• Migrated the code into QA and supported QA team for testing.
• Involved in the maintenance, bug fixes & request analysis of the existing reports.
• Created UNIX shell scripts to process and validate the files and schedule the jobs.
• Generated Reports for run details and performance validation
• Constantly interacted with on-site team and designers to discuss the requirements.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: ETL, Informatica Power Center 8.x, Informatica Power Center 9.x,Oracle 11g, PL/SQL, Netezza,UNIX, HP - Quality Centre, Autosys,Tectia