SUMMARY

• 8 years of total IT experience and technical proficiency in building Enterprise Data warehouse, Data Marts, Operational Data Stores in major industry sectors like Finance, Health, Insurance and Tele Communication Using Informatica Power Center 10.1/9.6.1/9.5.1/8.6.1/8.1.1.
• Expertise in entire life cycle of DWH with project scope, Analysis, requirements gathering, data modeling, ETL Design, development, Unit / System testing and production support.
• Strong experience in Understanding Dimensional Modeling - Star and Snow Flake Schema, Identifying Facts and Dimensions.
• Expertise in working with relational databases such as Oracle 12c/11g/10g, Teradata 15/14/12, SQL Server 2000/2005/2008, DB2, My Sql, Sybase as well with Flat Files & XML.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries and Oracle PL/SQL.
• Having strong Experience in Informatica & Teradata combination in Enterprise Warehouse environment.
• Having strong experience in using Teradata utilities like TPT, FASTLOAD, MULTILOAD, TPUMP, FAST EXPORT and BTEQ scripts.
• Strong Experience with Teradata performance tuning using Explain Plan.
• Strong experience and understanding on using Indexes, PPIs and Data Recovery & Protection options in Teradata.
• Heavily supported Teradata Production environments for different kinds of failures and fixes.
• Developed mappings in Informatica to load teh data from various sources into teh Data Warehouse, using different transformations like Source Qualifier, Java, Expression, Lookup, Aggregate, Update Strategy, Transaction control, Normalizer and Joiner.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience with Partitioning at Informatica level
• Extensive experience in writing UNIX shell scripts and automation of teh ETL processes using UNIX shell scripting.
• Knowledge about IDQ, Informatica MDM.
• Experience in using Automation Scheduling tools like Maestro, Crontab, Autosys and Control-M.
• Worked extensively with slowly changing dimensions (SCDs) and Change data capture (CDC).
• Experience with supporting heavy Data Warehouse Environments.
• Experience in Creating Design Documents, Run Books and Test Documents.
• Expertise with release & change Management.
• Implemented several DWH Projects with both Agile & Water Fall Methodologies. Experience with Agile tools Rally & Jira for task tracking.
• Good communication skills with strong ability to interact with end-users, customers, and team members.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1/9.6.1/9.5.1/8.6.1/8.1.1

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, Erwin, Microsoft Visio

RDBMS: Oracle 12c/11g/10g, Teradata 15/14/13/12, DB2, SQL Server 2000/2005/2008, MySQL, Sybase

QA Tools: Win Runner, QuickTestPro, Test Director, Quality Center

Reporting Tools: Cognos, Business Objects, Dashboard Reporting

Languages: Java, XML, UNIX Shell Scripting, SQL, PL/SQL

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Sunrise, FL

Sr. Informatica/Teradata Developer

Responsibilities:

• Involved in discussion of user and business requirements with business team.
• Attended teh meetings with business integrators to discuss in-depth analysis of design level issues.
• Involved in data design and modeling by specifying teh physical infrastructure, system study, design, and development.
• Developed internal and external Interfaces to send teh data in regular intervals to Data warehouse systems
• Performed data migration in different sites on regular basis.
• Developed complex SQL queries to develop teh Interfaces to extract teh data in regular intervals to meet teh business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using teh Informatica designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator and Router transformations for populating target tables in efficient manner.
• Created mapplet and used them in different mappings.
• Extensively involved in performance tuning of teh Informatica ETL mappings by using teh caches and overriding teh SQL queries and also by using Parameter files.
• Worked on Flat Files and XML, DB2, Oracle as sources.
• Written PL/SQL Procedures and functions.
• Involved in change data capture (CDC) ETL process.
• Implemented Slowly Changing Dimension Type I & Type II for different Dimensions.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating teh execution of maps.
• Involved in Informatica, Teradata and Oracle upgrade process and testing teh environment while up gradation.
• Worked with Informatica version Control excessively.
• Written Unit test scripts to test teh developed interfaces.
• Managed enhancements and coordinated with every release with in Informatica & Teradata objects
• Worked under Agile methodology and used version one to track teh tasks.
• Written thorough design docs, unit test documentation & Deployment documents.
• Supported production environment and also implemented teh system in different sites.

Environment: Informatica Power Center 10.1/9.6.1/9.5.1, Teradata 15/14/12, Oracle 10g, DB2, XML, Flat Files, Sql Assistant, Toad, PL/SQL, Unix shell scripting, Cognos, Rally, Windows.

Confidential, Richmond, VA

Sr. Informatica/Teradata Developer

Responsibilities:

• Worked on Business support request (BSR) raised by business users for critical/high priority issues.
• Involved in creation of HLD and LLD document based on BR and got those reviewed by customers along with detailed project time lines.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Developed teh mappings, applied rules and transformation logics as per teh source and target system requirements.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into teh Teradata using Teradata Utilities.
• Designing teh ETLs and conducting review meets Involvement in implementation of BTEQ jobs.
• Wrote appropriate code in teh conversions as per teh Business Logic using BTEQ, Fast Exports, Multi loads and Fast Load scripts.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Coding using BTEQ SQL of TERADATA, wrote UNIX scripts to validate, format and execute teh SQL’s on UNIX environment.
• Created mapping documents to outline data flow from sources to targets. Parsed high-level design specification to simple ETL coding and mapping standards.
• Used Self-CAT for validating, promoting, importing and exporting jobs from development environment to testing environment.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that teh data is loaded in teh tables in a timely and appropriate manner.
• Tuned teh performance of jobs by following Control - m best practices and also applied several methods to get best performance by decreasing teh run time of workflows.
• Scheduling jobs and implementing dependencies if necessary using Control-m.
• Managed post production issues and delivered all assignments/projects within specified time lines.
• Involved in unit testing, Integration testing and User acceptance testing of teh mappings.
• Involved in Migrating teh Informatica objects using Unix SVN from Dev to QA Repository.
• Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to teh target tables.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures usingInformaticasession logs.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

