SUMMARY:

• Having 8+ years of IT experience in the Analysis, Design, Developing and Testing and Implementation of business application systems.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Worked and on large and small teams for development of Web based Enterprise Applications.
• Hands on experience in Pentaho Business Intelligence Server Studio.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Java Transformation, Router and Sequence generator.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Design and development of multi-layer Web Based information systems using Web Services including Java and JSP
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Expertise in using the Teradata utilities such as the TPT, MLOAD, FASTLOAD, etc.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.5/9.1/8.x (PowerCenter designer, repository manager, workflow manager, workflow monitor)

LANGUAGES: SQL, PL/SQL, Unix Shell Script, Python

REPORTING TOOLS: Tableau, Excel

DATABASES: Oracle 11g/10g/9i, Teradata 13.10/12.10, db2, MS SQL server 2005/2000

JOB SCHEDULING: Autosys, tidal, control-m, informatica scheduler Informatica Power Center 9.6.1, Oracle 11g, PLSQL, UNIX Scripting, Toad 10.1, Tidal Scheduler, Cron Tab, Agile SDLC.

OPERATING SYSTEM: Windows XP/7, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Sr. ETL / Informatica developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Loading data to the staging tables following the Data Integrity rules of Interface Design Specifications.
• Used source external tables to load the data to the staging tables.
• Created mapping documents to outline data flow from sources to targets.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Developed and scheduled the Jobs using Autosys Scheduler.

Environment: Informatica PowerCenter 9.0.1, Flat files, Excel files, Oracle11g, Erwin, Autosys, UN

Confidential, NYC, NY

Sr. ETL/Informatica Developer

Responsibilities:

• Worked with end users to understand the Business Requirements, Designing the Workflow, Implementing and Supporting on ongoing basis.
• Expert in writing SQL, PL/SQL Stored procedures using Toad. Experience with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, Fast Export, SQL Assistant, T-PUMP.
• Experienced on writing SQL statements and analyzing SQL performance.
• Ability to work in teams.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting
• Designed data transformation from staging to fact and dimension tables in the warehouse.
• Loaded data to the interface tables in oracle from multiple data sources using informatica.
• Implemented Aggregator, Filter, Joiner, Expression, Lookup, Normalizer and Update Strategy transformations.
• Assisted in upgradation of informatica system from Informatica PowerCenter 8.6 to Informatica PowerCenter 9.1.
• Extensively worked on the performance tuning of the Informatica Power Center Mappings as well as the tuning of the sessions.
• Implemented variables and parameters in transformations to calculate billing data.
• Customizing/configuring Business Data director (BDD) /Informatica data director (IDD) applications.
• Created sessions, sequential and concurrent batches for the mappings using Workflow Manager.
• Writing stored procedures, functions and packages to implement business logic
• Worked on different utilities of Teradata like fast load, M-load, T-pump, and Fast export.
• Developing, executing & monitoring Autosys (Process Scheduler) jobs.
• Wrote services to store and retrieve user data from the MongoDB for the application on devices.

Environment: Informatica PowerCenter 9.1, Flat Files, Autosys, HP ALM (Application Lifecycle Management), Win SCP, Teradata v13, MongoDB.

Confidential, Union, NJ

ETL Developer

Responsibilities:

• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Analyzed the system, met with end users and business units in order to define the requirements
• Extracted the data from Oracle, SQL Server and load into Data warehouse.
• Wrote SQL Queries, Triggers, PL/SQL Procedures, Packages and Shell Scripts to apply and maintain the business rules.
• Translated business requirements into Informatica mappings/workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expression and aggregator transformations to pipeline data to Data Warehouse/Data Marts.
• Performance Tuning of existing mappings.
• Developed Mappings that extract data form ODS to Data mart and Monitored the Daily and Weekly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitorto load data into target Oracle database.
• Worked with Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and setmaxvariable.
• Migrated existing mappings to production environment.
• Designed the reports and Universes as per the requirements.

Environment: Informatica PowerCenter8.6, Oracle 9i, PL/SQL, SQL Server, Toad, Windows NT, UNIX Shell Scripts, Business Objects.

Confidential

ETL (Informatica) Developer

Responsibilities:

• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extracted the data from both homogenous and heterogeneous.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Developed mapplets and reusable transformations to prevent redundancy of transformation usage and maintainability.
• Monitor; troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Identifying and acquiring new data sources.
• Creating and maintaining consistent reference data and master data definitions.
• Extensively worked with Designer tools like Source Analyser, Target designer, Mapping designer, mapplet designer, Transformation Developer.

Environment: Informatica Powercenter 9.6.1 and 10.0.1 Oracle 12g, PL/SQL, UNIX Shell Scripting, MySQL

Confidential

ETL / Informatica developer

Responsibilities:

• Gathered user requirements and designed source to target data load specifications based on business rules.
• Used Informatica Power Center to load data from Flat Files to DB2, XML files to DB2, Flat Files to Oracle.
• Staged vendor data as provided by the vendor. Applied transformation logic to extract datasets.
• Analyzed Data warehouse and data elements documents received from the vendor Morningstar.
• Used Tic stream to download Global Equity data files, validated and staged the data.
• Applied data validations and loaded the source data to the target tables using Informatica.
• Created control files and used SQL Loader to load the data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Worked on performance tuning for the workflows that took longer time to load the data.
• Automation of workflows to run daily and monthly jobs.
• Created and maintained various UNIX Shell Scripts for loading process.
• Created deployment groups, migrated the code into different environments.
• Developed Oracle PL/SQL Stored Procedures, Performance and fine Tuning of SQL.
• Performed Unit testing by executing the SQL scripts and comparing the source with target data.
• Created and documented ETL test Cases and Validations.