SUMMARY:

• Around 8 years of IT industry experience with extensive knowledge in Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica Power center 9.5/9.1.1/8.6/8.1/7.1.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Extensively used Informatica Power Center/Power Mart (9.x/8.x/ 7.1.4/7.1/ 6.2/6.1/5.1 ) for ETL (Extraction, Transformation and Loading) of data from multiple source systems into Data Warehouse.
• Extensive experience with relational databases (Sybase 15.x, Oracle 8i/9i/10g, Teradata v2 R6, SQL Server 2000/2005).
• Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor),Web services and security configuration in Informatica server (end - to-end)
• Understanding & Working knowledge of Informatica CDC (Change Data Capture).
• Helped team members resolving any issue related to coding, testing, performance tuning in developing Informatica mappings and workflowsfor the existing code.
• Proficient in designing and developing complex standard and re-usable mappings and mapplets using various transformation logics by utilizing the expression, filter, joiner, lookup, router, rank, normalizer, aggregator.
• Expertise in unit testing at various levels of the ETL as well as SQL, UNIX etc. Good exposure in Informatica MDM where data Cleansing, De-Duping and Address correction were performed.
• Expertise in unit testing at various levels of the ETL as well as SQL, UNIX etc.
• Good understanding on the concepts of Dimensional Data modeling, Star Schema/Snowflake Schema, modeling, FACT & Dimensions tables, Physical & logical data.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008 and Oracle.
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Experience in performance tuning of Informatica code and.
• Experienced with Informatica Power Exchange (8.x/9.x) for Loading/Retrieving data from mainframe systems.
• Good experience with configuring Data Warehouse Administration Console (DAC) for creating execution plans, metadata management and monitoring the Informatica ETL Process.
• Configured and registered the custom workflows in DAC.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.
• Worked with Business Users to identify information needs as per the business requirement
• Experience working with Onside-Offshore model.

SKILL SET:

ETL Tools: Informatica Power Center 9.1/8.6.1.1/7.1.2/6.2/6.1/5.1 , Power Mart 5.0/4.7

Operating Systems: Windows XP/2000/NT/98/95, Windows 2003 server, Unix, MSDOS

RDBMS: Oracle 11g,10g/9i/8i/8.0, MS-SQL Server 2005/2000/7.0/6.5

Data Modeling: Erwin 4.1.4/3.5.2

Data Base Tools: SQL Loader, Toad 4.0.3, MS Visio, MS Access

Reporting Tools: Business Objects XI/6.x/5.x, OBIEE 10.x/9.x; Power play and Transformer.

Scripting: UNIX Shell Scripting

Web Technology: Web Technology HTML, Java script

Languages: SQL, PL/SQL, C, C ++, Java 1.2, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Snr. Informatica/ETL Developer

Responsibilities:

• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Worked with Informatica Power Centre 10.1, Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Developed technical specifications of the ETL process flow.
• Extensively used ETL to load data from Flat files, PeopleSoft, DB2 and Oracle into Oracle.
• Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Created variables and parameters files for the mapping and session so that it can migrate easily in different environment and database.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Used reusable Session for different level of workflows.
• Designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait and so on.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks andimplemented pipeline partitioning.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Involved in exporting database, table spaces, and tables using Data pump (10g) as well as traditional export/import (until 9i).
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Used Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server.
• Implemented error-processing strategy to reprocess the error data and manage notification of error data to corresponding business team.
• Worked with Informatica workflow monitor in running and debugging its components and monitoring the resulting executable version
• Involved in unit testing and documentation of the ETL process.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Daily monitoring of the mappings that ran the day before and fixing the issues.

Environment :Informatica Power Center 10.1,9.5, Work Flow Manager/Monitor, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL, TOAD, SQL * Loader, UNIX /LINUX Shell Scripting, PeopleSoft, Microsoft SQL Server 2012, IDQ 8.6.1 , OBIEE.

Confidential, Newark, NJ