Environment: InformaticaPower Center 9.6.1, Flat Files, Oracle 11g, Teradata 14.0, SQL Assistant, PL/SQL, TOAD, Self - CAT, Unix, Putty Control-m, SVN.

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

• Worked with Business data Analysts (BDA) to understand teh requirements.
• Extracted data from various heterogeneous sources like oracle, Flat Files using Informatica Power center and loaded data in target database Teradata.
• Migrated Legacy data from DB2 to Teradata.
• Involved in DWH up gradation for source system changes.
• Utilized all teh features of Source Qualifier transformation such as filter, joiner, sorter and SQL override to teh extend level at teh source level.
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, LookUp, Filter and Union in developing teh mappings to migrate teh data from source to target.
• Worked with External stored procedures for data cleansing purpose.
• Extensively used Lookup transformation and Lookup Caches in looking teh data from relational and Flat Files.
• Created Mapping parameters and Variables and written parameter files.
• Created UNIX shell scripts for various needs.
• Involved in doing Unit Testing, Integration Testing and Data Validation.
• Implemented various Performance Tuning techniques by finding teh bottle necks at source, target, mapping and session and optimizing them.
• Worked with teh Debugger Wizard in debugging teh mappings.
• Extensively worked with session logs and workflow logs in doing Error Handling and trouble shooting.
• Worked with teh Control M scheduling team in scheduling Informatica Jobs as per teh requirement and frequency.
• Worked with teh Cognos team in generating various reports.
• Involved in preparing teh Migration Documents.
• Implemented Informatica Procedures and Standards while developing and testing teh Informatica objects.

Environment: Informatica Power Center 9.5.1/9.6.1, Oracle, DB2, Flat Files, Teradata 14, Toad, Ultra Edit - 32, SQL Assistant, Control Center, MS-Visio, Cognos, UNIX, Windows.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in Dimensional modeling to Design and develop STAR Schemas, used ERWIN, identifying Fact and Dimension Tables.
• Created ETL Packages and implement new data extracts, transformations, and load routines to populate teh Data Warehouse utilizing teh Kimball Methodology to populate dimension and fact tables.
• Worked with different Sources such as Oracle, MS SQL Server and Flat file.
• Extensively used several transformations such as Source Qualifier, Router, Lookup (connected & unconnected), Update Strategy, Joiner, Expression, Aggregator and Sequence generator transformations.
• Identified and tracked teh slowly changing dimensions, heterogeneous Sources and determined teh hierarchies in dimensions
• Used Trillium as a Data Cleansing tool to correct teh data before loading into teh staging area
• Accomplished data movement process that load data from databases, files into Teradata by teh development of Korn Shell scripts, using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, TPT.
• Tuned Teradata SQL Queries
• Created reusable transformations and Mapplets and used them in mappings
• Used Informatica Repository Manager to maintain all teh repositories of various applications
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for teh Claim Profitability Systems to facilitate Daily, Monthly and yearly Loading of Data
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and teh Target Data
• Worked on SQL tools like TOAD to run SQL queries to validate teh data
• Design and Development of pre-session, post-session and batch execution routines to run Informatica sessions using Informatica Server
• Created and Scheduled sessions & Work lets using workflow Manager to load teh data into teh Target Database
• Wrote PL/SQL stored Procedures and Functions for Stored Procedure Transformations
• Used Control - M scheduler to automate teh process

Environment: Informatica Power Center 9.1.1/8.6.1, Power Exchange, Oracle9i, PL/SQL, DB2, MS SQL Server 2000, Teradata 14, MS Enterprise Manager, MS Query Analyzer, Flat file, XML, Control-M (scheduler), Linux, UNIX shell scripting, TOAD, ERWIN, Java, JMS, Windows.

Confidential, Bellevue, WA

Programmer Analyst/ETL Developer

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts
• Maintain Data Flow Diagrams (DFD’s) and ETL Technical Specs or lower level design documents for all teh source applications
• Worked with source databases like Oracle, SQL Server and Flat Files
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations
• Created complex mappings using Unconnected and Connected lookup Transformations
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks
• Responsible for teh performance tuning of teh ETL process at source level, target level, mapping level and session level
• Worked extensively with update strategy transformation for implementing inserts and updates
• Extensively used teh tasks like email task to deliver teh generated reports to teh mailboxes and command tasks to write post session and pre session commands
• Extensively used debugger to test teh logic implemented in teh mappings
• Performed error handing using session logs
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval
• As per business we implemented Auditing and Balancing on teh transactional sources so that every record read is either captured in teh maintenance tables or wrote to Target tables
• Auditing is captured in teh audit table and EOD snapshot of daily entry is sent to teh distributed list to analyze if anything is abnormal
• Monitored workflows and session using Power Center workflows monitor
• Used Informatica Scheduler for scheduling teh workflows

Environment: Informatica Power Center 9.1.1/8.6.1, Oracle 10g, Sql Server,DB2, SQL, PL/SQL, Cognos, Maestro, Unix AIX and windows.