PROFESSIONAL SUMMARY:

• Over 8 years of experience in Data Modeling, Data design at various levels and functions in data ware housing development, testing and production. Experience in complete data warehousing application and client - server based business applications.
• Expertise in Data Warehousing ETL using Informatica Power Center-9.x/8.x, Informatica IDQ and Informatica Power Exchange.
• Experience in the Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas and Snow flake Schemas.
• Hands on experience through complete Software Development Life Cycle (SDLC) using Waterfall as well as agile processes.
• Experienced in handling SCDs (Slowly Changing Dimensions) i.e. Type I, II, III Tables .
• Experience in Dimensional Modeling, Star Schemas, Physical and Logical Data Modeling
• Database experience using Oracle 11g/10g, SQL Server, DB2 and Sales force Database.
• Well versed with ETL procedures to load data from different sources (Oracle, SQL Server, and DB2), File formats (flat files, .csv, COBOL, and XML) into DWH using Informatica Power Center tools.
• Worked on supported Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate the tables in Data warehouse and Data marts.
• Experience in working with all Informatica modules like Designer, Workflow manager, Workflow monitor and Repository manager.
• Extensive experience in using Transformations (Source Qualifier, Aggregator, Filter, Router, Update Strategy, Rank, Joiner, Expression, Sequence Generator, Normalizer, Store Procedure, Lookup, Sorter, and Union).
• Experience in writing UNIX Shell Scripting for file processing and automating the jobs.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Good experience in using Informatica Scheduler, CA Autosys and Control-M.
• Configure an FTP connection to use SSH File Transfer Protocol (SFTP) while connecting to an SFTP server. SFTP enables file transfer over a secure data stream. The Integration Service creates an SSH2 transport layer that enables a secure connection and access to the files on an SFTP server.
• Analytical and Technical aptitude with ability to work in a fast paced, challenging environment and keen to learn new technologies.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS:

Tools: Informatica Power Center 9.x/8.xInformatica Data Quality(IDQ)Informatica Power Exchange

Databases: Oracle 11g/10g/9i, DB2, MS SQL Server, Sales-force.

Database Tools: TOAD, SQL Developer, SQL Plus, IBM Data Studio, SQL Server.

Languages: SQL, PL/SQL,C, Shell Scripting.

Operating System: Susse Linux, Red Hat Linux, UNIX (Solaris, AIX).

Office Applications: MS: Office 97/2000/XP/2007, Open Office Suites.

Scheduler: Informatica Scheduler, Control M,CA Autosys

BI Tools: Cognos 10.x,Tableau 9.x

WORK EXPERIENCE:

Confidential, Delaware

Senior ETL Developer

Responsibilities:

• Interacted with business users for requirement analysis and to define business and functional specifications.
• Prepared software requirement specifications, business rules interacting with business units and designed star and snow flake schema, logical and physical database design.
• Creating Info Sources for master and transaction data.
• Creating source system in BW and attaching Info Sources to this Source System.
• Transformed the data via standardization, cleansing, data repair, matching, and deduping.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Enterprise Data warehouse (EDW).
• Used Java transformation to convert the data from one row into multiple rows based on the # separator values in an attribute.
• Developed data Mappings, Transformations between source systems and warehouse.
• Performed code reviews for the mappings developed by other team members.
• Prepared POC for migrating data from one table to another table in Oracle using generic mapping.
• Creating Informatica labels and ITSM tickets for migrating the code from Development to UAT to Prod environments.
• Involved in migrations between different environments and validations.
• Used HTTP transformation to get the currency data to support currency conversions in reporting.
• Creating UNIX and Informatica workflow jobs in Ctrl-M for scheduling.
• Removed duplicate rows from tables through the process of deducing.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Designed error handling method to capture the errors based on the business logic on source data.

Environment: Informatica Power Centre 9.1, Oracle, Ctrl-M, UNIX

Confidential, MI

Informatica Developer

Responsibilities:

