SUMMARY:

• Informatica (10x) certified professional with 8 years of experience in information technology with special emphasis on Design, Development of Database, Data warehousing applications.
• Good experience in Information Technology as software engineer performing analysis, design and development of various applications in client - server environment. Good experience in providing Business Intelligence solutions in Data Warehousing for decision support systems and OLAP application developments.
• Expertise in Analysis, Design and Development of Data warehousing solutions and developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Power Center Informatica.
• Actively involved in design meeting with clients, provided various technical solutions in end-to-end implementation.
• Well versed with SDLC phases like planning, analysis, design, implementation and maintenance.
• Strong knowledge on Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Good exposure to loading and maintaining Data Warehouses in Teradata and Oracle. Experience with UNIX shell scripting and basics of PL/SQL programming. Good understanding of tools Mload, BTEQ, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse in Teradata.
• Experienced in Full life cycle of Data warehousing involving all stages of SDLC using Informatica Power Center (8x/9x).
• Highly experienced in ETL tool Informatica in using Mapping Designer, Workflow Manager and Monitor. Expertise and well versed with various transformations like Expression, filter, sorter and aggregator, Lookup, Normalizer, Joiner, Union and Update Strategy etc.
• User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis along with preparation of Ad-hoc reports.
• Coordinating with testing team for System Integration (SIT) and Regression testing.
• Used various Performance Tuning techniques to improve the overall performance.
• Excellent knowledge on using MS office tools and utilities.
• Excellent written and oral communication, interpersonal and presentation skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 8x/9x

RDBMS: Oracle 11g and Teradata

Operating System: Linux, Windows 98/NT/2000/XP

Scripting Languages: Unix Shell Scripting

Internet Technologies: XML, XSD, HTML, DHTML

Data Extraction Tools: Oracle SQL Developer, Teradata SQL Assist.

Scheduling Tools: Autosys and related scheduling tools.

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

Informatica ETL Developer

Responsibilities:

• Designing / implementing the control board dashboard to capture and report input errors at field level.
• Created Informatica Mappings to load data from flat files and oracle. Use of transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router, Normalizer, rank and Update Strategy transformations.
• Worked with Variables, Parameters, Parameter files and File list on Informatica.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Wrote Unix Shell Scripts to process the data received from source system on daily basis.
• Performed Unit and System Testing as per the test plan and documented the test results as per the corporate standards.
• Monitored the data loads during UAT, tracking and resolving the defects raised by the business users.
• Weekly status meeting with the client to communicate the development progress and any issues arising during Design, Development and Testing phases.
• Weekly status meeting with the users to communicate the development progress and any issues arising during Design, Development and Testing phases.
• Environment: Informatica Power Center 9.6, Oracle 12C, SQL, PL/SQL and UNIX shell scripting.

Confidential, Houston, TX

Informatica ETL Developer

Responsibilities:

• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplets Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Developed standard and re-usable mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Created Mapplets, reusable transformations and used them in different mappings.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Used the feature EXPLAIN PLAN to find out the bottlenecks in a given Query, thus improving the performance of the job.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scripts from development environment to production environment
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Environment: Informatica Power Center 9.1, Oracle 12C, SQL, PL/SQL and UNIX shell scripting.

Confidential

Informatica ETL Developer

Responsibilities:

• I was involved in the regular maintenance of the Data mart monitoring the data loads regularly and address any disruptions in their daily run
• Addressing Informatica load failures identifying the issue and executing auxiliary loads to load the missed data into the Data warehouse
• Handling change requests to change the mappings and strategy to include the changes in business rules
• Co-coordinating with the source teams to ensure timely transfer of source files and intimating then in case of any delays
• Optimizing/Tuning mappings for better performance and efficiency
• Attending the Weekly status calls with client explain the weekly status of the loads and any issues
• Handling change requests to change the mappings and strategy to include the changes in business rules
• Involved in Design Review and preparation of ETL/Reporting Design Documents
• Worked on Creation of mappings using Informatica 8 and Performance tuning of backend SQL generated for BO reports for faster Report Output
• Testing - unit testing, integration testing & performance testing.
• Environment: Informatica Power Center 8.6, Oracle 9i, UNIX, SQL, PL/SQL, Windows NT.

Confidential

Informatica ETL Developer

Responsibilities:

• Worked with enterprise architects to develop the new logical and physical ER data models in line with corporate standards and guidelines.
• Created the necessary documentations like High Level Design document (HDD), Detail Design Document (DD) with the ETL Mapping Matrix for the new data marts.
• Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy transformations.
• Worked on CDC functionality for the system - Preventive Health Prompting (PHP).
• Working experience with Power Exchange to create the capture registration for source tables, importing the Extraction map / Source definition to Power Center to use them in the mapping.
• Developed Fast Load and Mload scripts, developed BTEQ scripts to process the data in staging server using power exchange interface in power center.
• Worked with Variables, Parameters, Parameter files and File list on Informatica.
• Implemented slowly changing dimensions (Type I and Type II) for customer Dimension table loading.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• Involved in writing Automation Testing scripts using Shell and worked on Autosys to schedule these scripts in DEV and QA environments.
• Performed Unit and System Testing as per the test plan and documented the test results as per the corporate standards.
• Monitored the data loads during UAT, tracking and resolving the defects raised by the business users.
• Weekly status meeting with the client to communicate the development progress and any issues arising during Design, Development and Testing phases.
• Environment: Informatica Power Center 8.6, Oracle 9i, SQL, PL/SQL, UNIX and Windows NT.

Confidential

Informatica ETL Developer

Responsibilities:

• I was involved in the regular maintenance and monitoring the data loads regularly and address any disruptions in their daily run.
• Addressing Informatica load failures identifying the issue and executing auxiliary loads to load the missed data into the Data warehouse
• Handling change requests to change the mappings and strategy to include the changes in business rules
• Co-coordinating with the source teams to ensure timely transfer of source files and intimating then in case of any delays
• Optimizing/Tuning mappings for better performance and efficiency
• Attending the Weekly status calls with client explain the weekly status of the loads and any issues
• Handling change requests to change the mappings and strategy to include the changes in business rules
• Involved in Design Review and preparation of ETL/Reporting Design Documents
• Environment: Informatica Power Center, Oracle 9i, SQL, DB2, PL/SQL, Windows NT.