SUMMARY

• IT Professional with 8 years of Experience in the Business Requirements Analysis, Application Design, Data Warehousing, Development, Implementations and Testing of software systems in various verticals such as Financial, Retail, Insurance industries.
• 7+ years of strong experience in Data Warehousing and ETL using Informatica Power Center 9.6/9.51/9.0.1/8. x/7.x/6.1,Oracle 11g/10g/9i, Taradata 13/12/V2R6 and Erwin.
• 3 years of experience on real - time data Warehouse development using CDC tool Informatica Power Exchange 9.1/8.6/8.1.
• Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica. Understands complex mappings transformation rules, data formats and efficient in performance tuning of sources, mappings, targets and sessions.
• Experience inPower Exchangeto connect and import sources from external systems like SAP R/3, DB2, Salesforce, Mainframes, and AS/400.
• Designed and developed mappings, from varied transformation logic likeUnconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure, Update Strategy,SCD's Type1, Type2 and Type3.
• Expertise in using Informatica client tools - Designer, Repository, Manager, Repository Server, Administration Console, Workflow Manager, and Workflow Monitor.
• Knowledge of Informatica administration in windows and Linux environment
• Proven experience atbuilding, motivatingandleading professional teams,managing projects and supportingclient relationships.
• Knowledge of tools such asErwin and MS Visio Professional.
• Experienced with Multiple Databases includingOracle 11g/10g/9i, Teradata13/12, MS SQL Server 2008/2000 and DB2.
• Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
• Worked on Oracle Procedure, Function, Package and Trigger.
• Worked on Teradata utilities BTEQ, FLOAD, FEXPORT, MLOAD and TPUMP.
• Developedtest case’sfor business and user requirements to performSystem/ Integration / Performancetesting.
• Experience onDebuggerto validate the mappings and gain troubleshooting information about data and error conditions.
• Expertise inPerformance Tuningof overall data warehouse, database, ETL and OLAP tuning coordinating with DBAs and UNIX Administrator for better performance.
• Confident self-starter, independent worker and team player.
• Data Profiling- used IDQ for data profiling, mapping.
• Used Informatica Analyst to generate data profiling report.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8.6/8.1/7.1 , Informatica PowerExchange 9.1/8.6

Databases: Oracle 11g/10g/9i, DB 2 8.0/7.0/6.0 , Teradata 13/12, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/97/2000

Other Tools: Oracle Report Writer, MLOAD, TPUMP, BTEQ, FLOAD, SAS, SQR 3.0, Erwin 4.x/3.5/3.x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer

Languages: SQL, UNIX Shell Scripting, Unix Commands, XPath, XSLT

Operating Systems: Windows Server 2008/2003, UNIX, Sun Solaris 2.x.

Scheduler& Reporting Tools: ESP, Autosys, OBIEE 11g, Cognos 7

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. ETL / Informatica Developer

Responsibilities:

• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Data profiling use IDQ developer and Informatica analyst before start mapping notice client and SME about data quality .
• Interaction with the Business Partners to understand the business of the application, gather requirements, analyzed and put into technical design documents (HLD & LLD).
• As an active team member, involved in the initial phases of the design and was taken part in the analysis of the product.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in the creation of oracle Tables, Table Partitions, Materialized views and Indexes and PL/SQL stored procedures, functions, triggers and packages.
• Working with various sources such as Flatfiles, Relational, XML and Webservices as part of Informatica Mappings.
• Worked with Mapping and Workflow variables by using the value of mapping variables on the workflow level.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings
• Responsible to tune ETL mappings to optimize load and query Performance
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run the workflows to create the Front End screen insert activities.

Environment: Informatica Power Center 9.6.1 (Designer, Repository Manager, Workflow Manager), Oracle 9i, Oracle 11g,, TOAD, SQL Developer, UNIX Shell Scripts, Microsoft Visio 2007, Adminserver, UNIX, Windows 2000/NT

Confidential, Austin Tx

ETL / Informatica Developer

Responsibilities:

• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Data profiling use IDQ developer and Informatica analyst before start mapping notice client and SME about data quality
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Developed custom data transformation (structured/unstructured data) process using Item field content master data transformation tool.
• Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Developed PL/SQL stored procedures for Informatica mappings.
• Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for management reporting.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.s
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Providing technical support and troubleshooting issues for business users.
• Actively Participated in problem solving and troubleshooting for the applications implemented with Informatica.
• Used Workflows Manager to create the Sessions to transport the data to target warehouse.

Environment: Informatica PowerCenter 9.6.1, Power Exchange 9.6.1, Erwin 4.1, EDI, Autosys r11.0 oracle 9i, PL/SQL, Teradata 12, SQL,, XML, SQL Server 2005, Windows 2003, Unix.

Confidential, Richmond VA

Sr. Informatica Developer/Support Analyst

Responsibilities:

