SUMMARY:

• Around 9 years of professional experience in Requirements gathering, Analysis and design of Data warehouse and Data mart.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Oracle 10g/11g, Teradata, DB2, Flat files, CSV files and Microsoft SQL Server.
• Extensively worked on Informatica Power Center Components - Power Center Designer, Workflow Manager to create workflows and sessions, Workflow Monitor and Repository Manager.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Worked on Teradata utilities like fastload, MultiLoad and FastExport.
• Extensively worked with Slowly Changing Dimensions (Type I, Type II).
• Experience in using Automation Scheduling tools like Autosys.
• Good expertise in Performance Tuning Confidential Database and Informatica side like Source, Target, Mapping, Transformation and Session to make them more efficient in terms of session performance.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Experience in IDQ and Informatica Data Analyst tool for running profiles and score cards.
• Experience in developing Business Glossary using Informatica Data Analyst Tool.
• Experience in developing and monitoring ETL Packages and DTS packages using SQL server Integration Services (SSIS).
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience in developing Deski and Web Intelligence Reports using Business Objects reporting tool
• Good experience in working with Onsite-Offshore model and having good leadership qualities
• Experience in all the phases of the Data Warehouse project life cycle involving design, development and Implementation of Data warehouses using ETL, Online Analytical Processing & reporting tools(BO)
• Good Understanding of Logical and Physical Data Modeling, Dimensional Data Modeling, Star Schema/Snow Flake Schema
• Good Understanding of Unix commands. Developed Shell scripts to transfer files from one server to other server.
• Preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Extensively involved in using Quality Center, Clear Quest to report bugs.
• Good knowledge on Python.
• Shown commitment and enthusiasm to achieve the dead lines by effective time management.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6/8.6, Informatica Data Analyst Tool, SSIS, IDQ

Database & Related Tools: Oracle 10g/9i/8i,Toad,Teradata, MS SQL Server 2005/2008, Oracle SQL Developer, Putty, WinSCP

Data Modeling Tools: Oracle SQL Developer tool, Erwin Tool

Languages: SQL, PL/SQL, Python, Unix Shell Scripting

Operating Systems: Window / 98/2000/2003/2008/ XP, Unix.

BI Tools: Business Objects 3.1

Other: MS Word, MS Excel, MS Office 2003/2007/2010, Outlook, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, New Jersey

Informatica Developer

Tools: Informatica 9.6, IDQ, Data Analyst tool, SQL Developer, Putty, WinSCP

Responsibilities:

• Primarily responsible to convert business requirements (BRD’s) into ETL Specifications.
• Worked as Onsite Coordinator.
• Experience in working on extracting data from different sources likes IBM MQ, Oracle, MS Access, Flat files and Teradata.
• Extensively used Informatica Power Center client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Developed complex mappings in Informatica to load the data using different transformations and maintained Informatica naming standards.
• Implemented various Transformations: Expression, Joiner, Sorter, Aggregator, Lookup, Filter, Router, Update Strategy and Transaction Control Transformations.
• Prepared unit test cases for developed mappings, workflows
• Written complex SQL queries to analyze problems.
• Used Data Analyst tool for performing data validation, running profiles and score cards.
• Developed Mappings using IDQ tool and ran some Data Profiles using IDQ tool.
• Involved in Data Cleansing using Informatica and Data Analyst tool.
• Developed Shell scripts to transfer files from one server to other server.
• Developed Shell Scripts for the generation of reports and transferring over the email.
• Performance tuning for mappings, Sessions where ever applicable.
• Supported UAT & Fixed the Issues raised by users
• Developed UNIX shell scripts to automate daily loads and used Informatica scheduler to Schedule workflows.
• Raised Clear Quest request (CQ) to migrate codes, Tables (new), Grant requests for tables, from dev to QA, UAT and Production.
• Worked in Incident and change management processes (SLA).

Confidential

Sr. Software Engineer/ Informatica Developer

Tools: Informatica 9.6, Business Objects 3.1, IDQ, Informatica Data Analyst tool

