SUMMARY:

• Over 6 Years of working experience as Informatica ETL developer using Informatica power center 9.x/8.x/7.x with strong knowledge on Data ware house concepts and data modelling.
• Extreme Utilization of Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager, metadata Manager.
• Strong knowledge in Installation, configuration and Administration of power center tool
• Complete understanding and adaptation of life cycle implementation of Data Warehouse.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT&Dimension Tables), OLTP and OLAP.
• Extensively worked on Oracle, Pl/SQL, T - SQL Stored Procedures and Functions and involved in Query Optimization.
• Hands-on writing complex SQL queries needed for ETL execution and analyzing the data loaded.
• Extensive usage of databases like Oracle 11x/10g/9i/8x, SQL server 2005/08/12, MSSQL, Flat files, COBOL and XML files.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.x/7.x (PowerCenter) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 11x/10g/9i/8i, MS SQL Server 2005/2008/2012

Languages: SQL, PL/SQL, C and Data Structures, Unix Shell Script

Web Technologies: HTML4/5, CSS 2/3, XML, Java Script, AJAX.

Tools: SQL plus, PL/SQL Developer, Toad

Operating Systems: Windows NT/2000/2003/XP/Vista/7, Win 8/8.1, UNIX and Linux

PROFESSIONAL EXPERIENCE:

Confidential, NewYork, NY

Informatica ETL Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 9.1 for extraction, loading and transformation (ETL) of data.
• Designed and developed ETL Mappingsto extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using InformaticaPowerCenter.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using workflow monitor.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Created test Developed cases and ran the queries for staging, ds and dm to all the environments before migrating the data to production and tested all themappings, sessions and workflows.
• Sending files to source directory & managing session files
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed SQL code at the database level for the new objects.

Environment: Informatica Power Center 9.5, Informatica Power Connect, (Repository Manger, Designer, Server Manager, Workflow Monitor, and Workflow Manager), RDBMS, Oracle 10g/11g, PL/SQL, Toad, UNIX scripting.

Confidential, Sunnyvale, CA

Informatica ETL Developer

Responsibilities:

• Worked with Business Users in requirements gathering and creating requirements Specification documents.
• Created Technical System Design documents, Low Level Design documents.
• Worked extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Worked on Informatica transformations such as Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected & Unconnected Lookup transformation, Sequence Generator, Transaction Control etc.
• Developed Informatica mappings/sessions/workflows - Extensively used Dynamic/Persistent Lookup cache techniques for minimizing the load window.
• Developed re-usable transformations, Mapplets following the Informatica best practices.
• Involved in designing ETL data load strategy for SCD type 2, Dimensions and Fact tables, ETL reject handling, ETL restart recovery logic.
• Extracted source data from Flat Files, XML, Oracle and a relational warehouse.
• Involved in client interaction, analyzing issues with the existing requirements, proposing solutions and implementing the same.
• Involved in performance tuning SQL and Informatica mappings/sessions by session partitioning techniques.
• Migrated Informatica objects (mappings/sessions/work lets/workflows) from the Dev to QA to Production Environments.
• Created Unit test case templates (standardized formats).
• Involved in doing the effort analysis for new work requests/enhancements.
• Interfacing with various Technology and Business groups.

Environment: Informatica Power Centre 9.1 Oracle 11g, TOAD, SQL Server 2008, UNIX, Windows, Erwin.

Confidential, Somerset, NJ

Informatica Developer

Responsibilities:

• Interacted with Business personnel to analyze the business requirements and transform the business requirements into technical requirements.
• Developed and supported the extraction, transformation and load process (ETL) for Data Warehouse from the source systems using Informatica.
• Created Reusable Transformation and Mapplets in the designer using transformation developer and Mapplet designer according to the business requirements.
• Wrote SQL overrides in source qualifiers for extracting only the required rows for optimal performance.
• Created complex transformations using Source Qualifier, Joiner, Aggregator, Lookup, Router, Expression, Update Strategy, Sequence Generator etc.
• Debugging code, testing and validated data after processes are run in development/testing according to business rules.
• Prepared unit test plans and maintained defect logs to resolve issues.
• Communicated with the Team to prepare unit test plans, to find solutions for the defects/issues and to share business knowledge.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, removed them and implemented performancetuning logic on targets, sources, mapping, sessions to provide maximum efficiency and performance.
• Used Workflow manager and Workflow monitor to create, run and monitor the sessions.
• Extensively used TOAD to check if data is properly loaded into target systems by writing SQL Queries.
• Tuned performance of Informatica sessions for large data files by implementing pipeline Partitioning and increasing block size, data cache size, sequence buffer length, and target based commit interval and resolved bottlenecks.

Environment: Informatica Power Center 8.1, Oracle 8i, SQL, TOAD, PL/SQL, Flat files, Sybase, Erwin Designer, Windows NT.

Confidential

SQL Developer

Responsibilities:

• Installing, configuring, administering and securing production servers.
• Setup new MS SQL Server instances and databases.
• Capacity planning of MS SQL Servers.
• Implement and maintain database security.
• Going through the clients' requirements and coming up with database design and application architecture.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Maintaining User account administration for Different domains.

Environment: SQL Server 7.0, Transact-SQL, Enterprise Manager, Query Analyzer, MS-ACCESS 2000.