Ishwarya Jammula

ac66tb@r.postjobfree.com

720-***-****

A dedicated Informatica developer with six years managing development, implementation and testing of dataware housing and database business systems . Experience in writing UNIX shell scripts.

PROFESSIONAL SUMMARY

Experience in the Data Analysis, Design, Development, Implementation and Testing of

Data Warehousing using Data Extraction, Data Transformation, Data Validation and Data Loading (ETL).

Extensive Data Warehouse experience using Informatica Power Mart/ Power Center 7.x/8.x/9 (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer) as ETL tool on Oracle, SQL Server and DB2 Databases.

Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.

Comprehensive Knowledge of Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling.

Strong knowledge and experience in interacting with Oracle, SQL Server, DB2 databases with SQL/PL SQL programming.

Experience in integration of various data sources like Oracle, SQL Server, Flat Files, and XML into staging area.

Experience in writing UNIX shell scripts.

Hands on experience in all aspects of Software Development Life Cycle (SDLC).

Experienced in overall data warehouse, database, ETL and tuning for better performance.

Experience of preparing FSD/TSD (Functional/Technical Specification Document) documents from BRD (Business Requirement Document) / Customer Requirements.

Excellent communication and demonstrational skills for analyzing user requirements.

Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.

TECHNICAL SKILLS:

ETL TOOLS:

Informatica Power Center 9.x/ 8.x/7.x/6.x (Designer, workflow Manager,

Workflow Monitor, Repository Manager), SQL*Plus & SQL*Loader

Data Modelling:

Dimensional Data Modelling, Snow Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modelling

Reporting Tools

Oracle Business Intelligence(OBIEE)

RDBMS:

Netezza, Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, SQL Server 2000/ 2005, Teradata, MS Access.

Database Tools

Win SQL, Microsoft SQL Server, TOAD, SQL *PLUS, SQL Developer, SQL *Loader, Teradata SQL Assistant

Experience

Client: Farmers Insurance, Woodlandhills,CA June’17-Present

Informatica Developer

Responsibilities:

Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange to develop the marketing data mart.

Designed and developed Informatica Mappings based on the business requirements.

Validate the data in the target tables once it was loaded.

Fine-tuned existing mappings for performance optimization.

Worked on bug fixes on existing mappings to produce correct output

Running the workflows quarterly and scheduling the workflows and monitoring them.

Developed workflows and sessions associated with the mappings using Workflow Manager.

Involved in writing complex queries for generating different reports as per client needs.

Worked with Data modeler to restructure the data mart according to changes in the model worked on changes in the Informatica.

Extensively worked with Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.

Developed mappings in Informatica PowerCenter to load the data from various sources using transformations

Extracted data from fixed width flat files to load into the DB2 staging area and then to the data mart.

Created and configured the sessions for work flow. Created and maintained parameter files for workflows in UNIX.

Worked on Joiner, Aggregator, Update Strategy, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.

Implemented slowly changing dimensions - Type I, II & in different mappings as per the requirements.

Created connections for relational, Non-relational and applications in the workflow manager.

Created mappings using Reusable Transformations.

Migrating mappings, workflows and parameter files from development to production.

Developed PL/SQL scripts and conducted data masking on testing environment to protect sensitive data

Environment: Informatica Power Center 9.1, Oracle 11g, DB2, Flat files, UNIX, Shell scripting, SQL Developer, Teradata 13, Windows.

Client: Rail Inc, Raleigh,NC Oct’15-June’17

Software Engineer

Responsibilities:

Created the mappings according to the design documents.

Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.

Created workflows.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Implemented Error handling logic to capture the invalid data.

Designed and developed Oracle PL/SQL Procedures.

Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.

Performance tuning of Oracle PL/SQL Scripts.

Designed and developed UNIX shell scripts.

Environment: Informatica Power Center 8.3, flat files, DB2, Oracle 10g, SQL, PL/SQL, TOAD

Metanoia Solutions – India May’12-Aug’15 Database / Informatica Developer

Responsibilities:

Involved in gathering Business requirements and technical aspects for development.

Involved in deciding the architecture strategy, design of the physical and logical models of the data warehouse as well as two dependent data marts.

Scheduling, monitoring, coding and testing of custom PL*SQL modules to load data into the data warehouse from the legacy systems.

Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.

Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.

Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.

Partitioned sources to improve session performance.

Created users in Informatica, assigned them various permissions.

Backup/Restoration of repositories.

Daily Monitoring the Production Jobs and fixing the issue in case of failures.

Validating the code from lower environments and Deploying Jobs to Production

Incident Handling and solving the report related issues

Raising Problem tickets in case of code changes

Written SQL queries to validate the data

Environment: Informatica Power Center 6.1, Oracle7.0, SQL, PL/SQL, TOAD, Oracle, Designer, Business Objects.

Educational qualification

Bachelors in Electrical and Communications

Year of completion: 2013

University: Jawaharlal Nehru Technological University

Location: Hyderabad, India

Contact this candidate