Sr. ETL Developer/Data Analyst

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Design, configuration of Informatica webservices to automate the EID requests using web services consumer transformation.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Performed data analysis anddata profilingusing complex SQL on various sources systems including Oracle.
• Resolved Inconsistent and Duplicate Data to Support Strategic Goals with Multidomain MDM
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Involved in extensive DATAvalidation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades. Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment :Informatica Power Center 9.5, Work Flow Manager/Monitor, MDM, Data Stage, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL, TOAD, SQL * Loader, UNIX /LINUX Shell Scripting, DB2, Microsoft SQL Server 2012, XML,Tivoli Scheduling Tool, IDQ, OBIEE.

Confidential, Chantilly, VA

Informatica Developer

Responsibilities:

• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Create functional requirements documentation and data flow diagrams to assist in the analysis of a process.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/ Workflows.
• Performed Data Analysisand Data validation by writing complex SQL queries using TOAD against the ORACLE database
• Created reusable transformations and mapplets and used them in mappings.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Created shell scripts to kick off Informatica workflow/s and PL/SQL procedures.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Extensively used UNIX scripts for automation of ETL process.
• Extensively worked on tuning mappings and reducing processing times.
• Worked with DBA to identify source and target bottle necks.
• Cleansed the data using MDM Technique.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Involved in production support for the data warehouse Informatica jobs.
• Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica Power Center 9.5, Sybase 15.x, CA Scheduling, DBArtisian 9.0, YART1.0, MS Visio, MS Project,UNIX /LINUX Shell Scripting, PERL,MDM, Tortoise SVN, Putty, Toad, OBIEE.

Confidential, Virginia Beach, VA

ETL Informatica Developer

Responsibilities:

• Interacting with Business Analysts to understand the requirements
• Analyzing the requirements and preparing design.
• Involved in ETL designing and coding. Extensively used ETL to load data from Oracle database, SQL server, and Flat files to Teradata Data Warehouse.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Involved in production support for the Data Warehouse Informatica jobs.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Created robust and complex workflow and Worklets using Informatica Workflow Manager and troubleshot data load problems
• Wrote SQL Queries, Triggers 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 Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Developed Mappings to extract data from ODS to Data Mart, and monitored Daily, Weekly and Monthly Loads.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing
• Developed some scripts to take weekly backups of certain tables using korn shell and import/export utilities.
• Worked on tuning some individual mappings and oracle queries that causing performance bottlenecks.
• Written documentation to describe program development, logic, coding, testing and changes made.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Worked with mapping variables, Mapping parameters and variable functions like set variable, Count Variable, Setminvariable and Setmaxvariable.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.

Environment: Informatica Power Center 9.5/9.1, Teradata 13 1, SQLServer 2005, Tidal, Mercury Quality Centre 10.1, DAC, PL/SQL, OBIEE 10g, Toad, UNIX Shell Scripts.

Confidential, Deerfield, IL

Informatica Developer

Responsibilities:

• Designed and developed slowly changing dimensional model for reference tables.
• Extensively used ETL to load data from sequel server database, Flat files to Data Warehouse
• Used Informatica Power Connect to directly source and integrate enterprise data.
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformations to pipeline data to Data Warehouse/Data Marts.
• Modified the existing mappings and workflow as per requirement changes and migrated them back to production environment
• Created robust and complex workflow and worklets using Informatica workflow manager and troubleshooting data load problems.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively worked in the performance tuning of programs.
• Pmcmd commands of Informatica in UNIX scripts.
• Designed and developed a process to load Historical data.
• Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production environment using tools like Computer Associate Harvest package.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Involved in different Team review meetings.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Communication with the client for weekly status report.

Environment: Informatica PowerCenter8.1, SQL server 2005, Autosys, Oracle 10g, PL/SQL, Toad, Business Objects 6.0, Windows NT, UNIX Shell Scripts.

Confidential, Gainesville, Florida‎

ETL Analyst

Responsibilities:

• Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
• Involved in production support for the data warehouse Informatica jobs.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Automated Reports and generated documents using Scheduler.
• Created robust and complex workflow and work let's using Informatica workflow manager and troubleshoot data load problems.
• Wrote SQL Queries, Triggers 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 Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
• Developed Mappings that extract data form ODS to Data mart and Monitored the Daily, Weekly and Monthly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.

Environment: Informatica Power Center 7.1.2, Oracle 9i, PL/SQL, Toad, OBIEE, DAC, Windows NT, UNIX Shell Scripts.