PROFESSIONAL EXPERIENCE:

• 5+ years of overall experience in IT Industry with Data warehousing, OLAP reporting tools, ETL tools using industry best methodologies and procedures.
• Expert knowledge in working with Data Warehousing ETL using Informatica Power Center 10.x/9.x/8.x (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor) and Knowledge of Informatica Data Quality 10.x/9.x.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Enterprise Data Vault, SCD, Surrogate keys, Normalization/De normalization, Data marts.
• Experience in integration of various data sources with Relational Databases like Oracle, SQL Server, DB2 and Worked on integrating data from flat files.
• Experience in profiling data using Informatica Data Quality 9.5(Analyst tool).
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Mapping Designer, Transformation Developer, Mapplet Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Shortcuts, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files..
• Strong working experience in Informatica Data Quality (IDQ) 9.5 with Informatica Developer tool, Informatica Analyst Tool.
• Extensive experience in error handling and problem fixing using Informatica.
• Demonstrated experience implementing Informatica Data Quality as a service in SOA or Web Services architecture.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations, Partioning Sessions.
• Experience in troubleshooting by tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings, and session.
• Involved in Implementing Slowly Changing Dimensions, Star Schema modeling, Snowflake modeling, FACT tables, Dimension tables, De normalization.
• Enhancing the existing mappings, workflows with new business requirements and replaced existing Java ETLs with Informatica workflows. Report the project status to the management.
• Experience in Oracle9i/10g/11g, SQL Server, Teradata, and DB2 etc.
• Extensive Experience in UNIX (AIX/Solaris/ HP-UX 11.x), and Windows Operating system.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, and Packages.
• Developed excellent overall software Development life cycle (SDLC) professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts. Collaborated onsite teams, interacted and well managed various offshore teams.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.6.1/9.1/8. x, Informatica Power Exchange 9.5.1, Informatica Data Quality 9.5(Developer, Analyst)

Databases: Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008, Teradata, DB2.

Languages: SQL, T-SQL, PL/SQL, UNIX Shell Scripting, Windows Batch Scripting.

Operating Systems: UNIX, Windows 2000/2003/NT/XP, Linux, Sun Solaris, HP-UNIX, IBM AIX.

Business Intelligence Tools: COGNOS, Business Objects (BO).

DB Tools: TOAD, SQL * Plus, PL/SQL Developer, SQL * Loader, Fast Load. M Load

Web Technologies: HTML, XML

Data Modeling Tools: Erwin, Embcadero Studio

Other Tools: HP Quality center, WIN SCP, JIRA, MS-Office, Autosys, Tidal.

WORK EXPERIENCE:

Confidential, Santa Monica, CA

ETL Developer

Responsibilities:

• Design, develop, maintain, monitor and execute production ETL processes using Informatica Power Center and Informatica data quality.
• Extensively used Informatica Power Center to extract data from various sources and load in to staging database
• Investigate production ETL issues / problems.
• Verify and validate ETL deliverables.
• Lead troubleshooting episodes and communicate solutions/resolutions to the team
• Translate concepts to requirements, and development into an automated production process.
• Act as a subject matter expert and resource for others on assigned ETL processes.
• Complete projects and development activities timely and accurately while following the System Development Life Cycle ( SDLC ).
• Suggest changes and enhancements for ETL processes.
• Worked with various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Helped the team in analyzing the data to be able to identify the data quality issues.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Document hours and development activities by following SDLC and IS Change Management guidelines
• Scheduled Informatica workflows using power center Scheduler
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart
• Involved in debugging mappings, recovering sessions and developing error-handling methods
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager
• Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance as the volume of the data was heavy.
• Tuned performance of Informatica session for large Data Files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Worked on SQL tools like TOAD to run SQL queries and validate the data
• Used Unix Shell Scripts to automate pre-session and post-session processes
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Developed complex reports that involved multiple data providers, master/detail charts, complex variables and calculation contexts.

Environment: Informatica Power Center 10.1/9.0, Informatica Power Exchange 10.1/9.0, Oracle 11g, MS SQL Server 2012, SQL, PL/SQL, T-SQL, SQL*Plus, TOAD, windows 7, Sybase, Unix

Confidential, Durham, NC

Informatica Developer

Responsibilities:

• Conducted JAD sessions with business users and SME's for better understanding of the reporting requirements.
• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents.
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Handled technical and functional call across the teams.
• Responsible for the Extraction, Transformation and Loading (ETL) Architecture & Standards implementation.
• Responsible for offshore Code delivery and review process
• Used Informatica to extract data from DB2, UDB, XML, Flat files and Excel files to load the data into the Warehouse.
• Worked in all phases of Data Integration from heterogeneous sources, legacy systems to Target Database.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager, Informatica Workflow Manager and Workflow Monitor.
• Designed and developed complex Type 1 and Type 2 mappings for the stage to integration layer in the project.
• Involved in Design Review, code review, test review, and gave valuable suggestions.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created partitions for parallel processing of data and also worked with DBAs to enhance the data load during production.
• Performance tuned Informatica session, for large data files by increasing block size, data cache size, and target based commit.
• Worked on Confidential (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Involved in writing a procedure to check the up-to-date statistics on tables.
• Used Informatica command task to transfer the files to bridge server to send the file to third party vendor.
• Took part in migration of jobs from UIT to SIT and to UAT.
• Created FTP scripts and Conversion scripts to convert data into flat files to be used for Informatica sessions.
• Involved in Informatica Code Migration across various Environments.
• Performed troubleshooting on th e load failure cases , including database problems.

Environment: Informatica Power Center 9.1, Oracle 11g, MS SQL Server 2008, HP Quality Control.

Confidential, SFO, CA

ETL Developer

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer.
• Analyze the raw data from alliance partners and perform coding to generate the reports according to the Data model.
• Working with the application users to understand their requirements, analyzing the requirement, documenting and getting sign off for the development team to start with the development effort.
• Responsible for determining the bottlenecks with Informatica Server and fixing the issues by cleaning the Informatica repository logs on timely basis.
• Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Developed mappings in informatica to load data into Marts and different other layers like Persistent Staging and Data Warehouse.
• Coordinate production change requests and production releases.
• Troubleshooting load failure issues and data quality issues on a day to day basis.
• Maintain the daily ETL schedule and recover the daily failures and generate the daily reports for users.
• Used Informatica Debugger to troubleshoot data and error conditions.
• Maintain documents for all the Development work done and error fixings performed.
• Involved in deploying and redesigning of several small ETL processes for the existing research line of business.
• Involved in developing reports using Business Objects.
• Migrated ETL code across different ETL environments like Dev, QA, UAT, PROD.
• Used tools like TOAD and SQL navigator to run the queries and validate the data.
• Responsible to Run Unix scripts to startup the Java Web Service to generate the Load confirmation emails to users.

Environment: Informatica Power Center 8.6/9.1, oracle 9i, 11g PL/SQL, TOAD, Informatica Data Quality, UNIX, Erwin 4.2/7.x,Windows XP Professional, FTP, MS-Excel, MS-Access, Maestro.

Confidential

Oracle/ETL Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using Informatica into the database. Involved in Logical and Physical modeling of the drugs database.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files, XML Files to target Oracle Data Warehouse database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Informatica Power Center 7.1, Oracle 8i, XML, SQL, PL/SQL, UNIX.