PROFESSIONAL SUMMARY:

• 7 years of IT experience with Informatica for ETL, and BI tools and expertise in analysis, design, development and implementation of Data warehousing and Business Intelligence applications, along with Oracle, MS SQL server and Teradata databases on Windows and UNIX platforms.
• Informatica Power Exchange for loading/retrieving data from Oracle and MS SQL server system.
• Informatica Developer client 9.6 SQL Server 2008/2005/2000 , Oracle 9i/10g, Teradata V2R6/V2R5, Netezza, My SQL, and SQL, PL/SQL programming.
• Informatica Powercenter 9.6.1/9.5 SQL Server 2008/2005/2000 , Oracle 9i/10g, Teradata V2R6/V2R5 and SQL, PL/SQL programming.
• Oracle, SQL Server, MS Access, Teradata and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL - LOADER.
• Knowledge in UNIX and Python Scripting.
• Prepare BTEQ scripts for the purpose of data transform
• Proven ability to implement Data warehousing technology based solutions for business problems in
• Financial/Investment Banking/Credit Cards,
• Food and Beverage/Retail,
• Insurance/Pharmaceutical/Healthcare and
• Power/Electric.
• Data Modeling retaining concepts of RDBMS,
• Logical and Physical Data Modeling,
• Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions).
• Designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata. integration of various data sources like Oracle, SQL Server, Flat Files, into Data Warehouse and also experienced in Data Cleansing and Data Analysis.
• Business Objects 5.x/6.x to build user defined queries and reports to enable drill-down and slice and dice analysis on multiple databases.
• Writing, testing triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Write, test and implement Teradata TPT, Fastload, Multiload, Bteq scripts, DML and DDL scripts.
• Performance Tuning for targets, mappings and sessions, Task Automation using UNIX Shell Scripts, Job scheduling and Communicating with Server using pmcmd.
• Familiar with design and implementation of de-normalized multi-dimensional data marts using various schemas.
• Provided data matching, data cleansing, exception handling, reporting and monitoring features to data warehouse
• Experianced on working with Bigdata and hadoop File Sytem(HDFS)
• Hands on Experiance in working with Hadoop Eco system like Hive, Sqoop, flume strong knowledge on Hive and Hive analytical functions
• Capturing Data from existing databases that provide SQL interfaces using Sqoop
• Knowledge of Software Development Life Cycle including Planning, Analysis, Design, Implementation, and Maintenance.
• Project and Change request estimations.
• ETL production support role.
• E-R model & dimensional modeling concepts
• Excellent communication and interpersonal skills.
• Data Architecture and Design
• Requirement Analysis
• Feasibility Study and Impact Analysis
• Designing Solution Architecture
• Maintaining excellent Client Relationships and expert in effective communication
• Onsite Design Lead
• Resource Management and Leading the Development team
• Project Management
• Periodic Status Reporting in regular intervals
• Onsite-Offshore Coordination
• Implementation and UAT support

TECHNICAL SKILLS:

ETL: Informatica PowerExchange 9.5,Informatica Developer client 9.6,Informatica Powercenter 9.x/8.x/7.x/6.x (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager) Informatica Power Analyzer, Informatica Power Exchange 8.1.1/5.2.1/ Power Connect, SSIS (SQL Server Integration Services)

Reporting: Microstrategy, SSRS (SQL Server Reporting Services)

Data Modeling: Dimensional Data Modeling, Star Schema, Snow Flake, Fact and Dimension Table Modeling, Physical and Logical Data Modeling in Erwin 3.X

Databases: Oracle 10g/9i/8i/8.x, MS SQL Server 2008/2005/2000 /7.0, Teradata V2R6/V2R5, Vertica, DB2, Netezza, Hadoop Hive.

Other Utilities: Teradata utilities (Fast Load, Multi Load, BTEQ etc.), Toad, CVS, VSS, SQL*Loader, SQL Navigator, MS Visio, MS Office, Clear Case

Scheduling Tools: Control M, CA7

