SUMMARY

• Around 7 years of total IT experience focusing on Data warehousing and Informatica ETL process.
• 1 year of experience in Data Migration from Oracle to Teradata platform.
• SDLC: 6 years of IT experience in all aspects of analytics/data warehousing. I have been key in delivering innovative database /data warehousing solutions using Informatica tool to the Insurance, Finance and Telecom Industries.
• 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 sessions as well as performance tuning of mappings and sessions.
• Databases: 6 years of experience using Oracle 10g, SQL, TOAD.
• 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.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.

TECHNICAL SKILLS

Operating Systems: Windows 7/XP.

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

Databases: Oracle 10g, Teradata.

ETL Tool: Informatica Power Center 8.6.1.

Others: Microsoft Word, Microsoft Excel, Outlook

PROFESSIONAL EXPERIENCE

Confidential, NY

Informatica Developer

Responsibilities:

• Created technical specification for extraction, cleaning, transformation and loading data into various tables and defining coding standards.
• Worked on ETL processes such as creating mappings using various transformations including Aggregator, Lookup, Joiner, Stored Procedure, Source Qualifier, Expression, Filter, Router, Update Strategy and Union.
• Used SQL tools like TOAD to run SQL queries to validate the data.
• Developed Workflows to run multiple sessions that are sequential in nature.
• Used parameters and variables Confidential different mappings and sessions.
• Used Debugger to fix errors in the mappings and to check the data flow.
• Partitioned sessions for parallel loading of data into the target tables.
• Executed workflows using pmcmd command.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Identified opportunities for business process improvement and initiated efforts to make improvements.
• Agile teaminteraction.
• Assisted in designing test plans, test scenarios and test cases for unit and integration testing.

Environment: Informatica 8.6.1, Oracle 10g, 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.
• Developed PL/SQL stored procedures & triggers for implementing business rules and transformations.
• Involved in Unit Testing and Integration Testing.

Environment: Informatica 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 developedMapplets, shortcutsfor 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.
• UsedWorkflow Managerfor Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run Confidential specified time.
• Usedpre-sessionandpost-sessionscripts for dropping and recreating indexesbefore and after loading data into target table to optimize performance for bulk loading.
• Designed and implemented processes usingParameter file to overridemapping 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.
• 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 8.6.1, Oracle 10g

Confidential

Informatica Developer

Responsibilities:

• Involved in CompleteSoftware Development LifecycleExperience (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.
• 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 8.6.1, Teradata BTEQ scripting

Confidential

Informatica Mapping Developer

Responsibilities:

• Mapping Business requirements to technical architecture
• Involved in preparing the Detail Design Document.
• Worked on Dimension Mappings like Rule dim, Rule Parameter dim, Hour dim, Engg dim, Time Zone dim, Media dim.
• Worked on Transaction and the fact mappings like PPM Monitor Fact, APL Clock Drift Fact, Mention Day Fact and Mention HR Fact.Creating mappings, reusable transformations in Mapping Designer.
• Involved in Unit Testing

Environment: Informatica 8.6.1, Oracle 10g.