SUMMARY:

• 8 Years of experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica Power Center v10.x/v9.x/v8.x Experienced in analysis of different systems for system study and data warehouse implementations.
• Extensively worked on Informatic PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Transaction Control transformations.
• Experienced in Dimensional modeling concepts star/snowflakes Schema, Fact and Dimension table and proficient in identification of Facts, Measures and Dimensions.
• Experience developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experienced in OLTP/OLAP Systems, Analysis, and Data model Schemas like Star schema, Snowflake schema and multidimensional modeling.
• Experienced in Data Analysis, Data modeling, ETL, Data Warehousing, Reporting, Development, Maintenance, Testing and Documentation.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Developed effective working relationships with client team to understand support requirements.
• Experienced in loading data, troubleshooting, Debugging, mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server, Teradata and formats like flat-files, XML, etc.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Independently perform complex troubleshooting, root-cause analysis and solution development.

TECHNICAL SKILLS:

ETL Tools: Informatica Powercenter 10.0.1/9.6.1/9.5.1/8.6.1/7.1.1, IDQ Modeling Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, E-R Modeling, Microsoft Visio.

RDBMS: Oracle 10g/9i, DB2, SQL Server 2000/2005/2008, DB2, MySql, Sybase

Languages: XML, UNIX Shell Scripting, SQL, PL/SQL

Operating System: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential - Phoenix, AZ

Informatica Developer

Responsibilities:

• Analyzed business documents and created system requirement specification.
• Extensively used Informatica PowerCenter 10.2 for ETL (Extraction, Transformation and Loading), data from relational tables and flat files.
• Extensively worked on complex mappings, Mapplets and workflow to meet the business needs and ensured they are reusable transformation to avoid duplications.
• Performed data validation testing writing SQL queries
• Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.
• Involved in writing SQL scripts, stored procedures and functions and debugging.
• Performed Functional Testing & Regression Testing
• Provide comments for user stories within an AGILE software development SCRUM environment.
• Created sessions and batches and tuned performance of Informatica sessions for large data files by increasing the block size, data cache size and target-based commit interval.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Used debugger to test mapping at designer level.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Setting up User Security Model in multi-tenant ETL/BDM platform
• Created configured and scheduled the sessions and Batches for different mappings using workflow manager and using UNIX scripts.
• Handling Issues during development and analyzing phase and Fixing Bugs.
• Coordinated with onshore and offshore teams to identify and resolve various issues relating to processes, Informatica, other databases etc.

Environment: Informatica PowerCenter 10.2, Developer (IDQ), BDM, PL/SQL, Teradata 14.10, TPT, BTEQ, Fast Load, Multiload, Flat files, Oracle 12c, SQL Server, UNIX.

Confidential - TAMPA, FL

Informatica Developer

Responsibilities:

• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Extensively used Powercenter to design multiple mappings with embedded business logic.
• Involved in discussion of user and business requirements with business team.
• Performed data migration in different sites on regular basis.
• Involved in upgrade of informatica from 9.1.1 to 9.6.1 as well to 10.0.1
• Used Informatica to develop objects for extracting, cleaning, transforming and loading data into data warehouse.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in efficient manner.
• Experience in Informatica Powercenter for Data integration between source & Target which includes development of Joiner, Aggregator, Lookup, Salesforce Lookup, Router and Sorter transformations.
• Involved in data design and modelling by specifying the physical infrastructure, system study, design, and development.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Parameter files.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Database-to-Database transfer of data using BTEQs within Teradata system.
• Writing Teradata SQL queries to join or any modifications in the table.
• Worked extensively on understanding modelling for OLAP and OLTP applications.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
• Coordinated with onshore and offshore teams to identify and resolve various issues relating to processes, Informatica, other databases etc.

Environment: Informatica Power Center 10.0.1/9.6.1/ 9.5.1/9.1.1, IDQ 9.5.1, Oracle 11g/10g, SAP BO, Flat files (fixed width/delimited), Erwin, Putty, WinScp, Linux, SharePoint, Quality Center, Maestro, Unix.

Confidential - Birmingham, AL

Informatica Developer

Responsibilities:

• Utilized all the features of Source Qualifier transformation such as filter, joiner, sorter and SQL override to the extend level at the source level.
• Worked with Business data Analysts (BDA) to understand the requirements for DW development.
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Lookup, Filter and Union in developing the mappings to migrate the data from source to target.
• Extensively used Lookup transformation and Lookup Caches in looking the data from relational and Flat Files.
• Extracted data from various heterogeneous sources like Oracle, Sybase, SFDC, Flat Files and COBOL (VSAM) using Informatica Power center and loaded data in target database DB2.
• Extensively worked with session logs and workflow logs in doing Error Handling and trouble shooting.
• Involved in doing Unit Testing, Integration Testing and Data Validation.
• Worked with the Control M scheduling team in scheduling Informatica Jobs as per the requirement and frequency.
• Involved in data analysis and purging of both OLTP and OLAP systems.
• Experience in integrating SFDC (sales force) data using Informatica.
• Implemented various Performance Tuning techniques by finding the bottle necks at source, target, mapping and session and optimizing them.
• Involved in DWH up gradation for source system changes.
• Created Mapping parameters and Variables and written parameter files.
• Created UNIX shell scripts for various needs.
• Worked with the Debugger Wizard in debugging the mappings.
• Used Normalize Transformation for Cobol (VSAM) sources.
• Worked with External stored procedures for data cleansing purpose.
• Worked with the Cognos team in generating various reports.
• Involved in preparing the Migration Documents.
• Implemented Informatica Procedures and Standards while developing and testing the Informatica objects.

Environment: Informatica Power Center 9.5.1/9.1.1, Oracle 10g/9i, DB2, SFDC, PL/SQL, TOAD, SQL* Plus, SQL*Loader, Auto Sys, Unix, Windows.

Confidential

Database Developer

Responsibilities:

• Involved in Requirement gathering and writing Functional and Technical documents.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Tune the SQL queries and complex procedures to improve performance.
• Created database triggers for data security & Consistency.
• Extensively used .NET Data Grid control for displaying the data.
• Developed procedures, functions and packages for new requirements.
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using shell scripts.
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Developed and created various scenarios for testing the code.
• Debugged existing code for business logic issues.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.

Environment: Oracle11g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Java, SQL Navigator, Sub Version, Mercury Quality Control, UNIX, JIRA