SUMMARY

• Total 9+ years of IT Experience in Designing, Development, Administration, Implementation of Data Warehouse & Data marts with Informatica Products 10.x/9.x/8.x/7.x/6.x as an ETL tool, Informatica Metadata Manager, SQL, PL/SQL.
• Expert in integration of various Operational Data Sources (ODS) to Multiple Relational Database management Systems (RDBMS) like Oracle, SQL Server, Teradata, DB2, Sybase etc
• Strong experience in Data Warehousing and ETL using Informatica PowerCenter 9.6/8.6.1/7.1 , Power Exchange 9.1/8.6, Oracle 11g/10g/9i, Teradata 13/12/V2R6 and Erwin 7/4.5.
• 3 years of experience on real - time data Warehouse development using change data capture(CDC) tool like Informatica PowerExchange 9.1/8.6/8.1.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, ROLAP, MOLAP, Fact and Dimension tables, and Logical & Physical data modeling using ERWIN 7.5/4.2 and MS Visio.
• Having Business Intelligence experience using OBIEE 11g/10g, Business Objects XI R2, MS Access
• Strong experience in the Analysis, design, development, testing & Implementation of Business Intelligence solutions using Data Warehouse/Mart Design, ETL, OLAP, BI Client/Server applications
• Expert in Informatica 9.x installation, configuration, debugging, tuning and administration including Systems implementation, operations and its optimization as Informatica admin
• Experienced in development, maintaining and implementation of Enterprise Data Warehouse (EDW), Data Marts and Data warehouse with Star schema and snowflake schema.
• Expert in Data Extraction, Transformation, Loading from data sources and targets like Teradata, Oracle, SQL Server, XML, Flat files, DB2, COBOL and VSAM files etc.
• Expertise with B2B DT(Data Transformation) and DX(Data Exchange) and parsing XSD, EDI files and API’s to generate Xmls, flat file for end users.
• Expert in Stored Procedures, Triggers, Packages for tools like TOAD, SSMS & PL/SQL Developer
• Expert in using Informatica Designer for developing mappings, mapplets/Transformations, workflows and performing complex mappings based on user specifications/requirements
• Expert in Operational and Dimensional Modeling, ETL (Extract, Transform and Load) processes, OLAP, OLTP, dashboard designs and various other technologies
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2, HDFS and SQL Server Databases.
• Highly experienced in working and managing projects in Onsite-Offshore models. Proficient in leading team and meeting client expectations/requirements
• Excellent understanding / knowledge of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, NameNode, Data Node, Resource Manager, Node Manager etc
• Experienced on IBM Infosphere(DataStage, Quality Stage) / Information Analyzer 8.1.
• Experienced on Apache Hadoop technologies like HDFS, MapReduce framework, Sqoop.
• Expert in using Informatica’s various tools like Power Center 9.1/9.6, Power Exchange, B2B data exchange including Source Analyzer, Target & Mapping Designer, Workflow Manager etc
• Designed and Prepared Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.
• Hands on experience in installing, configuring, and using Hadoop ecosystem components like HDFS, Pig, Hive, Sqoop, Flume, Oozie, MapReduce, Zookeeper, Kafka, Spark and HBase
• Well versed with all Phases of SDLC (Software Development Life Cycle) Process with respect to development, deployment, maintenance & enhancements especially agile and scrum prototypes
• Experienced in implementing Oracle BI Apps in all phases like implementing mappings, Designing ETL, metadata management using DAC, Creating Oracle DW, OBIEE reports & Dashboards
• Strong experience in Scheduling jobs using UNIX Shell Scripts and Unix Crontab
• Excellent analytical, problem solving & communication skills including leading & managing a team

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter10.x/9.x/8.x, Informatica PowerExchange10.x/ 9.x/8.x, Informatica DataQuality 10.x/9.x.

Databases: Oracle12g/ 11g/10g, IBM UD2 DB2, MS SQL Server, MS Access 2000, Teradata14/13/12, Netezza 9

Programming Languages: C, C++, SQL, PL/SQL, UNIX, XML, Unix Shell Scripts

DB Tools: TOAD, SQL Navigator, SQL* Loader, SQL Management Studio, SQL Assistance

Mythologies: SDLC, Agile

Software: WebSphere Studio Application Developer 5.x, Sun One StudioMacromedia DreamWeaver3.0, ColdFusion, SQL Navigator, Toad, Erwin

Operating Systems: Sun Solaris8.0/10.0, Windows XP/7, AIX, LINUX

OLAP/BI Tools: Cognos 8 Series

