SUMMARY

• Total 9+ years of IT Experience in Designing, Development, Administration, Implementation of D Confidential Warehouse & D Confidential marts with Informatica Products 10.x/9.x/8.x/7.x/6.x as an ETL tool, Informatica Metad Confidential Manager, SQL, PL/SQL.
• Expert in integration of various Operational D Confidential Sources (ODS) to Multiple Relational D Confidential base management Systems (RDBMS) like Oracle, SQL Server, Terad Confidential, DB2, Sybase etc
• Strong experience in D Confidential Warehousing and ETL using Informatica PowerCenter, Power Exchange 9.1/8.6, Oracle 11g/10g/9i, Terad Confidential 13/12/V2R6 and Erwin 7/4.5.
• 3 years of experience on real - time d Confidential Warehouse development using change d Confidential capture( Confidential ) tool like Informatica PowerExchange
• Experience in D Confidential Warehouse/D Confidential Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, ROLAP, MOLAP, Fact and Dimension tables, and Logical & Physical d Confidential 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 D Confidential 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 D Confidential Warehouse (EDW), D Confidential Marts and D Confidential warehouse with Star schema and snowflake schema.
• Expert in D Confidential Extraction, Transformation, Loading from d Confidential sources and targets like Terad Confidential, Oracle, SQL Server, XML, Flat files, DB2, COBOL and VSAM files etc.
• Expertise with B2B DT(D Confidential Transformation) and DX(D Confidential 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) d Confidential from various sources into D Confidential Warehouses and D Confidential Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metad Confidential Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2, HDFS and SQL Server D Confidential bases.
• 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, D Confidential Node, Resource Manager, Node Manager etc
• Experienced on Confidential Infosphere(D Confidential Stage, 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 d Confidential 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, metad Confidential 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 D Confidential Quality 10.x/9.x.

D Confidential bases: Oracle12g/ 11g/10g, Confidential UD2 DB2, MS SQL Server, MS Access 2000, Terad Confidential 14/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 SUMMARY:

Confidential, 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 d Confidential 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 d Confidential 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 d Confidential 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 d Confidential and developed one-time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the d Confidential base.

Environment: InformaticaPowerCenter, 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

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 d Confidential in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for d Confidential loading.
• Performed d Confidential 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 d Confidential from Oracle and SQL Server then used Terad Confidential for d Confidential 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 D Confidential Exchange, TOAD, Terad Confidential, 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 d Confidential from heterogeneous source systems into target d Confidential base.
• Created mappings using Designer and extracted d Confidential from various sources, transformed d Confidential according to the requirement.
• Involved in extracting the d Confidential from the Flat Files and Relational d Confidential bases 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 D Confidential of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and d Confidential flow management into multiple targets using Router.
• Created Sessions and extracted d Confidential from various sources, transformed d Confidential according to the requirement and loading into d Confidential 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 Terad Confidential as a source system.

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

Confidential

ETL Informatica developer

Responsibilities:

• Involved in design, development and maintenance of d Confidential base for D Confidential warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for d Confidential 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 d Confidential 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, Terad Confidential, Oracle 11g, Shell Scripts, UNIX, JSON files, IDQ tool, Auto-Sys, Oracle E-Business Suite (EBS)

Informatica Developer

Confidential

Responsibilities:

• Worked with team to understand the business requirements and designed, transformed & loaded d Confidential into d Confidential 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 d Confidential flow from source system to d Confidential warehouse.
• Analyzed business requirements, performed source system analysis, prepared technical design document (TSD) from source to target for d Confidential conversations, validation & loading.
• Validated d Confidential using Informatica D Confidential 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 d Confidential base schemas and designing star schema models to support the users reporting needs and requirements to develop D Confidential Mart from Oracle tables
• Developed initial & incremental d Confidential Conversations, validations and loading in Informatica using Update strategy transformation to load d Confidential into Oracle d Confidential bases
• Addressed performance issues on ETL jobs, views, stored procedures, Reporting & Ad-hoc SQL.
• Extracted d Confidential 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 d Confidential to d Confidential mart and EDW
• Developed Informatica workflows & sessions associated with mappings using Workflow Manager
• Created UNIX Shell Scripts for batch scheduling and loading process for d Confidential base used for ERP

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