Summary

• 7 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter.
• Sun Certified Java Programmer.
• 5 years of experience in using Informatica PowerCenter 7.1.3/8.6.1/9.0.1 .
• 1 years of experience in Reporting tool COGNOS 8.4 .
• 1 year of experience in Talend Open studio and Talend Integration Suite .
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Developed OLAP applications using Cognos 8BI - Frame Work Manager, Cognos Connection, Report Studio, Query Studio, and Analysis Studio and extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units.
• Strong with relational database design concepts.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Excellent experience working on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tOracleOutput, tmap, tFileCopy, tFileCompare, tFileExist file components, ELT components etc.
• Strong business understanding of verticals like Banking, Brokerage, Insurance, Mutual funds and Pharmaceuticals.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills.

PROFESSIONAL EXPERIENCE:

Confidential

Role: ETL Consultant

Responsibilities:

• Involved to understand Business requirements with Business Analysts.
• Designed Function Specification Documentation as per previous generic Framework designs for all on boarding Contexts in RADAR Application Portal.
• Involved to understand Meta Data driven Framework design and Process Workflows.
• Involved in design and development of complex ETL mappings.
• Created context specific views on top of fact tables depending on Reporting Requirements.
• Validated files uploaded through Portal, loaded in to staging, dimension and fact tables.
• Coordinated with offshore team to develop the context specific applications.
• Involved to verify unit test case scenarios, performance issues, defect fixes in SIT and UAT environment
• Coordinated with support team to deploy the code in QA, UAT and Prod and fixes the issues during deployment phase.

Environment: Informatica9.5.1, Oracle 11g,Unix,Autosys,Cognos,Qlickview

Confidential

Role: Informatica Developer

Responsibilities:

• Design, Development and Documentation of the ETL Extract, Transformation Load strategy to populate the Data Warehouse from the various source systems.
• Worked on Informatica 9.0.1 client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Involved in design and development of complex ETL mappings.
• Implemented partitioning and bulk loads for loading large volume of data.
• Worked on dimensional modeling containing three phases i.e., conceptual, physical and logical modeling.
• Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Monitored jobs in work flow monitor to resolve critical issues.
• Experienced in release management and deployment of code..
• Performance tuning by session partitions, dynamic cache memory, and index cache.
• Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Extensively worked on various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Developed workflow tasks like Email, Event wait, Event Raise, Timer, Command and Decision.
• Created Stored Procedures in PL/SQL.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process.
• Created UNIX Shell scripts and called as pre session and post session commands.
• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Developed Documentation for all the routines Mappings, Sessions and Workflows .
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Used Informatica Power Center for extraction, transformation and loading ETL of source data on heterogeneous Database sources like Oracle, SQL Server flat files.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup Connected unconnected , Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, Event Wait, E-mail notifications, Decision and to Schedule jobs.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges using Informatica Repository Manager.
• Was responsible for the version control and up-gradation.
• Involved in the creation of partitions in Mapping to improve the performance of Informatica sessions.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.

• Wrote UNIX Shell Scripts and pmcmd command line utility for automating Batches and Sessions using ESP Workload manager.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Involved in trouble shooting and resuming failed jobs.

Environment: Informatica Power Center 9.0.1/Informatica Power Center 8.6.1, Putty, MS SQL server 2005/2008, Oracle 10g/9i, SQL, PL/SQL, Shell Scripts, Windows XP, Unix.

Confidential

Role: ETL Informatica Developer

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: Informatica 8.6.1, SQL Server 2008 R2, LINUX ,

Confidential

Role : ETL TalenD developer

Responsibilities:

• Worked with Data Mapping Team to understand the source to target mapping rules.
• Analyzed the requirements and framed the business logic for the ETL process using talend.
• Involved in the ETL design and its documentation.
• Developed Jobs in Talend Enterprise edition from stage to source ,intermediate, conversion and Target
• Worked on Talend ETL to load data from various sources to Oracle DB. Used tmap, treplicate, tfilterrow,tsort, tWaitforFile and various other features in Talend.
• Worked on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tOracleOutput, file components, ELT components etc
• Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs and daily batches for executing the Talend Jobs.
• Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.
• Implemented Error handling in Talend to validate the data Integrity and data completeness for the data from the Flat File
• Tuned sources, targets and jobs to improve the performance
• Used Talend components such as tmap, tFileExist, tFileCompare, tELTAggregate, tOracleInput, tOracleOutput etc.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.
• Involved in migrating objects from DEV to QA and testing them and then promoting to Production.
• Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs and daily batches for executing the Talend Jobs.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Talend Integration Suite.
• Involved in automation of FTP process in Talend and FTPing the Files in Unix .
• Created Talend Development Standards. This document describes the general guidelines for Talend developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Extracted data from Oracle as one of the source databases.
• Optimized the performance of the mappings by various tests on sources, targets and transformations

Environment: TalenD 5.1.1, Oracle11g,UNIX

Confidential

Role :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.

Environment:

Informatica 8.1.1 Power Center, Oracle 9i, Windows NT.

Confidential

Role :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 7.1.3, Oracle, UNIX

Confidential

Role :Cognos Developer

Responsibilities:

• Developed models in Framework Manager.
• Published packages and managed the distribution / setup of the environment.
• Used Query Studio for creating Ad-hoc Reports.
• Created complex and multi-page reports using Report Studio.
• Performed migration from Impromptu to Reportnet.
• Used Schedule Management in Cognos Connection.
• Performed Bursting Reports and Multilingual Reports using Report Studio.
• Developed Layout, Pages, Object Containers and Packages using Report Studio.
• Created reports using ReportNet with multiple Charts and Reports.
• Responsible for assigning user Sign-Ons for the new users.
• Provided guidance to report creators for enhancement opportunities.
• Created Multidimensional Cubes using PowerPlay and published on the UpFront Portal using PowerPlay Enterprise Server.
• Developed PowerPlay Cubes, used multiple queries, calculated measures, customized cube content and optimized cube creation time.
• Fine-tuned the Cubes and checked the database space issue and cube growth periodically.
• Responsible in the creation of new User Groups and User Classes using Access Manager.

Environment: CogonsBI Frame work manager, Cognos Connection, Report Studio, Query Studio , SQL server 2005.

TECHNICAL SKILLS

• Operating Systems: Windows, Linux, HP-UX
• Software / Applications: MS XP, MS 2000, MS Word, MS Excel, MS Access,
• Outlook, PowerPoint
• Database: SQL Server 2008/2005/2000, Oracle 10g/9i/8i
• ETL: Informatica PowerCenter 7.1.3/8.6.1/9.0.1,
• Informatica Power Exchange 8.6.1,
• Modeling: Talend 5.1.1, Framework Manager, PowerPlay Transformer
• OLAP/BI Tools: Cognos 8 Series
• Languages: Java, HTML, XML, SQL, PL/SQL.
• Web/Apps Servers: IBM Web Sphere 4x, Sun iPlanet Server 6.0. , IIS, Tomcat
• Tools: TOAD, Visio, Eclipse