SUMMARY:

• 5 years of IT experience in Data Warehouse development and Business Intelligence projects.
• 5 years of experience as an ETL Developer analyst using Informatica Power Center 9.5/9.1/8.x/7.1 as ETL tool.
• 2 years of hands on experience in writing, testing and implementation of triggers, stored procedures, functions, and packages at database level and form level using Oracle 11g/10g/9i, SQL, PL/SQL, SQL PLUS and TOAD Quest Software database.
• Over 2 years of experience on real - time data warehouse development using CDC tool Informatica Power Exchange 9.1/8.6.
• 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, MQ Series, web service, Informatica Power Exchange, .CSV and relational database.
• Experience in preparing ETL design documentations, user test case documentation.
• Over 1 years of experience in Teradata using queries and utilities like BTEQ, MLOAD, FLOAD and TPUMP.
• Over 2 year of experience in writing UNIX Scripting for various ETL jobs and process automation.
• Excellent communication skills, technically competent and result oriented with strong problem solving skills.
• 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 PowerCenter 9.5/9.1/8.6/8.1, PowerExchange9.1/8.6

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

Programming Languages: SQL, PL/SQL, UNIX Shell scripting, C, C++, V.B 6.0, .Net, JAVA

Databases: Oracle 11g/10g/9i, SQL Server 2008/2000, DB2, Teradata 13/12.

Database tools: SQL * Loader, Toad, SQL Developer

Data modeling tool: MS Visio, Erwin 7.3/4.0

Reporting & Scheduling Tool: Cognos 7.0, ESP, BO, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, Egg Harbor Township, 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.
• 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.
• 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 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.

Environment: Informatica Power Center 9.1/8.6, Power Exchange 9.1, Toad, UNIX Shell Scripting, Oracle, SQL Server, Flat Files, Mercury Quality Center, MS Project, HL7, IBM Initiate, NCA Mainframes for CA7 Job Scheduler.

Confidential, Phoenix, AZ

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 around robin, hash auto key, key range and caching at mapping and session level.
• Extensively used Power Exchange to create data maps, registration to connect to Mainframe.
• Created restart token, Warm and cold start wrapper, recovery process and configured real-time Informatica workflows.
• 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 Power Exchange 9.1, Oracle 11g, PL/SQL Toad, DB2, Linux, Autosys, Putty, WinScp, Jira, Teradata 13.0, XML, Web Services, SCM.

Confidential, Galloway, 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 Filesystem and Oracle into the target Oracle Database.
• Involved in identifying the sources for various dimensions and facts for different datamarts 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