Operating Systems: UNIX (Sun Solaris), Windows 2003/2000/XP/98/NT Server, Mainframes.

PROFESSIONAL EXPERIENCE:

Confidential, Mountain View, CA

Lead Developer

Environment: Informatica Developer 9.6.1,Informatica power center 9.6.1, Netezza, Hadoop, SQL Server 2008/2005, MySQL, Linux, Python Scripts.

Responsibilities:

• Developed incremental mappings using Informatica Developer client and deploy the applications.
• Creating physical data objects for relational database, flat files.
• Creating the Hive table and loading the data into Hive tables using Informatica.
• Creating the workflow and deploy the workflow to data integration service to run the workflow.
• Create the application and deploy the application to data integration services.
• Developed the mapping by using MAV (mapping architecture Visio).
• Generate the DDL for both Hive and Netezza using java based on source structure.
• Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Developed test cases and test plans to complete the unit testing. Support System testing.
• Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
• Responsible for performance tuning in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.

Confidential

Team Lead Developer

Environment: Informatica 9.5, Vertica, Vsql, SQL Server 2005, Windows Server 2003

Responsibilities:

• Taking care of Daily Loads and fixing the production issues with in short time.
• Giving support on weekend loads and performing the validations after the Load complete.
• Understanding the complete business flow.
• Designing mappings in order to load data into the tables using transformations.
• Involved in Data Migration form one module to another.
• Reviewed mappings developed by Team members for functionality, Performance and Standards.
• Data quality checking and interacting with the business analysts
• Good experience in communicating with offshore team and client on weekly status report
• Performed testing as per UTCs

Confidential

Developer

Environment: Informatica 8.x, Oracle 10g, Unix

Responsibilities:

• Understanding the complete business flow.
• Designing mappings in order to load data into the tables using transformations.
• Reviewed mappings developed by Team members for functionality, Performance and Standards.
• Good experience in communicating with onsite team status report.
• Performed testing as per UTCs

Confidential, Dallas, TX

Developer

Environment: Informatica Power Center 9.1, Teradata, SQL Server 2008/2005, PL/SQL, Windows XP.

Responsibilities:

• Requirement gathering, analysis and designing technical specifications for the data migration according to the business requirement.
• Developed logical and physical dimensional data models using ERWIN.
• Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, XML and SQL transformations.
• Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Developed test cases and test plans to complete the unit testing. Support System testing.
• Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
• Responsible for performance tuning in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Extensively worked with PL/SQL, performance tuning of Oracle, SQL queries and T-SQL statements. Created Cursors, functions, stored procedures, packages, Triggers, views, materialized views using PL/SQL.
• Extensively worked with incremental loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger.
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows.
• Good experience with Informatica Administration 9.x.

Confidential, Dallas, TX

Developer

Environment: Informatica Power Center 9.1, Teradata, SQL Server 2008/2005, PL/SQL, Windows XP.

Responsibilities:

• Involved in Systems Study/ Analysis and understand the business needs and implement the same into a functional database design.
• Created Source definitions from Flat Files, Oracle 9i, Imported Target definitions and created Reusable Transformations in Informatica Powercenter Designer 9.1
• Used Informatica Power Connect to extract information from the Oracle ERP systems.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Used Shell Scripting to get data from source for the transformation to cleanse data as per business rule
• Experienced in developing informatica mappings using transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence Generator, Expression, Router, Update Strategy, Rank, XML SQ/Parser/Generator, Normalizer, etc., to load data from different sources like Oracle, Flat Files, Excel Spread Sheets, XML, COBOL files to the target Data Warehouse.
• Developed transformation Logic in informatica Powercenter Designer 9.1 to cleanse the source data of inconsistencies before loading the data into the staging area, which is the source for stage loading.
• Worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
• Used PMCMD commands for automating Batches and Sessions.
• Identified and fixed bottlenecks and tuned the Informatica mappings for better performance.
• Created Test cases for Unit test, used TOAD 9.7 to validate the data with SQL Query.
• Scheduling of Informatica workflows using Tidal Scheduler

