SUMMARY:

• Around 5 years of total IT experience focusing on Data warehousing and Informatica ETL process.
• Around a year of experience in Data Migration from Oracle to Teradata platform.
• I have been key in delivering innovative database /data warehousing solutions using Informatica tool to the Insurance, Finance and Telecom Industries.
• Databases: 5 years of experience using Oracle 10g, SQL, TOAD, Netezza, Teradata.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Sorter, Expression, Lookup, Aggregator, Update Strategy and Joiner.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica power center sessions as well as performance tuning of mappings and sessions.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• ETL Performance Tuning: Broad Experience in ETL tuning including effective use of Table Partitions, Sub Partitions and performance tuning Confidential transformations.
• Understanding of Dimensional Data Modeling using Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• 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.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 8.6.1, 9.0.1, 9.1.0, 9.6.1.

Databases: Oracle 10g, 11g, Teradata 12, Netezza 7.2.1.3

Other Tools: Siebel CRM, Toad for SQL server 4.5.0.854, Toad for Oracle 10g, Toad for DB2, WinSCP, Putty, SVN, Toad Data point, Aginity.

Operating Systems: Windows 10/8/7/XP.

Programming Languages: C, C++, SQL, PL/ SQL and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte

Senior Informatica Developer

Responsibilities:

• Analysis of CODE items assigned. Following agile methodology and meeting deadlines for each sprint.
• Active participation in Tech reviews.
• Learned SAS DI to extract the logic from SAS and convert it to Informatica.
• Developing Informatica mappings to extract data from Various Sources to load in to Stage, Intermediate and Datamart tables. Created various checks for data prior to load.
• Using Mapplets to load the data to control tables.
• Implemented change data capture using MD5.
• Created SCD 2 Re-Run logic while loading the data into Reference tables.
• Developed end to end mappings for major products Collateral, Derivatives, Securities, Retail and Commercial Loan.
• Developed major UNIX scripts in the project which is used across all the mappings and for migration from one environment to another.
• Created box jobs, file watcher jobs, command jobs for archiving the files and jobs to run the workflows through Autosys.
• Used Version control tool -SVN.

Environment: Informatica Power Center 9.6.1, Toad Data point 4.0, UNIX shell scripting, Autosys 11.3.5.5106, Netezza 7.2.1.3

Confidential, Rhode Island

Informatica Developer

Responsibilities:

• Development of various applications including RxEnRoll, Valencia, EDW, EDW2, Retrodur, PreFazal, Fazal, Pace Verify, AdvanceClinical(ADVC2).
• For each application, we developed mappings, sessions, worklets and workflows.
• Usage of data masking transformation logic including Key, Expression and Substitution.
• Understanding of other masking logics such as Random and Special Mask Formats.
• Working with various databases such as SQL Server, Db2, Oracle and Teradata which are related to the applications.
• Created parameter file for each application.
• Performed Unit testing.
• Used the version control tool Perforce.
• Developed scripts to automate the workflows for RxClaim, QL, Recap and Mailorder applications.

Environment: Informatica Power Center 9.0.1, Teradata 14.0, Toad for SQL server 4.5.0.854, Toad for Oracle 10g, Toad for DB2, UNIX shell scripting.

Confidential

Informatica Developer

Responsibilities:

• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle.
• Involved in creating tasks in Workflow Manager such as sessions, event wait/raise, and assignment, e-mail, and command to execute mappings.
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups.
• Created parameter based mappings, Router and lookup and SQL transformations.
• Created mapplets to reuse the transformation in several mappings.
• Used Workflow Monitor to monitor the workflows.
• Created daily and weekly workflows and scheduled to run based on business needs.
• Created Daily/weekly ETL process which maintained 100GB of data in target database.
• Involved in Unit Testing and performance testing of Informatica Mappings and created Test cases.
• Reviewed the stored procedures developed by team members in Oracle to create the ETL functionality.
• Involved in Power Center Change Data Capture (CDC) process to minimize the resources required for ETL processes that deals only with data changes and ensure data synchronicity.

Environment: Informatica Power Center 8.6.1, Oracle 10g, UNIX shell scripting.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Designed and developed Mapplets, shortcuts for faster development, standardization and reusability purposes.
• Ensured the correct application of the business rules through data query after the data is loaded into the Data Warehouse.
• Worked with DBA's in creating tables, views, stored procedures and function in Oracle for refreshing the data and scheduling them periodically.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run Confidential specified time.
• Used pre-session and post-session scripts for dropping and recreating indexes before and after loading data into target table to optimize performance for bulk loading.
• Designed and implemented processes using Parameter file to override mapping parameter, mapping variables, Workflow Variables, Session Parameters, ftp Session and Source-Target Application Connection parameters.
• Implemented UNIX and Informatica variables to synchronize the development, test, preprod and breakfix and Production environments.
• Used UNIX Shell scripts for various functionalities. Automated mappings to run using UNIX shell scripts, which included Pre and Post-session jobs and extracted data from Transaction System into Staging Area.
• Handled the Integration testing of both Home and Motor Insurance.
• Involved in production support to resolve the issues and complete the nightly process.

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL, UNIX

Confidential

Informatica Developer

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Involved in designing the new database schema and conversion of all the Oracle queries into the Teradata compatible format.
• Developed the BTEQ scripts to fetch the correct data using the Teradata database for Siebel CRM tables and Flat files which are loaded using informatica.
• Developed, tested and implemented Bteq scripts for DML, DDL and retrieval statements.
• Involved in testing the BTEQ scripts and comparing the result with Oracle database data.
• Involved in tuning the BTEQ scripts upon Business requirements.
• Extracting thousands of data from the database for data analysis.
• Developed views based on user and/or reporting requirements.
• Worked on data warehouses with sizes from 30-50 Terabytes.
• Performance tuned and optimized various complex SQL queries.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirement.

Environment: Informatica Power Center 8.6.1, Teradata BTEQ scripting in Teradata 12, Siebel CRM, Siebel Marketing 8.0.