• Responsible for gathering the requirements both functional and technical and documentation of the same and creating the mapping documentation, leading the team, preparing various standard template,
• Worked with the business analysts in requirement analysis to implement the ETL process
• Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables.
• Requirement gathering and analysis with business users and onsite subject matter experts
• Extensively worked with OLTP and Record creation/management systems in data extraction, manipulation and masking in/out of record management systems.
• Loaded data into various star schema data warehouse dimension and fact tables.
• Responsible for gathering functional specifications and converting it into mapping documents.
• Handled Performance tuning by increasing buffer block size, creating various Named-Caches for Connected and un-Connected lookups, error handling.
• Created re-runnable SQL scripts to create tables, triggers, indexes, views, packages and procedures.
• Responsible for data conversion from SQL Server to Oracle 10g.
• Responsible for working with DBAs for DDL Changes in Oracle 10g and 11g (Tables/Views/Stored Procs/Packages/Functions/Triggers).
• Planned/participated in DR exercises, application risk management planning and effective backup and recovery planning for applications.
• Extensively participated in various testing like, Development Unit Testing, Integration testing, User Acceptance testing and regression & performance testing.
• Smooth coordination, managed team meetings, transition between customer to the current support team and among the onsite-offshore teams.
• Coordinate for Connectivity all access related activities queue, server, tools, and net-work issues during the initial engagement set up.
• Full time production environment support and maintenance for the retail operations.
• Regular maintenance activities & provide 24*7 support.
• Worked on Various Teradata utilities like FLOAD,MLOAD and TPump.
• Bringing up the same level of knowledge shared among resources
• Managing the customer communication and escalations
• Up to date technical documents Runbook and service overview document SOD
• Resource management and updating customer on timely basis.
• Managing other prod adhoc issues and supporting the production system.
• Coordinate Onsite and offshore team, managing various calls related to requirements, development, testing and migration.

Environment: InformaticaPowerCenter 9.5/9.1, InformaticaPowerExchange 9.1, Oracle Exadata, MSSQL Server 2008 R2, T-SQL, ERWin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Tidal, Shell Scripting, Perl Scripting, Windows XP, Putty, DB2 Mainframe, OBIEE 11g, Teradata 13/12.

Confidential, Tampa FL

Sr Informatica Developer/Data Analyst

Responsibilities:

• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id's, and translation rules.
• Evaluation of data groups and data critically and developed automated conversion process.
• Stored Procedures for parsing data required for mapping in Sale Force.
• Worked with the business analysts in requirement analysis to implement the ETL process
• Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables.
• Coordinate for Connectivity all access related activities queue, server, tools, and net-work issues during the initial engagement set up.
• Wrote shell script to run ETL job by scheduler tool, ftp scripts, logs cleanup script.
• Extensively worked with various Active transformation like Filter, Sorter, Aggregator, Router, and Joiner transformations.
• Involved in Informatica and Oracle up gradation from version 8.6 to 9.1.
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Experience in working with Access management, Sales, Order management and fulfilling system of publishing company.
• Documented all old and migrated Store Procedures and scripts for future references.
• Different kind of Pivot table reports generation for easy access for the users for their immediate requirement.
• Managing all Development, staging, upgrade and Production environment SQL Servers and keeping data in Sync which is managing data quality.
• Handling Database backup schedule.
• Created various DDL, DML and designed materialized views.
• To handle smooth Knowledge transition between customer to the current support team and among the onsite-offshore teams.

Environment: InformaticaPowerCenter9.1/8.6.1, InformaticaPowerExchange 9.1/8.6.1, Oracle 11g, MSSQL Server 2008 R2, T-SQL, ERWin 7.1, SQL Server, TOAD, PL/SQL Developer, Windows XP, Visual Basic 6, .Net, SQL Server 2005&2008, SSIS, SSMS, Sybase 12, Windows xp, Sun Solaris, Harvest.

Confidential

Informatica Developer

Responsibilities:

• Involved in creation of Logical Data Model for ETL mapping and the process flow diagrams.
• Worked with SQL developer to write the SQL code for data manipulation.
• Worked on Informatica versioned repository with check in and checkout objects feature.
• Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Provided guidance to less experienced personnel. Conducted quality assurance activities such as peer reviews.
• Participate in the business analysis process and the development of ETL requirements specifications.
• Worked with production support systems that required immediate support
• Develop, execute and maintain appropriate ETL development best practices and procedures.
• Assisted in the development of test plans for assigned projects.
• Monitor and tune ETL processes for performance improvements; identify, research, and resolve data warehouse load issues.
• Involved in unit testing of the mapping and SQL code.
• Developed mappings to load data in slowly changing dimensions.
• Involved in performance tuning of source & target, mappings, sessions and workflows.
• Worked with connected, unconnected lookups and reusable transformations and mapplets.
• Utilized Unix Shell Scripts for adding the header to the flat file targets.
• Involved in designing the star schema and populating the fact table and associated dimension tables.

Environment: Oracle 10g, SQL Developer, SQL, Informatica Power Center 8.1,Sybase, Windows XP, Visio 2000, Business objects XIR2, Linux.