SUMMARY

• 7 years of IT experience in the Database, Data warehousing and Business Intelligence.
• 6+ years of strong experience in Informatica PowerCenter 9.x/8.x/7.x, UNIX, Oracle and Netezza DB.
• Experience in complete life cycle implementation of an Enterprise Data warehouse and DataMart such as Analysis, Design, Development, Testing, Technical Documentation and Object Oriented Design & Analysis.
• Experience in Insurance, Healthcare, Telecom and Financial domains.
• Proficient knowledge in PowerCenter tools like Designer, Workflow Manager and Work Flow Monitor
• Expertise in integration of various data sources like SQL Server, Oracle, XML, Flat files, DB2 and Netezza using ETL Tools.
• Extensive experience with ETL tool Informatica in designing the Transformations, Mappings, Mapplets, Workflows, Worklet, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.5.1/8.6.1/7.1.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Sequence Generator Transformations.
• Profound knowledge in implementing different types of Caches for Lookup’s - Dynamic, Persistent and Static.
• Expertise in creating mapping Parameters, Variables and Reusable Tasks (Sessions, Command, Email).
• Tuned the performance in mapping and session levels using DTM buffer/block size configurations, Partitioning, Pushdown Optimization and implemented best practice at Source, Transformation and Target levels.
• Implemented Pre-Session and Post-Session shell scripting to run workflows using pmcmd command.
• Good understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data Modeling using Erwin 4.5/4.
• Strong experience as supporting the BI applications and handled various kinds of production issues
• Good Knowledge on Power Exchange plugins for Netezza and OBIEE Reporting Tool.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Used MFT (Managed File Transfer) for the transmission of the extracted files to the vendor.
• Set up SFTP connections to various external vendors for receiving and sending of encrypted files as part of MFT Integration team support.
• Involved in Unit testing and system integration testing (SIT) of Informatica and MFT projects.
• Well Experienced in Error Handling and Troubleshooting using Informatica Debugger and Session Log File when loading into targets.
• Designed and developed Validation Scripts for Data Quality and Maintenance.
• Expertise in defining Workflows and Tasks, Monitoring Sessions, load scheduling and automation of Informatica workflow batches using Informatica scheduler, Autosys and shell scripting.
• Hands on experience developing Indices, Procedures, Analytical functions and Databases Partitioning.
• Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.
• Excellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels.
• Experience working in complex, cross functional and geographically dispersed team environments.

TECHNICAL SKILLS

ETL Tool: Informatica PowerCenter 7.x/8.x & 9.5.1, Informatica B2B Data Exchange

Reporting Tool: Cognos10, SQL Server Reporting Services

Data Modeling: Erwin, Star Schema, Snowflake Schema, Fact & Dimension Modeling

Databases: Oracle 11g/10g/9i, Netezza, DB2, Sybase, MS Access, SQL Server 2008

DB & Other Tools: TOAD 9x/8.6/7.6, SQL * Plus, SQL*Loader SQL Developer, OBIEE 11.1.2

Programming: C#.Net, SQL, PL/SQL, UNIX Shell Scripting, Java

Office Applications: MS-Office 97/2007/2010/2013

Web Technologies: HTML, XML, XSL, XSLT, CSS

Operating System: Unix, Linux, Windows Server 2012/2008/2003 , Windows 8/ 7/Vista/XP/2003/98.

PROFESSIONAL EXPERIENCE

Confidential, Torrance, CA

Informatica Developer/ Support

Responsibilities:

• L2 support for Business Users and Analysts including researching questions and maintaining data base.
• Monitor production Environments and run defined Data Quality Checks
• Handling various issues categorized as Data/Environmental/Connectivity/Performance.
• Coordinating with multiple development teams, outside vendors and other support areas for making improvements in the nightly schedules or correcting bugs support transition meetings .
• Responsible for enhancements of the project, tuning performance, support of the existing applications, project coordination and prioritizing the tasks.
• Identify issues, review errors, approve resolution, and advise of potential downstream impacts
• Effective communication with various internal Host teams and external vendors as and when needed.
• Identified and improved the business process and adding additional check points and to automate the process as much as possible to reduce the human intervention.
• Optimization of the existing applications at the mapping, session and database level for better performance.
• Working with CA workload control center Views(Autosys) to find the dependencies, Off Hold, On Hold and Force Starting the Autosys jobs as needed.
• Worked with various UNIX commands, FTP the files and creating and executing shell scripts.
• Expertise in performing root cause analysis and proving the solutions and Implementing them to fix Data/Component Error Issues in Informatica and Netezza DB.
• Developed mappings to read data from Legacy Systems & write to Database and Developed SCD Type 2 Dimension.
• Providing the DB Table and View Access to Developers and Business users in IBM Netezza
• Regular interaction with the Data modelers, Product managers and Business users to understand the Business requirements.
• Design and development of complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected/Unconnected Lookup(Static/Dynamic), Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Made use of Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time.
• Developed PL/SQL procedures for Pre-session and Post-session data loading.
• Effective and timely communication to vendors for host files and data related issues/enquiries.
• Regular communication between Onsite/Offshore teams on Daily basis.

