SUMMARY

• Professional work experience of around 8+ years in the field of ETL DataWarehousing, Data Integration and Data/code Migration.
• Around 6+ years of extensive experience with Informatica Powercenter 9.0.1/8x
• Experience in all the phases of Data Warehouse life cycle involving Requirement analysis, Design, Coding, Testing and Deployment.
• 2 year experience as SQL Developer with good knowledge of SQL, PL/SQL.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer, Workflow Manager, Repository Manger, Workflow Monitor.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center.
• Developed complex mappings in Informatica to load data from various sources into the Data Warehouse, using various transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
• Experience in performing ETL procedures to load data from different sources like Oracle 9i/10g, DB2, XML Files, Flat Files, Mainframes, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Worked on flatfiles both of delimited and fixed length.
• Experience usingOracle Business Intelligence Enterprise Edition (OBIEE) 11g and Oracle BI Apps.
• Proficient in performance tuning of Informatica Mappings, Transformations, and Sessions; experienced optimizing query performance.
• Experience in working with data normalization (OLAP and OLTP) .
• Experience in Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse
• Extensive experience on working with scheduling tools like SAS Management console, Crontab, Autosys, Tivoli and lsfadmin tools.
• Experience in Java scripts, UNIX Operating System and Shell scripting.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema).
• Used designer debugger to test the data flow and fix the mappings.
• Profound Experience in Project Environment setup such as Installation, configuration and Administration of Informatica products Client/Server environment.
• Excellent written and oral communication, interpersonal skills and presentation skills.
• Experience in working with senior level managers, business people and developers across multiple disciplines.
• Quick learner and excellent team player, ability to meet deadlines.

TECHNICAL SKILLS

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

Data Modeling: Relational Modelling, Dimensional Modelling Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams.

Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access, Teradata and DB2

Languages: SQL, PL/SQL, C, C++, Data Structures, UNIX Shell Script, Visual Basic

Web Technologies: HTML, XML, Java Script

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader

Job Scheduling Tools: Autosys, Control M, Tivoli

Operating Systems: Windows NT/2000/2003/XP/Vista/7, UNIX, MS-DOS

Others: OBIEE,IDQ, MDM, DB2, B2B.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, Nebraska

Sr. Informatica Developer

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load in Oracle warehouse.
• Understanding the business administration rules provided to design and develop mapping for the ETL.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Designed Sources to Targets mappings from Excel/Flat files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Informatica admin for project coordination.
• Estimated the Database space needed based on the data volume and the data structures.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Datasets.
• Developed complex ETL to dynamically build queries based on the rules provided by the end user.
• Used Informatica features to implement Type II changes in slowly changing dimension (SCD) tables.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings coding with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues, Troubleshootingof Informatica Mappings, evaluating current logic for tuning possibilities.
• Extensively worked on SQL queries along with Informatica to enhance the performance of the system.
• Used Autosys for job scheduling.
• Involved in Data masking for unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Responsible for creating production support documentation.
• Coordinate with business team, get the requirements from them and then coordinate with offshore team to get the work done, keeping timeline in mind.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, UNIX Shell Scripts, Autosys, TOAD, windows XP.

Confidential, Miami Lakes, Florida

ETL Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs.
• Developed various Mappings, Mapplet and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target.
• Developed standard and re-usable mappings and Mapplets using various transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
• Worked with different caches in optimizing the transformations such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Development and deployment of various Informatica mappings in different Environments.
• Created different source definitions to extract data from Oracle, flat files, XML files and relational tables for Informatica Power Center.
• UsedInformatica Power Exchangefor loading/retrieving data frommainframe system.
• Experience usingOracle Business Intelligence Enterprise Edition (OBIEE) 10g and Oracle BI Apps.
• Data Modeling done with Multidimensional Architecture.
• Good knowledge of Backups, Partitioning of Database.
• Created and managed the global and local repositories and permissions using Repository Manager.
• Created variety of interactive dashboards containingcharts,graphsandpivot tablesusing BI Answers.
• Responsible for data migration from Development to Testing and to Production.
• Development of pre-session, post-session routines and batch execution routines using server to run Informatica sessions.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Documentation for ETL development process, Installation and troubleshooting guide.

