SUMMARY:

• 8 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of OLTP and OLAP systems
• Experience in Full Life Cycle Development of building Data Warehouse, ETL, OLAP applications
• Expertise in Data warehouse ETL Informatica 9.x/8.x/ 7.x, Oracle 11g/10g/9i/8i and MS SQL Server 2008/2005, Teradata 13.0, 12.0
• Extensive knowledge on Informatica Data Quality (IDQ) 9.x,8.x Standards, Profiling, Dictionaries, Data Quality Lifecycles and best practices
• Strong hands on experience using Teradata utilities (BTEQ, FastLoad, MultiLoad, FastExport, Tpump)
• Highly proficient in writing, testing and implementation of Triggers, stored procedures, functions using PL/SQL and T - SQL
• Expertise in creating tables, triggers, macros, views, stored procedures, functions and Packages in Teradata database
• Strong business understanding of verticals like Banking and Financial Services, Insurance, Healthcare, Pharmaceuticals, Telecom, Retail, Logistics and Transportation
• Extensive experience in Data Extraction, Integration, Transformation and Loading data from multiple heterogeneous data sources such as Oracle, MS SQL Server, Teradata, XML and Confidential
• Expertise in Informatica Power Center tools - Source Analyzer, Target Analyzer, Mapping Designer, Mapplet Designer and Informatica Repository Manager
• Proficient in creating complex Mappings using Informatica Power Center Designer using different transformations such as Aggregator, Expression, Filter, Lookup, Normalizer, Router, Source Qualifier, Sorter, Sequence Generator, XML, Stored Procedure transformations and Update Strategy to implement business rules and
• Create Workflows in Workflow Manager using different tasks such as Session, Email, Command, Event-Raise, Event-Wait and Decision
• Create UNIX shell scripts to run Informatica workflows and control the ETL flow
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman)
• Experience with dimensional modeling using Star Schema and Snowflake Schema models, Surrogate keys, Normalization/De normalization
• Implement various Performance Tuning techniques on Sources, Targets, Mappings and sessions
• Experience with using Informatica debugger for identifying bugs in existing mappings by analyzing data flow and evaluating transformations
• Proficient in implementing Slowly Changing Dimensions
• Excellent working knowledge on reporting tools like Crystal Reports 2011 and Business Objects XI
• Independently perform complex troubleshooting, root-cause analysis and solution development
• Quick learner, highly motivated, result oriented and an enthusiastic team player
• Excellent interpersonal and communication skills

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.x,8.x,7.x, Informatica Data Quality 9.x,8.x

Database Systems: Oracle 11g/10g/9i/8i, MS SQL server 2008/2005, Teradata 13.0/12.0, MS Access

PL/SQL, T: SQL, UNIX Shell Scripting

Database Tools: SQL*Plus, Oracle SQL developer, TOAD, SQL Server Management Studio, Teradata SQL Assistant, ERWin

Reporting Tools: Crystal Reports 2011, Business Objects XI, Business Intelligence Reporting Tool

Internet Technologies and Microsoft tools: HTML, XML, XSD, CSS, MS Office Suite (Word, Excel, Power Point, Visio)

Environment: Windows NT / 2000 / XP Pro / Vista, Windows Server / 2008, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Sr. Application Developer

Confidential, Hartford, CT

Responsibilities:

• Involved in the design and development phase of the MDM project
• Held requirement gathering meetings to gather requirements from stakeholders
• As a lead Informatica developer managed and coordinated between onsite client and offshore team
• Extensively worked on Slowly Changing Dimensions Type1 and Type2 for Data Loads
• Performed data manipulations and designed complex mappings using several transformations such as Source Qualifier, Sorter, Aggregator, Filter, Router, Lookup, Union, Rank, Stored Procedure and Expression
• Used MD5 function to capture changes and Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic
• Created several mappings in Informatica Data Quality (IDQ) using multi-strategy transformations like Standardizer, Labeler, Merge, Parser, Match, Decision
• Worked extensively on IDQ Data Profiling including column, join and multi object
• Created Dictionaries in IDQ from Profile data
• Used debugger to identify bugs in existing mappings by analyzing data flow and evaluating transformations
• Created Mapplets to enhance reusability in mappings
• Migrated code from development to QA using repository import/export wizard
• Created UNIX shell scripts in the pre-session and post-session for error logging and created automation scripts according to needs of the project and client requirement
• Involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, Created test data
• Optimized query performance and session performance
• Completed documentation in relation to detailed work plans, mapping documents and high-level data models
• Prepared and presented weekly status reports to the client and communicated team progress
• Held KT sessions and demonstrated tips and tricks in Informatica power center to new Informatica developers on the client side

Environment: Informatica Power Center 9.1, Informatica Data Quality (IDQ 9.1), Oracle 11g, Confidential, Windows NT, SQL Server 2008/2005, Toad Data Point, PL/SQL, UNIX

Sr. ETL Developer

Confidential ., Irving, TX

Responsibilities:

• Actively involved in gathering requirements from end users and modifying various technical and functional specifications in the development
• Involved in Data Modeling for Data Warehouse
• Extracted data from Flat flies and Relational databases into staging area
• Designed and developed STAR Schema including identifying FACTS and Dimensions
• Developed Informatica Mappings and Reusable Transformations to facilitate timely loading of data into Star schema
• Developed Informatica Mappings using different transformations such as Source Qualifier, Aggregator, SQL overrides, Filter, Router, Sequence Generator, Lookups, XML Generator and Update Strategy to fulfill business requirements
• Worked with slowly changing dimension Type1, Type2 and Type3
• Extensively worked on UNIX Shell scripts and invoked oracle procedures and Informatica workflows via shell scripts
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance enhancements
• Used Pre and Post SQL in target entity to drop and rebuild indexes in the source database to enhance performance
• Extensively worked with Lookup Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Developed several reusable Transformations and Mapplets that facilitate other mapping
• Developed Workflows using Task Developer, Worklet Designer and Workflow Designer, Workflow Manager and monitored the results using Workflow Monitor
• Extensively used SQL commandswithTOADenvironment to create Target tables
• Optimized performance tuning at source, target, mapping and session level
• Performance tuning of Informatica sessions for large data files has been done by increasing block size, data cache size and sequence buffer length
• Responsible for error handling using Session Logs, Reject Files and Workflow Logs in the Workflow Monitor
• Created and generated reports as per client’s requirements using SAP Business Objects XI

Environment: Informatica Power Center 9.1/8.6.1, Confidential, ERWin, Oracle 11g/10g, Windows NT, SQL Server 2008/2005, Toad, PL/SQL, UNIX, SAP Business Objects XI

Sr. Informatica Developer

Confidential, Omaha, NE

Responsibilities:

• Involved in design, development and maintenance of Informatica PowerCenter and Informatica Data Quality (IDQ) application for matching and merging process
• Utilized IDQ to create complex quality rules, tables, mapplets to cleanse, parse, standardize, validate input dataset
• Worked extensively on Data Profiling including column, join and multi object
• Integrated IDQ mapplets with PowerCenter mappings
• Extensively used IDQ for data profiling and data cleansing
• Designed complex mappings in Informatica PowerCenter using Source Qualifier, Sorter, Aggregator, Filter, Router, Lookup, Union, Rank, Stored Procedure and Expression transformations to implement business logic to load data into staging area
• Captured and implemented Type1 and Type 2 Slowly Changing Dimensions
• Initialized the Repository object, Scheduler to run Workflows continuously, repeat at a given time and manually start a Workflow
• Used SQL tools like TOAD, Teradata Assistant to run SQL queries and validate the data
• Utilized Fastload and Multiload Teradata utilities for data loading into the database
• Wrote numerousBTEQ scriptsto run complex queries on theTeradata database. Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Used PMCMD command to execute workflow and created UNIX shell script to copy files from one folder to another folder and for scheduling various data cleaning and loading processes
• Applied various components like Parameter files, Variables to get the best performance by reducing load time for daily loading process and decrease run time of workflows
• Indentified and resolved Lookup, Joiner and Aggregator transformation bottlenecks using performance tuning measures
• Worked with Session logs and Workflow logs for Error handling and debugging
• Generated multiple reports as per user requirements using Crystal Reports, MS Excel

Environment: Informatica PowerCenter 9.1, Informatica Data Quality (IDQ 8.6.1), Confidential, Oracle 11g/10g, WindowsNT, SQL Server 2008, Teradata 12.0/13.0, Teradata SQL Assistant, BTEQ, Toad, PL/SQL, UNIX shell scripting

Informatica/Oracle Developer

Confidential, Wilmington, DE

Responsibilities:

• Involved in all phases of SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Developed and modified complex database objects such as Functions, Stored Procedures, Packages and Triggers using PL/SQL
• Worked with SQL*Loader to load data from Confidential into Oracle database
• Worked closely with users to develop the transformation logic to be used in Informatica Power Center
• Extensively worked with Informatica client tools - Designer, Workflow Manager, Workflow Monitor, Repository Manager and Informatica server to load data from Confidential and Oracle database
• Developed ETL Mappings, Sessions and Workflows using various transformations such as Source Qualifier, Sorter, Aggregator, Joiner, Router, Lookup, Update Strategy and Union
• Extensively used Mapping Variables, Parameter and Parameter Files for incremental loading
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirement
• Worked with Autosys for Scheduling and Monitoring of jobs
• Optimized/ Tuned mapping for better performance and efficiency
• Migrated Informatica mappings, sessions and workflow from development to QA and QA to Production
• Created, Dropped and Rebuilt Indexes on the tables to enhance database performance
• Monitor production loads daily, monthly and quarterly
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• On call Production Support

Environment: Informatica Power Center 8.1.1, Oracle 9i/10g/11g, PL/SQL, SQL*Loader, SQL*Plus

Informatica Developer

Confidential

Responsibilities:

• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production
• Involved in analysis and design of physical and logical data models for Enterprise data warehouse with a pool of various data marts
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers
• Extensively worked with Slowly Changing Dimensions Type1 and Type2 for Data Loads
• Involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, Created test data
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables
• Used debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations
• Migrated code from test to production environment
• Created Mapplets to enhance reusability in mappings
• Optimized query performance and session performance
• Designed workflows with many sessions with decision, event wait, and event raise tasks
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of a data warehouse team

Environment: Informatica Power Center 7.1.1, Oracle 9i/8i, SQL Server, UNIX, Autosys, Windows NT