Environment: Informatica Power Center 9.5.1, IBM Netezza 4.2.1, Aginity Workbench, Oracle 10g, TOAD, Flat files, UNIX Putty 0.63, Autosys, OBIEE 11.1.2, SNOW, Informatica B2B Data Exchange.

Confidential, Houston, TX

Informatica ETL Developer

Responsibilities:

• Worked in all phases of SDLC from requirement gathering, design, development, testing, training and rollout to the field user and support for production environment.
• Prepared the low level technical design documents based on functionality required
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
• Performance tuning of Informatica sessions for large data files has been done by increasing the Buffer block size, data cache size, and sequence buffer length.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy for populating the desired.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Migrated mappings and sessions from development repository to production repository
• Performed Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Worked with BI team while generating reports using IBM Cognos.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.

Environment: Informatica PowerCenter 9.1, Oracle 11g, TOAD, PL/SQL, Flat files, Netezza, Mainframes, UNIX Shell Scripting and Cognos

Confidential

Informatica Development/ Support

Responsibilities:

• Understanding requirements and preparation/review of High level, Low level design documents and technical specification documents.
• Enhancement of Daily and Historical workflows according to the requirements
• Used Unix Shell Scripts to execute the DLY and HST Workflows.
• Developed mappings using different transformations like Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Worked with Parameters and Variables, Pre SQL/Post SQL, Pre session and post session commands, Emails in Mappings and Sessions.
• Generated Scripts using Oracle Pl/SQL whenever needed.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Created sessions and workflows to sequentially execute the designed jobs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session to check the progress of data load.
• Worked with PMCMD commands like start workflow, schedule workflows, stop workflow, abort workflow etc.
• Migrated the Informatica PowerCenter mappings and Code/Folder migration from one environment to another as part of release management.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows).
• Extensively worked with mappings variables, session variables and workflow variables
• Worked on pre and post session commands to send email notifications using Informatica Workflow Manager and renaming files in UNIX.
• Migrating ETL changes from DEV to QA. Also involved in taking Repository backup to avoid any loss of code being developed
• Worked with QA team providing Developer support and resolving any issues in test environment

Environment: Informatica PowerCenter 8.6, Oracle 11g, TOAD, PL/SQL, Flat files, UNIX Shell Scripting, Sybase and DB2.

Confidential

ETL Developer

Responsibilities:

• Understanding the customer requirements and analyzing or resolving the discrepancies in the business requirements
• Prepared the Design documents as per the requirements of the Business Analysts and Data model
• Prepared low level design documents for Informatica Mappings.
• Extracted the data from Different Sources like Oracle, Flat files, MS Access, Xml.
• Designed and developed Informatica Mappings to load data from Source systems to stage and then to Data Mart.
• Developed complex mappings using transformations like Update strategy, Lookup, Stored procedure, SQL, Sequence generator, Joiner, Aggregate, and Expression transformations in extracting data in compliance with the business logic..
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance
• Created stored procedures, views, cursors, triggers, functions inPL/SQL
• Creating the Workflow and Running the Workflow by using Workflow Manager.
• Unit testing for validating the data to meet Business requirements.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, DB2, PL/SQL, Toad, SQL, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Worked with Business analysts and the DBA for gathering requirements and for project coordination.
• Implemented logical and physical data modeling with STAR schema techniques.
• Performance tuning of Informatica sessions for large data files has been done by increasing the block size, data cache size, and sequence buffer length.
• Worked on Informatica - Source Analyzer, Mapping Designer and transformations.
• Extensively used Normal Join, Full Outer Join, Master Outer Join, Detail Outer Join in the Joiner Transformation.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Developed Data Migration document and ETL mapping documents for every mapping for smooth transfer of project from development to testing environment and then to production environment.
• Developed Shell Scripts, PL/SQL stored procedures, table and Index creation scripts.
• Created complex transformations using Source Qualifier, Joiner, Aggregator, Lookup, Router, Expression, Update Strategy and Sequence Generator.
• Used Informatica PowerCenter Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in developing the SQL scripts for Extract and load the data warehouse.
• Involved in Unit and Integration testing of Informatica Sessions and Target Data.
• Used workflow Monitor to monitor the performance of workflows.

Environment: Informatica PowerCenter 8.x, SQL+,PL/SQL, Oracle 10g, Windows 2000 Professional/98/XP, Toad.