Environment: Informatica-Power Center 9.5.1, Informatica Data Quality (IDQ), (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Oracle 11g, Toad, Java, Netbeans, Erwin 7, MS Visio, Windows, Autosys.

Confidential, Springfield, MA

Informatica Developer

Responsibilities:

• Design and development ofReports,Dashboards,Analytics,ETL,andBusiness Intelligence (BI) solutionsusingBusiness Objects (BO XI),Cognos,Informatica ETL,SQL, PL/SQL,Oracle.
• Interacted with different business teams to gatherrequirements forreporting and analysis.
• Worked withInformaticaData 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.
• Processed the flow of data from source system to data warehouse and used Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer for defining Source and Target definitions.
• Developed Type2 &Type3 slowly changing dimension mapping in various project requirements.
• Developed complex mappings using transformations like Lookup, Union, Normalizer, Update strategy, Expression, Filter, Aggregator, Joiner, Router, Rank and Sequence generator etc.
• Prepared automated job scheduling process with Cron tab and Autosys scheduler.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Involved in the movement of data from the Oracle system to the final warehouse in Teradata, using Informatica and the Multiload loader connections.
• Developed override SQL statements in Source Qualifier and Lookups to suit extraction of desired data from desired region.
• Created mapping parameters and variables in Informatica to handle the incremental date logic using parameter file to connect to various environments with ease of change.
• Identified the bottleneck and fine-tuned Source, Targets, Mappings, Transformations and sessions for better performance.
• Developed data access queries and uses OBIEE tools like Answers, builds dashboardsand help indevelopment of complex ad hoc queries and analyses
• Maintenance and modification of existing reports as well as creation of new reports.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Interact with OBIEE Analyst to assist him in Understanding the Source and Target System.
• Supported unit and integration testing for the Informatica mappings and Warehouse data against the business requirements and prepared the Technical design documents and unit test case documents.
• Utilized InformaticaIDQ 8.6.1to complete initialdata profiling and matching/removing duplicate data.
• Involved in on call support to resolve the production issues during the implementations.
• The project is more inclined towards data warehousing and we provide data to the BI team.
• Managed and coordinated with onshore/offshore teams.
• Worked closely with reporting team and helped them whenever they had any ETL issues.

Environment: Informatica Power Center 9.1, Teradata, Oracle 11g, PL/SQL, SQLServer 2008, UNIX Shell Scripts, Control-M, Siebel 8.1, TOAD, windows XP, Linux, Erwin.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Involved in creating new mappings and changing in existing mappings as per the new business rules.
• Coordinated the offshore team for sharing work and knowledge transfer.
• Attended business meetings and involved in requirement gathering.
• Analyzed business information requirements.
• Used Source Qualifier, Expression, Filter, Lookup, aggregate, Update Strategy, Router, Sequence generator and Joiner Transformations for creation of mappings.
• Created unit test cased and did unit testing for the mappings.
• Created sessions and workflows for the mappings.
• Worked for ETL QA testing.
• Documented the mapping process and methodology used to facilitate future development.
• Extensively interacted with user and involved in various documents preparation like Integration test plan, Unit test plan, Deployment Instructions, Roll Back Plans, and Production Move Check lists etc.
• Modifying the queries for performance improvement.
• Tuning mappings for performance improvement in informatica.
• Involved in running the loads to the data warehouse involving different environments.

Environment: Informatica Power Center 8.6, Oracle, Flat files, Shell.

Confidential, North Brook, IL

ETL Informatica Developer

Responsibilities:

• Involved from initial stage of the requirement gathering to understand business requirements subjected to business.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Designed, developed, implemented and maintainedInformaticaPowerCenter and IDQ 8.6.1 application for matching and merging process.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Developed complex ETL Programs using Mapplet Designer, Mapping Designer, Target Designer and Transformation Developer, Repository Manager and Workflow Manager.
• Created new mappings and also modifications in already existing mappings as per the new business rules.
• Used different transformations such as Expression, Source Qualifier, Lookup, Filter, Update Strategy, aggregate, Router, Sequence generator and Joiner in order to create mappings.
• Created sessions and Workflows for the mappings.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Extensively used the debugger and analyzed log files, loader logs to test the data.
• Documented the mapping process and the process that can be used in order to facilitate future development.
• Interacted with user for his requirements and also involved in various document preparation such as integration test plan, Unit test plan, Deployment Instructions, Roll Back Plans and Production Move Check lists etc.
• Modifying the queries for performance improvement.
• Involved in running the loads to the data warehouse involving different environments.

Environment: Informatica 8.1, Oracle 9i, SQL Server 2005, Flat Files, IBM DB2 8.1, UNIX, ERwin.

Confidential

SQL, PL/SQL Developer

Responsibilities:

• Worked on analysis, design, development, testing and implantation of the various financial systems using Oracle 8i, Developer 2000.
• Coordinated between management, users and technical teams for Requirement Gathering.
• This system consists of the various functional modules: Loan approvals, Deposition of Cash/ Withdrawal of Cash, Change of personnel Information, Bank Details, balance Sheet, Customer Information Database.
• Defined the database structure, mapping and transformation logic. And also creation of External Table scripts for loading the data from source for ETL jobs.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Worked with different functional experts in order to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Involved in daily, weekly and monthly load of data from mainframe data set to Oracle database.
• Used SQL *Loader to load the data.
• Generated UNIX shell scripts for automating daily load processes.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Developed Shell Scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Used TOAD and SQL navigator extensively.

Environment: Oracle 8i, SQL, PL/SQL Developer, TOAD 8.0, UNIX Shell Scripting, MS SQL Server 2000, Windows 2000.