• Participated in requirement gathering meetings with business analysts and ETL architect to understand source and data warehouse data model, technical metadata.
• Expertise in ETL techniques using Informatica Power Center 9.x, Oracle PL/SQL Stored Procedures to Extract and Transform data from various data sources and Load to the Transactional/Dimensional Databases..
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Created reusable mapplets, sessions and worklets and used them in workflows.
• Developed Informatica mappings and mapplets, between sources and operational staging targets, and fine-tuned some of them for better performance
• Used Transformations (Source Qualifier, Aggregator, Filter, Router, Update Strategy, Rank, Joiner, Expression, Sequence Generator, Normalizer, Store Procedure, Lookup, Sorter, and Union).
• Conducted Code Review sessions with Business SME’s and QE team.
• Used Informatica Scheduler and Control-M for Scheduling the workflows and Sessions.
• Data extract from DB2 Source Mainframe systems and load into Target Sales force Database.
• Developed Data Initial Pop Mappings, Change Data Capture mappings(Data Synchronization) and Exception Error handling Mappings.
• Performance Issues are improved using Oracle Partitions, Indexes.
• Performance tuned the workflow by identifying the bottlenecks in sources, targets, mappings and sessions.
• Used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Tracked session log files to identify the issues.
• Configured and used the Debugger to troubleshoot the mappings.
• Perform validation at Initial Population and Ongoing Data Synchronization(B/W Source and Target).
• Perform Unit testing, Integration and System level testing and execute test cases.
• Work with defects and update the tatus in Trac tool.
• Performed Several Mock runs to ensure data integrity between Source systems and Target systems.

Environment: Informatica Power Center 9.1, DB2, Oracle 11g,SQL, PL/SQL, UNIX Shell Scripting, Control-M,Data Management Studio,SalesForce Database .

Confidential, Bloomington, IL

ETL Developer

Responsibilities:

• Extensively used Informatica 9.1 to extract, transform and load data from various sources.
• Monitoring and Tracking the applications as per schedule run.
• Created reusable mapplets, sessions and worklets and used them in workflows.
• Developed Informatica mappings and mapplets, Reusable Transformations between sources and operational staging targets and fine-tuned some of them for better performance.
• Created complex mappings in Power Center Designer using Lookup, Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Rank, Sorter and Joiner Transformations.
• Handling the user queries and tickets for Informatica applications.
• Extensively Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Designed for populating tables for one time load and Incremental loads.
• Create workflows based on the dependencies for the code changes in Informatica.
• Created Event Wait, Event Raise, Timer and Control Events in workflow manager according to the business requirement.
• Provided extensive support in UAT (user acceptance testing) and deployment of mappings..
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Worked with DBA team to fix performance issues.

Environment: Informatica Power Center 9.1, SQL, PL/SQL, SQL Server 2008, UNIX Shell Scripting, Informatica Scheduler, TOAD, SQL Server tool, Oracle 10g.

Confidential, Saint Cloud, MN

Informatica Developer

Responsibilities:

• Interacted with business users for requirement analysis and to define business and functional specifications.
• Documented user requirements, translated requirements into system solutions and developed implementation.
• Worked closely with the SME’s and Business Analyst to create the Data map document.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• The objective is to extract data stored in different databases such as Oracle, SQL Server and to load finally into a single data warehouse repository, which is in Netezza and DB2.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner. Used Power exchange for mainframe sources.
• Prepared software requirement specifications, business rules interacting with business units and designed Star Schema, logical and physical database design for Domains.
• Developed data Mappings, Transformations between source systems and data warehouse.
• Performed Type1 and Type2 mappings.
• Managed the Metadata associated with the ETL processes to populate the data warehouse.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Migrated development mappings to QA and Production environment.
• Tuned performance of Informatica session for large data.

Environment: Informatica Power Center 8.6.1(Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor),SQL Server, Oracle 10g, DB2, Flat Files.

Confidential

Jr Informatica Developer

Responsibilities:

• Worked with business analysts to understand the business needs for decision support data.
• Leveraged Informatica to extract data from heterogeneous source systems ( Oracle, SQL Server, XML and flat files) and aggregate the data and load into the data warehouse.
• Implemented Joiner, Expression, Aggregator, Rank, Lookup, Update Strategy, Filter, Router Transformations and Mapplets in mappings.
• Wrote several procedures & functions to build and load the tables into the Oracle Database.
• Created and worked extensively with parameter files for various workflow variables, session Parameters, mapping variables and parameters.
• Constantly worked on performance tuning of mappings and sessions.
• Developed PL/SQL procedures, functions, triggers to facilitate specific requirement.
• Debugged and resolved load failures by verifying the log files. Supported UA testing in fixing Bugs ad also helped to resolve various data issues.

Environment: Informatica Power Center, Oracle 9i, SQL Server, SQL,PL/SQL, Erwin, XML Files and Windows XP.