SUMMARY

• 2+ years of IT experience in design, analysis, documentation and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL Server databases, Informatica PowerCenter 9.x/8.x/7.x.
• Involved in complete software development life cycle (SDLC) of project with experience in domains like Healthcare, Banking, Insurance and Appliances.
• Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor
• Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc.
• Teradata and Source files like flat files, XML files and COBOL files
• Experienced in mapping techniques for Type 1, Type 2, and Type 3 Slowly Changing Dimensions
• Hands - on experience in Informatica upgrade from 8.6 to 9.1
• Solid experience in implementing business requirements, error handling, job control & job auditing using Informatica Power Center tools experience in SQL, PL/SQL, Tables, Database Links, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Joins, Unions, Cursors, Collections, and Indexes in Oracle
• Proficient in Oracle Tools and Utilities such as TOAD and SQL*Developer.
• Expert in analyzing Business & Functional Specifications, creating Technical Design Document and Unit Test cases
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Involved in SDLC- software development life cycle (Water, Scrum/Agile) of building a Data Warehouse on windows.
• Well versed with onsite/offshore project delivery model and experience in working with offshore teams

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6

Reporting Tools: Business Objects

Scheduling tools: Informatica Scheduler, CA Scheduler (Autosys), ESP, Maestro, Control-M.

Data Modeling: Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake) Physical, Logical Data Modeling, and ER Diagrams.

DB Tools: SQL Server Management Studio (2008), Oracle SQL Developer, Toad, (Oracle)

Languages: Shell Scripting, XSLT, PL/SQL, T-SQL

Operating Systems: Windows

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, los Angeles, CA

Responsibilities:

• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets, UNIX Shell scripts using Informatica Power center 9.x, relational database management system.
• Work in a fast-paced environment, under minimal supervision providing technical guidance to the team members
• Responsible for automating the InformaticaAdministrativetasks like Purge older versionobjects, Purge older versionSession/Workflow logs.
• Responsible for database schema design, extensive T-SQL development, integration testing and other projects that may be necessary to help the team achieve their goals
• Administrate theData bridgeETL client to clone the mainframe DMSII data to SQL Server database.
• Designed and developed UNIX Shell scripts for creating, dropping tables.
• Working closely with Onshore and offshore application development leads
• ETL Mappings, Mapplets, Workflows, Worklets using Informatica Power center 9.x
• Identify efficiencies and ways to improve design and development processes
• Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time
• Involved in Migration projects to migrate data from data warehouses on DB2.
• Writing SQL Scripts to extract the data from Database and for Testing Purposes.
• Worked with scheduler Maestro for scheduling Informatica Power Center Workflows Involved with Scheduling team in creating and scheduling jobs in Workload Scheduler.
• Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.6.1, SQL, DB2, PL/SQL, TOAD, Microsoft Visio, Maestro, Unix, WinSCP, SQL Server 2008, AQT

Informatica ETL Developer

Confidential, Long Beach, CA

Responsibilities:

• Analyzed the functional specifications provided by the data architect and created Technical System Design Documents and Source to Target mapping documents.
• Involved in Designing High Level Technical Documentation based on specification provided by the Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL Server,T-SQL,Teradata
• Agile data loading for Amazon Redshift using Informatica drag-and-drop based cloud designer to create integrations with multiple source objects and targets.
• Loading data from large data files into Hive tables.
• Importing and exporting data into HDFS and Hive using Sqoop.
• Created all the Target Table DDLs and as well the Source table DDLs in Teradata.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Requirement gathering and Understanding of the Functional Business processes and Requirements given by the Business Analyst.
• Involved in Designing High Level Technical Documentation based on specification provided by the Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Performance tuned ETL processes at the mapping, session and Database level.
• Integrated sources from different databases and flat files.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Independently perform complex troubleshooting, root-cause analysis, solution development
• Involved in end to end system testing, performance and regression testing and data validations and Unit Testing.
• Extensively used SQL and PL/SQL,T-SQL Scripts
• Basic Informatica administration such as creating folders, users, privileges, server setting optimization, and deployment groups, etc.
• Designed Audit table for ETL and developed Error Handling Processes for Bureau Submission.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.

Environment: Java Informatica Power Center 10.1/9.6.1/9.1.0 , Informatica Developer Client, IDQ, MDM, Power Exchange, DB2, SAP, Oracle 11g, Hadoop HDFS, Hive, Sqoop, Syncsort, PL/SQL,T-SQL, TOAD, XML, UNIX,.