PROFESSIONAL SUMMARY:

• 3+ years of Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 9.6.1
• Good experience of ETL design principles and good practical knowledge of performing ETL design processes through Informatica.
• Extensively worked on Power Center Mapping Designer, Mapplet Designer, Transformation developer, Work flow Manager, Repository Manager and Workflow Monitor.
• Good understanding in Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema).
• Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica, Data Quality (IDQ).
• Strong analytical and conceptual skills in database design and implementation of RDBMS concepts.
• Solid understanding of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Good experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schemas.
• Extensive experience on tools like SQL Developer, Application designer and Toad.
• Experienced in Oracle database development using PL/SQL, Stored Procedures, Triggers, Functions and Packages.
• Proficient in writing complex queries and stored procedures in SQL Server 2008
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced as a Web Development/User Interface/Front End Developer in developing applications using HTML/HTML5, CSS/CSS3, JavaScript, DOM, jQuery, Ajax and JSON. Experience in designing UI patterns and UI applications with the help of Adobe products like Adobe Dreamweaver CS3, Adobe Photoshop, and Adobe Illustrator CS3.
• Programming Languages: C++, Java, SQL, PL-SQL, UNIX shell and scripting languages.
• Knowledge on implementing AWS CLI and AWS API Gateway.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1,IDQ

Operating Environment: Unix(solaris) 9.0, AIX 5.2, MS Windows 95/98/NT/2000/XP

RDBMS Tools: TOAD 7.x/8.5, SQL Navigator

Databases: Oracle 10g/9i/8i, DB2, SQL server 2000

Languages: SQL, PL/SQL

Scripting: Unix Shell and Python

WORK EXPERIENCE:

Confidential, Miami, FL

Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Involved Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.6.1.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Environment: Informatica 9.6.1, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader, Tidal Enterprise Scheduler 5.3.1, Accurev, Unix, Flat files.Microsoft Office, MS Access, Crystal reports.

Confidential, Confidential, MO

Informatica Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process

Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.

Confidential

Database Developer

Responsibilities:

• Maintaining the data coming from the OLTP systems.
• Tuned the database queries to improve the performance of the query and indexing strategies.
• Coded database triggers to record the changes made to the database objects.
• Coded functions and stored procedures to perform the user defined functions and execute the required query whenever needed.
• Document the work performed each day.
• Helped coding shell scripts for database scripting.
• Establishing an application's security measures during development of Application in collaboration with DBAs.
• Involved in Physical schema implementation, objects like table-space, table rollback segments.
• Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security.
• Maintained system security, control and monitor user access to database
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.

Environment: MS SQL Server 2005, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, Erwin, ProClarity, QueryAnalyzer, MS Office 2003.