SWETHA

EXPERIENCE SUMMARY:

• Around 7 years of Experience as ETL Developer in designing and implementing Data Mart / Data Warehouse applications using INFORMATICA PowerCenter 9.x/8.x / 7.x / 6.x (Designer, Workflow manager, Workflow monitor).
• Strong working experience in Investment domain and worked on Bloomberg and Murex data.
• Informatica Data Extensive experience in Extraction, Transformation and Loading (ETL) of data from multiple sources.
• Designed and developed Complex mappings from various Transformations like Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, and Web Services.
• Expertise in implementing complex business rules by creating re - usable transformations, and Mappings/Mapplets and Creating Repository, Source, Target Databases.
• Well experienced in Performance Tuning of Informatica (sources, mappings, sessions and targets) and Databases, Multi-Threading and parallel processing.
• Expertise in PL/SQL development and SQL Query Tuning for better performance.
• Experience in Dimensional Data Modeling using Star, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling using Erwin.
• Proficiency in Data Warehousing techniques for Data Cleansing, Slowing Changing Dimension (type 1, 2 & 3) phenomenon and Surrogate Key assignment.
• Extensive working experience in RDBMS like Oracle 11g/10g/9i/8i, MS-SQL Server, Teradata, DB2, SQL, PL/SQL, SQL*Loader. Extensively used Oracle SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Good work experience in Unit testing, Functional, Performance, User Acceptance Testing.
• Experience in OLAP Tools Business Objects, Cognos, Microstrategy used for developing Reports.
• Experience in UNIX Shell scripting and Job Scheduling on Multiple platforms using Autosys.
• Strong knowledge of complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Experience in preparing project documents, installation documents.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Work lets), PowerExchange, Autosys.

OLAP Tools: OBIEE10.1.3.x, Business Objects, Cognos, WebFocus.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin.

Scheduling Tools: Autosys, Informatica PowerCenter Scheduler, and Control-M Scheduler.

Programming: PL/SQL, SQL, C, C++, HTML, UNIX shell scripts, XML, SQL*LOADER.

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS Access, Teradata.

Operating Systems: Windows 95/98/Xp, Windows NT/2000 Server, MS DOS and UNIX, LINUX.

Other Tools: SQL*plus, TOAD, Ms Office.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Analysis, Design, Development, Testing of ETL applications
• Involved in the various stages of Data warehousing life cycle development, database logical and physical design, ETL processes and Performance Tuning.
• Extensively worked on the Informatica Power Center 9.0 tools - Designer, Workflow Manager, Workflow monitor.
• Worked in upgradation of Webfocus project to test the reports as a part of internal project in the company.
• Involved in Informatica Administration such as creating and configuring Repository, folders, users and groups using Informatica Power Center Repository Manager.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager. Scheduled jobs in TWC/ Maestro Scheduler.
• Worked on Web Focus reports analysis.
• Worked with development teams on the Web Focus reports in the production support team.
• Work with testing teams and resolve issues in Quality Center.
• Developed and tested Informatica mapping to extract data from different source systems (like Oracle, SQL Server,Fixed Width and Delimited Flat Files) and load into Teradata data warehouse.
• Implemented SCD methodology including Type 1, Type 2 changes to keep track of historical data.
• Extensively worked on transformations like Lookup (Connected and Unconnected), Aggregator, Expression, Router, Filter, Update Strategy and Sequence Generator, Sorter, Joiner, Expression, Union.
• Used Repository Manager for moving the mappings and sessions from one environment to another, such as from a development environment to Test and UAT environments.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used the Workflow manager to create workflows, work lets and tasks.
• Analyzed session Log files in case the session failed to resolve errors in mapping or session configurations. Created stored procedures, packages, triggers, tables, views and synonyms in Oracle.
• Made Scheduling changes as per Client's Requirement such as defining a new job, modifying an existing job, calendar updates, adding predecessors and successors to the existing job in TWC/Maestro scheduler.
• Involved in Trouble shooting problems by checking session log files also used debugger for complex troubleshooting.
• Used debugger to test the mapping and fixed the bugs.
• Documented Informatica mappings, design and validation rules.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and USER testing.
• Maintained extensive documentation for design, implementation and testing informatica mappings.

Environment: Informatica Power Center 9.1, Web Focus, Murex, Oracle 11g,Teradata 13/12, SQL Server 2005, Toad, SQL Plus, PL/SQL, UNIX(Korn) Shell Scripting, TWC/Maestro scheduler, Windows XP, MS Visio.

Confidential, New York, NY

Sr. Informatica Developer

Responsibilities:

