SUMMARY:

• 6+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
• 6+ years of experience as an ETL Developer analyst using Informatica Power Center 10.1/9.5/9.1/8. x/7.1 as ETL tool.
• 6+ years of hands on experience form level using Oracle 12C/11g/10g/9i, SQL, SQL PLUS and TOAD Quest Software database.
• 1+ years experience in using PL/SQL.
• Experience in analyzing the Dimensional data modeling, Star/snowflake Schema modeling using ERWIN 7.3/4.0.
• Extensive experience in Extraction, Transformation and Loading using XML, flat files, web service, CSV and relational database.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Experience in preparing ETL design documentations, user test case documentation.
• Over 1 years of experience in writing UNIX Scripting for various ETL jobs and process automation.
• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business related problems.
• Worked in a team environment consisting of technology and business professionals.
• Excellent understanding of business procedures and ability to work as an individual as well as part of a team.
• Worked with Onsite offshore team structure.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.5/9.1/8. 6/8.1, Informatica B2B

Operating systems: AIX, Sun Solaris, Linux, Windows 2012/2007/XP/98.

Programming Languages: SQL, PL/SQL, UNIX Shell scripting

Databases: Oracle 12c/11g/10g/9i, SQL Server 2008/2000, DB2, Netezza, Sybase

Database tools: SQL * Loader, Toad, SQL Developer, Agility Workbench

Data modeling tool: MS Visio, Erwin 7.3/4.0

Reporting & Scheduling Tool: Tidal, Tivoli

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Programmer/Analyst Level III

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
• Developed business requirements document (BRD) based on business objectives, facilitated joint sessions.
• Analyzed business and system requirements to identify system impacts.
• Created flow diagrams and charts.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Worked on some performance tuning.
• Performed code reviews as well as set some new standards.
• Followed through with release engineers to make sure my code got deployment to production went smoothly.
• Worked heavily with flat files and xml file sources.
• Involved in on call production support rotation.

Environment: Informatica Power Center 10.1, Oracle, Sybase, MS SQL Server, Toad 4.3, Perl Scripting, Flat Files, Tivoli Scheduler, Visual Studio, JIRA, Confluence, XML Spy

Confidential, Phoenix, AZ

Sr. Informatica Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
• Developed business requirements document (BRD) based on business objectives, facilitated joint sessions.
• Analyzed business and system requirements to identify system impacts.
• Created flow diagrams and charts.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Done Modeling and populating the business rules using mappings into the Repository for Metadata management.
• Created, Tested and debugged the triggers using PL/SQL developer.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Configured the workflow to remember the last time data was extracted from the source and configured parameter for each mapping so that only changed records can be extracted the next time it is run.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.
• Performing ETL & database code migrations across environments using deployment groups.

Environment: Informatica Power Center 9.5/9.1, Netezza Database, Toad, UNIX Shell Scripting, Oracle, SQL Server, Flat Files, Tidal Scheduler, Informatica B2B MFT, JIRA, Confluence

Confidential, Montvale, NJ

Informatica Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
• Developed business requirements document (BRD) based on business objectives, facilitated joint sessions.
• Analyzed business and system requirements to identify system impacts.
• Created flow diagrams and charts.
• Developed Logical and Physical data models that capture current state/future state data elements and data flows using
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Developed restart token on UNIX server for Real-time Informatica workflows and customized real-time Power Exchange workflows.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.
• Used OBIEEDAC to Schedule the Informatica mappings in the correct order, dependencies between them based on the sources and targets.
• Configured the workflow to remember the last time data was extracted from the source and configured parameter for each mapping so that only changed records can be extracted the next time it is run.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.
• Performing ETL & database code migrations across environments.

Environment: Informatica Power Center 9.1/8.6, Power Exchange 9.1, Toad, UNIX Shell Scripting, Oracle, SQL Server, Flat Files, Informatica Scheduler

Confidential

Sr. Informatica Developer

Responsibilities:

• Prepared the ETL design documentations and Unit test case.
• Work on onsite-offshore model. Participated in daily status call with offshore and onsite team.
• Review progress of development and promptly updating clients.
• Developed and reviewed mappings to extract data from flat files into staging tables and from the staging area to the dimension tables and fact table.
• Extensively worked on Data Integration of data from various database source systems and mainframe Cobol and VSAM files.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Error handling is done by validating the records and bifurcating the data into valid/invalid records and loading the erroneous records into the error table.
• Used SQLT to update the status of the records in the error log table when valid records are received from the source system.
• Designed and developed process for Audit table, which is used in the mappings to capture the run statistics.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Expert in tune code using partitioning like round robin, hash auto key, key range and caching at mapping and session level.
• Extensively used PowerExchange to create datamaps, registration to connect to Mainframe.
• Maintained Development, Test and Production mapping, migration using Repository Manager also used Repository Manager to maintain the metadata, Security and Reporting.
• Worked on the UNIX shell scripts to create job to run the workflows by scheduler.
• Reviewed Informatica code, PL/SQL code and UTC docs.
• Performed three levels of Unit testing, validated the data and documented status and bugs using Jira.
• Wrote scripts for bulk load process MLOAD and FLOAD. Worked extensively on BTEQ.
• Worked on the System integrated testing and supported the IST and UAT phases of the project.
• Interacted with upstream and business partners in providing feedback and recommendations for system testing and additional requirements.
• Supported clients through testing, troubleshooting and deployment of the solution.
• Involved in production support and resolving environment and report issues proactively.
• Tracing heat tickets and maintain knowledge database for that to resolve issues quickly in future.

Environment: Informatica Power center 9.1, Informatica PowerExchange 9.1, Oracle 11g, PL/SQL Toad, DB2,Linux, Autosys, Putty, WinScp, Jira, Teradata 13.0, XML, Web Services, SCM.

Confidential, Atlantic City, NJ

Informatica Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Created Teradata Scripts for loading the target tables.
• Designed and developed many simple as well as Complex Mappings, various transformation logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Designed the ETL processes using Informatica tool to load data from File system and Oracle into the target Oracle Database.
• Involved in identifying the sources for various dimensions and facts for different data marts according to star schema design pattern.
• Developed various reusable Informatica components like reusable transformation, mapplets, sessions.
• Created Datamap, restart token and registration for CDC.
• Responsible for Performance Tuning at the Source, Target, Mapping and Session Level.
• Extensively used both Connected and Unconnected Lookup Transformations. Developed slowly changing dimension, according to the data mart schemas.
• Developed multiple Workflows using workflow manager for initial loading, historical data loading using sessions, worklets, commands, decisions, events and timers.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter
• Used Informatica user defined functions to reduce the code dependency.
• Used debugger to track the path of the source data and also to check the errors in the mapping.
• Performing ETL & database code migrations across environments.
• Provided production support by running the jobs and fixing the bugs.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.1, Power Exchange 8.1, Unix Shell scripting, Linux, Oracle 10g, SQL Server 2008, PL/SQL, XML, Harvest, flat files, WinSCP, DB2

Confidential, MT Laurel, NJ

Informatica Developer

Responsibilities:

• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Analyzed and modified existing online and batch programs to implement new/enhance business functionality.
• Migration of Informatica folders from Non-vault environment to vault environment.
• Created specification and mapping design documents based on the data models and data available in source systems.
• Developing stored procedures, views, and adding/changing tables for data load, transformation and data extraction.
• Developing Mappings as per the Design Document with proper naming Conventions for Transformations and Mapping Variables.
• Coordinate with offshore development team in Infrastructure and Integration Projects.
• Migrated ETL objects to QA, UAT and Production environments.
• Performed data load from various customers as part of production activity.
• Responsible for applying business logic and data cleansing in staging data.
• Involved in extraction, transformation and loading of data from OLTP to OLAP.
• Performed data consistency check and Performance tuning.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Involved in optimizing code and improving efficiency in databases including re-indexing and performing other maintenance tasks.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.

Environment: Informatica Power Center 8.1, Toad, Linux, UNIX Shell Scripting, Oracle 10g, SQL Server 2008,