SUMMARY

• 5+ years of IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL Server databases, SSIS, Informatica PowerCenter 9.x/8.x/7.x, Informatica Data Quality.
• 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
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis, and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional data modeling.
• 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
• Strong 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/8.1/7.1

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, FACT, Dimensions), 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, Foster City, CA

Responsibilities:

• Prepared High-level Design and Low-Level Design based on Functional and Business requirements of the project.
• Designing & documenting the functional specs and preparing the technical design.
• Supported the development, optimization, and maintenance of Informatica mappings with various source data including Oracle and SQL.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Designed and developed extensive T-SQL, development UNIX Shell scripts for creating, dropping tables which are used for scheduling the jobs.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files.
• Developed banking management scripts in python to support the chase website in creating user profiles, transactions for the withdrawals and deposit.
• Worked with IDQ on data quality for data cleansing, robust data, remove the unwanted data, correctness of data.
• Extensive experience in T-SQL, integration of Informatica Data Quality (IDQ) with Informatica PowerCenter
• Involved in Migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata
• Developed, maintained programs for scheduling data loading and transformations using DataStage
• Developed mapping parameters and variables to support SQL override.
• Worked on import and export of data from sources to Staging and Target using Teradata MLOAD, Fast Export, TPUMP and BTEQ.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Worked with the third-party scheduler Autosys for scheduling Informatica PowerCenter Workflows Involved with Scheduling team in creating and scheduling jobs in Autosys Workload Scheduler.
• Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.6, Oracle 11g, SQL, IDQ, DB2, Teradata, DataStage, PL/SQL, PERL, Python, TOAD, Microsoft Visio, Autosys, Unix, T-SQLSQL Server 2008.

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, Teradata, T-SQL
• 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 T-SQL, SQL and PL/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, TOAD, SQL SERVER 2005/2008, XML, UNIX, Windows XP, OBIEE, Teradata.

Informatica Developer

Confidential

Responsibilities:

• Involved in all the phases of SDLC.
• Worked closely with business analysts and data analysts to understand and analyze the requirement to come up with robust design and solutions.
• Involved in standardization of Data like of changing a reference data set to a new standard.
• Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
• Involved in massive data profiling prior to data staging.
• Created profiles and score cards for the users.
• Created Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.
• Designed the mappings according to the OBIEE specifications like SDE (Source Dependent Extraction) and SIL (Source Independent Extraction).
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Created Informatica components required to operate Data Quality (Power Center required),T-SQL
• Designed best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, and Version Control.
• Developed the required Informatica mappings to process the data into Dimension and facts tables which satisfy the OBIEE reporting rules by interacting with reporting team.
• Developed scripts for creating tables, views, synonyms and materialized views in the data mart.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables. Created PL/SQL

Environment: Informatica Power Center 9.1/8.6, PL/SQL Developer, OBIEE, IDQ, Oracle 11g, UNIX, Microsoft SQL Server, TOAD, Teradata, Netezza.