Confidential, Phoenix, AZ

Developer

Environment: Informatica Power Center 8.6, SQL Server 2008/2005, PL/SQL, Windows XP, Flat Files.

Responsibilities:

• Responsible for documentation, version control of schema and version release.
• Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Interpreted logical and physical data model for business users to determine common data definitions and establish referential integrity of the system.
• Participated in the analysis of development environment of Extraction process and development architecture of ETL process.
• Coordinated with customer in finding the sources and targets for data conversion.
• Involved in the preparation of documentation for ETL standards, Procedures and Naming conventions as per ETL standards.
• Created Reusable transformations and Mapplets for use in Multiple Mappings by using informatica power center design .
• Created multiple universes and resolved loops by creating table aliases and contexts.
• Used session partitions, Dynamic cache memory and Index caches for improving performance of Informatica server.
• Good experience with Informatica Administration 8.x.
• Optimized and performed Tuning in mappings to achieve higher response times.
• Involved in the migration of existing ETL process to Informatica Powercenter.
• Created effective Test data and developed thorough Unit test cases to ensure successful execution of the data loading processes.
• Organized data in reports using Filters, sorting, ranking data with alerts.
• Created reports using Business Objects functionality like queries, slice and dice, drill down, functions and formulas.

Confidential, Phoenix, AZ

Developer

Environment: Informatica Power Center 8.6, SQL Server 2008/2005, Oracle10g, PL/SQL, Windows XP, Flat Files.

Responsibilities:

• Understanding the complete business flow.
• Designing graphs and mappings in order to load data into the tables using transformations.
• Involve in Data Migration form one module to another.
• Reviewed mappings developed by Team members for functionality, Performance and Standards.
• Managed the privileges of users and folders using Repository Manager and used Informatica Administration Console for Admin activities such as starting / stopping server, upgrading the repository etc.
• Data quality checking and interacting with the business analysts
• Good experience in communicating with offshore team
• Communication with the client for weekly status report
• Performed testing as per UTCs
• Testing and debugging of code

Confidential, Phoenix, AZ

Developer

Environment: Informatica Power Center 8.6, SQL Server 2008/2005, Oracle10g, PL/SQL, Unix, Facets

Responsibilities:

• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange
• Implemented a New Project by changing the current DW, written details design document & turn it over to the developers
• Helped the team in analyzing the data to be able to identify the data quality issues
• Work with Business Analyst and business users to clarify requirements and translate the requirement into technical specifications.
• As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Work closely with various levels of individuals to coordinate and prioritize multiple projects.
• Estimate, schedule and track ETL projects throughout SDLC
• Coordinating with user to gather the new requirements and working with existing issues.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router.

Confidential, Los Angeles, CA

Developer

Environment: Informatica Power Center8.6, SQL Server 2008/2005, Oracle10g, PL/SQL, Unix. Facets

Responsibilities:

• Created new mappings and updating old mappings according to changes in Business logic.
• Used ETL (Informatica) to load data from sources like Oracle database and Flat Files.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier
• Created various Mapplets in designer using Informatica Powercenter Mapplet Designer.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in creating desktop intelligence and web intelligence reports.

Confidential

Developer

Environment: Informatica Power Center8.6, SQL Server 2008/2005, Oracle9i, PL/SQL, Windows

Responsibilities:

• Extraction, transformation and loading data from source to target.
• Extracting data from different sources and load into staging area and Load data from staging area to Dimensions and Facts.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Developed various mapping and session using Informatica Power center for data loading.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.

Confidential

Developer

Environment: Informatica Power Center8.6, SQL Server 2008/2005, Oracle9i, PL/SQL, Windows

Responsibilities:

• ETL Developer, Design and development of various costs in to dimension tables and fact tables.
• Creation of new mappings to load history data and modification of existing regular mappings.
• Review & understanding existing mappings & workflows, Identifying Dataflowtesting them and dealing with performance issues
• Prepare complex SQL and prepare PL/SQL programs to fulfill the technical requirements