• Involved in designing the Data mart and entire data warehousing life cycle designing.
• Interacted with Business users and Business analyst to gather requirements and business logic.
• Used Informatica PowerCenter for extraction, loading and transformation (ETL) of data in the data warehouse.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Designed mappings to extract the data from the flat file sources and Relational sources.
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor and Repository Server Administration Console.
• Developed and documented Data Mappings/Transformations and Informatica sessions.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts.
• Sound knowledge of Dimensional Modeling using Star schema and Snow Flake schema
• Worked on Logical and Physical Database Designing using ERWIN Tool.
• Used Informatica PowerCenter Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Used update strategy to effectively migrate data from source to target.
• Populated error tables as part of the ETL process for the records that failed the migration.
• Developed SQL Scripts for reporting requirements and to meet the Unit Test Requirements.
• Developed stored procedures using PL/SQL to implement the business logic.
• Involved in Performance tuning activity in different levels
• Identifying Performance bottlenecks and fine-tuning ETL mappings and workflows to improve performance.
• Developing UNIX shell scripts and scheduling Unix Scripts by using scheduling tools.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigation links and drilldowns.
• Developing design documents and test cases result sets for informatica mapping and workflow for Production support
• Actively participated in weekly Project status meetings and communicated effectively with Project Managers
• Performed Knowledge Transfer to other Developers, DBA and Business Analyst after successful completion of the project

Environment: Informatica PowerCenter 9.5, Oracle 11, OBIEE, SQL server 2008,DB2, SQL, PL/SQL, MS Access, UNIX,TOAD, XML files, Windows XP.

Confidential, New York, NY

Informatica Developer (Dev and Prod Support Teams)

Responsibilities:

• Involved in Business analysis and requirements gathering
• Involved in Analysis phase of the business requirement and design of the Informatica mappings using low level documents.
• Analyzed Bloomberg marked data and loaded into Confidential data warehouse
• Extracted data feeds from Murex and loaded into the Warehouse.
• Extensively worked on Murex data model and created General Ledger feeds.
• Creating the design and technical specifications for the ETL process of the project.
• Extensively used Informatica PowerCenter for extraction, transformation and loading process.
• Extracted data from various sources like Oracle, flat files and SQL Server
• Used various Transformations of Informatica, such as Source Qualifier, Expression, Look-up, Update Strategy, Filter & Router, Joiner transformation etc for developing Informatica mappings.
• Worked on all the SCD like Type 1, 2, 3.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Creating sessions and work-flows for the Informatica mappings.
• Involved in Installation and configuration of PowerCenter 8.6.1 client tools and ODBC connections.
• Creating mappings with different look-ups like connected look-up, unconnected look-up, Dynamic look-up with different caches such as persistent cache etc.
• Writing Oracle stored procedures and functions for calling during the execution of Informatica mapping for dropping and recreating indexes on target tables.
• Extensively worked on the Performance Tuning of mappings and sessions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Extensively involved in testing by writing some QA procedures, for testing the target data against source data.
• Worked on Teradata SQL assistant and analyzed the data by writing SQL queries.
• Involved in design phase of Business Objects Universe, Classes and Objects. Generating and Validating Reports.

Environment: Informatica PowerCenter (PowerCenter Designer, workflow manager, workflow monitor), Oracle, Murex, Windows XP professional, PL/SQL Developer, Teradata, Teradata SQL Assistant, Business Objects.

Confidential

Informatica Developer

Responsibilities:

• Involved in requirements gathering in support of data warehousing to develop ETL.
• Extensively used Star Schema approach for designing of database for the data warehouse used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, and re-usable transformations.
• Created different source definitions to extract data from flat files and relational tables for Informatica PowerCenter/SQL Server.
• Developed a standard ETL framework to enable the reusability of similar logic across the board.
• Created different target definitions using warehouse designer of Informatica PowerCenter.
• Used mapping designer to generate different mappings for different loads.
• Created different transformations such as Joiner Transformations, Look-up Transformations, Rank Transformations, Expressions, Aggregators and Sequence Generator.
• Created stored procedures, packages, triggers, tables, views & synonyms in Oracle.
• Created reusable transformations and mapplets to use in multiple mappings. Used debugger to test the data flow and fix the mappings.
• Extracted source data from Oracle, Flat files, XML files using Informatica, and loaded into target Database.
• Extensively transformed the existing PL/SQL scripts into stored procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
• Validate the data in warehouse and data marts after loading process balancing with source data.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Used PMCMD command in UNIX to schedule jobs and sessions using Autosys scheduler.
• Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.
• Supported WebFocus reporting capabilities.
• Trouble shoot problems by checking the session log files. Also used debugger for complex troubleshooting. Helped Production Support team.
• Worked on Web Focus reports analysis.
• Worked with development teams on the Web Focus reports in the production support team.

Environment: Informatica PowerCenter, WebFocus, Oracle, MS SQL SERVER, Sybase, PL/SQL, SQL*Loader, Business Objects, Toad, MS Access, Windows XP, UNIX Sun Solaris.

Confidential

ETL Developer

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs.
• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Extracted the data from Oracle, Flat files and load into data warehouse.
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expression, sequence Generator and aggregator transformations to pipeline data to Data Warehouse.
• Created Tasks, Workflows, Sessions to move the data at using workflow manager and workflow monitor.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Involved in Designing of the database and the tables and the relationship between the tables.
• Wrote stored procedure to clean the existing data and created tables, views and indexes.
• Involved in coding of database Triggers, Stored Procedures and Maintaining Integrity Constraints.
• Involved in creating new stored procedures and modifying the existing ones.
• Worked on improving the SQL Query performances.

Environment: Informatica PowerCenter, Windows NT, Oracle 8i, SQL, PL/SQL, SQL*Plus.