Others: Erwin 5.1/4.1.2, TOAD, OBIEE 10g,SQL Loader, MS Office, Smart FTP, Ultra Edit, Autosys,Control-M, HP Quality Center, MS Visio, Autosys, Erwin 9.3, Business Objects 6.0,Hadoop,Hive.

PROFESSIONAL EXPERIENCE

Confidential, Melville, New York

Informatica Lead

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one-time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: InformaticaPowerCenter 10.1.0/9.6.1 , PowerExchange 9.5.1, Hadoop2.6, HIVE, HDFS, TOAD, Power Exchange Navigator, Putty, UNIX Shell Script, Oracle 11g, Control-M, DB2, SQL*Plus, MS SQL Server 2008, OBIEEE.

Confidential, Atlanta, GA

ETL Informatica Lead

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Write Shell script running workflows in Unix environment.
• Optimizing performance tuning at source, target, mapping and session level

Environment: Informatica PowerCenter 9.6/9.1, Informatica PowerExchange 9.6/9.1, Oracle 11g, PL/SQL developer, HIVE, PIG, Autosys, MapReduce, SQL Server 2008/2014, B2B Data Exchange, TOAD, Teradata, SSMS, Putty, UNIX Shell Script, Cognos, IDQ tool.

Confidential, San Jose, CA

ETL Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Used Teradata as a source system.

Environment: Informatica PowerCenter 9.5, Informatica PowerExchange 9.5, IDQ 9.X, Oracle 11g, Data Analyzer 8.1, Erwin, Business Objects XI R2/R3/R4.1,TOAD, Teradata, PL/SQL, Control-M, WinSCP, JSON files.

Confidential, Bridgewater, NJ

ETL Informatica developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 7.X.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Coded PL/SQL scripts.
• Wrote Unix scripts, perl scripts for the business needs.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Created Universes and generated reports on using Star Schema.

Environment: Informatica PowerCenter 9.5/9.1, Informatica PowerExchange 9.5/9.1, TOAD, Teradata, Oracle 11g, Shell Scripts, UNIX, JSON files, IDQ tool, Auto-Sys, Oracle E-Business Suite (EBS)

Confidential, Reston,VA

ETL/Informatica Developer

Responsibilities:

• Worked with team to understand the business requirements and designed, transformed & loaded data into data warehouse (DW) using ETL tool Informatica Power Center and Exchange
• Created new mappings & updated old according to changes in Business logic using Informatica
• 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.
• Analyzed business requirements, performed source system analysis, prepared technical design document (TSD) from source to target for data conversations, validation & loading.
• Validated data using Informatica Data Explorer (IDE) & performed Proof of Concept for Informatica Design Quality (IDQ)
• Developed complex mappings using Transformations like Lookup Joiner, Sorter, Rank, Source Qualifier, Router, Union, Aggregator, Filter, and Expression in the Power Center Designer.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements to develop Data Mart from Oracle tables
• Developed initial & incremental data Conversations, validations and loading in Informatica using Update strategy transformation to load data into Oracle databases
• Addressed performance issues on ETL jobs, views, stored procedures, Reporting & Ad-hoc SQL.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2 and Flat Files.
• Formulated the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing (UAT).
• Involved in SQL Query tuning & provided tuning recommendations to ERP using Oracle EBS tools
• Extensively worked with various re-usable components like tasks, workflows, Worklets, Mapplets and transformations to load data to data mart and EDW
• Developed Informatica workflows & sessions associated with mappings using Workflow Manager
• Created UNIX Shell Scripts for batch scheduling and loading process for database used for ERP

Environment: Informatica PowerCenter 8.6.1, PowerExchange, Oracle 10g, DB2, PL/SQL, Teradata, TOAD, SQL*Loader, Oracle E-Business Suite (EBS), SQL Server 2005 and Windows Server 2003.

Confidential, Marlborough, MA

Informatica Developer/ Data Analyst

Responsibilities:

• Participated in Data Modeling meetings and worked on Dimension modeling.
• Created LDM and PDM through ERWIN and documented description of each components like Tables, columns, Indexes, Constraints and Dependencies.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.
• Integrated various sources into the Staging area to Integrate and Cleansing data.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Worked extensively on designing Data Mapping flow from various source systems to target systems
• Involved in identifying Informatica bottleneck and Tuning various components of designer and workflow manager.
• Created Stored Procedures, Triggers, Functions, Views and Packages using PL/SQL.
• Developed different reports using Oracle Application Express and PL/SQL.
• Created scripts using SQL and PL/SQL to generate bulk data for testing team to test the performance of the application and the same data was used by DBA team to test the server performance.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Autosys, Toad, SQL, PL/SQL,Windows 2000, UNIX shell Scripts, LINUX, Mainframe.