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.
• 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.