Responsibilities:

• Worked as an Informatica developer
• Gathered requirements and developed mappings to maintain metadata in Repository.
• Extensively worked to load data from Oracle, Teradata, flat files into the target Oracle database.
• Implemented various Transformations: Joiner, Sorter, Aggregate, Expression, Lookup, Filter, Update Strategy and Router.
• Modified the existing mappings for updated logic and better performance.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Worked on Mapplets and created parameter files wherever necessary to facilitate reusability.
• Used Error Handling to capture error data in tables for handling nulls, analysis and error remediation Process.
• Tuning the complex mappings based on source, target and mapping, session level.
• Strong experience in Oracle.
• Avoided Duplicate issues through SQL override using look up, Joiner transformations.
• Performed Unit Testing on the mappings.
• 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.
• Developed and Scheduled jobs for daily loads that invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables for batch process.
• Ensured that integration testing and system testing followed with QA and change management procedures.
• Involved in production support by monitoring ETL jobs which went live.
• Used Data Analyst tool for performing data validation, running profiles and score cards.
• Involved in Data Cleansing using Informatica and Data Analyst tool.
• Developed Business Glossary using Informatica Data analyst tool
• Experience in using IDQ Tool for Profiling, applying Business rules and developed mappings to move data from source to Target systems
• Developed Deski and Web Intelligence Reports using Business Object tool

Confidential

Informatica Developer

DB& Tools: Informatica 8.6, Oracle 10g, Toad, UNIX (Putty)

Responsibilities:

• Analyzed various Schemas for Implementation and Modeled the Data Warehousing Data marts using Star Schema.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Created and Monitored Sessions and Batches.
• Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager.
• Generated completion messages and status reports using Workflow manager.
• Created workflows and worklets for designed mappings.
• Developed mappings and loaded data on to the relational database. Worked on Dimension as well as Fact tables.
• Experience in using Automation Scheduling tools like Autosys.
• Extensively used PL/SQL Procedures/Functions to build business rules.
• Created User conditions and Filters to improve the report generation.

Confidential

ETL Developer

Tools: & DB Informatica 8.6, SSIS, Oracle 10g, Toad, SQL Server, UNIX

Responsibilities:

• Created complex mappings using various Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, Transaction control, Sorter etc. as per the business requirements
• Extracted data from heterogeneous sources like Flat files, CSV Files and Oracle database and applied business logic to load them in to the Data warehouse
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager.
• Designed workflows with many sessions, tasks (Decision, Assignment task, Event wait) and used Informatica scheduler to schedule jobs.
• Created workflows and worklets for designed mappings.
• Involved in data cleansing and Performance Tuning of ETL Mappings and sessions (using Partitioning, Pushdown Optimization etc).
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Generated Email Notifications and status reports using Email Tasks in Workflow manager.
• Performed Unit testing Confidential 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.
• Performed Data integration techniques for data warehouse using Informatica power center.
• Working on creating SSIS packages using BIML script.
• Created the SSIS packages to load the Staging environment.
• Implemented Incremental load used Event Handlers to clean the data from different data sources.
• Created SSIS packages to extract/write data to Flat Files.
• Written command line scripts and embedded them into SSIS package to merge/zip files.

Confidential

ETL Developer

DB & Tools: Informatica 8.6, Business Objects, Oracle 10g, Putty

Responsibilities:

• Interacting with the Functional Owners and end users to understand the business demands and mapping the same into the functional specification.
• Developed ETL Code using Informatica Power Center, SQL and Unix Scripts.
• Developed Web Intelligence Reports using Business Object tool
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow manager.
• Extracted data from heterogeneous sources like Oracle, XML files, Flat files & CSV files
• Designed Informatica mappings by translating the business requirements.
• Studied Session Log files to correct errors in mappings and sessions.
• Performed unit testing for the mappings.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, etc.
• Involved in creation of Mapplets, Worklets, Reusable transformations, shared folder, and shortcuts as per the requirements.
• Development of shell scripts
• Prepared unit test cases for developed mappings, workflows
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.