PROFESSIONAL SUMMARY:

• 8 years of IT experience in Analysis, Design, Development, Testing, and Implementation of business application systems for Banking, Financial, Insurance and HealthCare Sectors with a strong background in Database development and Data warehousing (OLAP) and ETL process using Informatica Power Center 9.x/8.x
• Expertise includes Data Analysis, Data Modeling, Data Cleansing, and Transformation, Integration, Data import, Data export and use of ETL tool including Informatica.
• Extensively worked on Informatica Designer components Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Extensively worked on Informatica Power Center Mappings / Mapplets using various Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure and Sorter.
• Proficient in developing Slowly Changing Dimension Mappings of type I, II and type III.
• Extensively involved in Informatica performance tuning, error handling, debugging and problem fixing in Informatica.
• Proficient in warehouse designs based on Ralph Kimball and Bill Inmon methodologies.
• Significant experience in Dimensional Data Modeling techniques using Star Schema and Snowflake schema with FACT and Dimensions tables designed using ERWIN data modeler.
• Worked extensively on Flat Files, as the data from various Legacy Systems parsed the Functional specifications into a Technical document.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Excellent exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Extensive Database experience using Oracle 11g/10g/9i/8i, DB2, MS SQL Server.
• Expertise in SQL/PLSQL, T - SQL programming development and execution of packages, stored procedures, functions, triggers.
• Excellent knowledge of UNIX shell scripting, automation of ETL process and scheduling of jobs using Autosys.
• Extensive experience in Unit testing, System testing and User Acceptance Testing.
• Strong problem solving, analytical, interpersonal skills, communication skills and have the ability to work both independently and as a team.
• Self-motivated person with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1/8.6.1/8.5

Data Modelling Tools: Erwin 4.0/3.5

Operating Systems: Windows XP/NT Server, 98, 2000, 2003, 2008, 2012 server, Redhat Enterprise Linux 4, 5, 6 and 7, Sun Solaris, IBM OS/390, Z/OS

Database Systems: Oracle 8i, 9i, 10g, 11g, 12c, MS SQL Server 2000, 2005, 2008, 2012, Oracle Enterprise Manager, IBM DB2v9.5

Software Development: SQL, PL/SQL, C++, C and UNIX Shell Scripting.

Software Engineering: IBM Rational Rose, MS Project, Experienced in all the phases of the Software Development Life Cycle Model

Web Technologies: HTML, JavaScript, CSS, XML, XML Schemas, Java Servlets

Productivity Tools: Toad, SQL Developer, SQL Server Management Studio, Putty, Core FTP, FileZilla, Autosys, Lotus Notes, Visual Studio, SharePoint, MS FrontPage, Macromedia Dreamweaver, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Mclean, VA

ETL Informatica Developer

Environment: Informatica Power Center 9.6.1, Oracle 11g/12C, PL/SQL, SQL Developer, SQL Plus, Microsoft SQL Server 2008 & 2012, RHEL 5, 6 & 7, Shell Scripting, Windows 2008 & 2012, Flat Files, Toad, Putty, SQL Server Management Studio, AUTOSYS, Oracle Enterprise Manager

Responsibilities:

• Involved in the full life cycle development of the project including design, development, and testing.
• Analyzed the business requirements and suggested changes to the design accordingly.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL Server and Flat Files and loaded in to Oracle.
• Implemented code using various Informatica Transformations like Joiner, Expression, Lookup, Aggregator, Filter, Router, Update Strategy and etc.
• Loaded the data into the XML and Flat files.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Extended logic for some of the existing mappings in the system to meet enhancement procedures.
• Used Lookup Transformation to lookup the values in Flat Files.
• Involved in creation of various UNIX scripts which help the ETL scheduling jobs and help in initial validations of various tasks.
• Applied partitioning at session level for the mappings which involved loading data to target using target lookup to avoid duplicates records.
• Involved with Workflow Monitor, Repository server and Informatica server to load data from flat files and legacy data.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, for Data Load.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Extensively used ETL tool to load data from both Fixed Width as well as Delimited Flat Files. Extracted and loaded data in databases such as DB2, Oracle and SQL Server
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them to run at specified time with required frequency.
• Extensively used TOAD for the unit testing and Integration testing.
• Copied/Exported/Imported the mappings/sessions/work lets/workflows from development to Testing and promoted to Production.
• Worked on Autosys Job Scheduler to automate the Workflows.
• Involved in production support for issue fixes and helping out from the system failures.

Confidential, San Francisco, CA

Informatica Developer

Environment: Informatica Power center 8.6.1, Oracle 10g & 11g, Windows 2003, RHEL 4 & 5, Shell Scripting, SQL, PL/SQL, TOAD, Flat files, Putty, Oracle Enterprise Manager.

Responsibilities:

• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Extensively worked with Source Qualifier, Aggregator, Sorter, Normalizer, Rank, Joiner, Union, SQL, Lookup, Router, Expression, Filter, Update Strategy, and Stored Procedure transformations to store the data in target tables.
• Involved in creating the Technical design documents and mapping specifications.
• Modified existing/Developed new complex Informatica Power Center Mappings to extract and pull the data according to the guidelines provided by the business users and populate the data into Target Systems.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type 2 and type 1.
• Involved in identifying the bottlenecks of the Informatica mappings and tuned the mappings and increased the performance of the mappings.
• Extensively worked on Mapping Variables and Parameters.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Extensively used TOAD to run SQL Queries and validate the data.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used Pushdown Optimization, Incremental Aggregation and Persistent Cache in order to increase the performance of the jobs.
• Involved in tuning the lots of oracle queries and increased the performance to a greater extent.
• Experienced in writing complex SQL and PL/SQL in oracle.
• Worked extensively on the Oracle External Tables which helped to read the flat file in the form of table without loading them into the table.
• Worked with Informatica Debugger to debug the mappings in Informatica Designer.
• Involved in the continuous enhancements and fixing of production problems.
• Performed Data Quality checks, and developed ETL and Unix Shell Script processes to ensure flow of data of the desired quality.
• Involved in Unit Testing, System Testing, User Acceptance Testing to check whether the data load into target was accurate which was extracted from different source systems according to the user requirements by generating several SQL test scripts, validating against test cases based on the pre-defined test plans.

Confidential, Rockville, MD

Informatica Developer

Environment: Informatica Power Center 8.5, DB2 UDB, Oracle 9i/8i, PL/SQL, SQL, SQL*LOADER, TOAD, FileZilla, Shell Scripting

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files and loading into Staging and Star Schema.
• Involved in massive data cleansing prior to data staging.
• Used Informatica designer for designing mappings and mapplets to extract data from SQL Server and Oracle sources.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Creating reusable transformations, mapping, Mapplet, various tasks like Session, Command, Email, Timer, Control, Event Wait, and Event raise, Assignment, Worklets and workflows.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Executed the workflow using pmcmd command in UNIX.
• Tuned the workflows and mappings.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Involve in review code and scheduling measures and Performed Unit Testing for the developed mappings.
• Used Debugger to test the data flow and fix the mappings.
• Participated in weekly and monthly meetings with project managers to discuss work status and required process documents.
• Experienced in coordinating with the team and resolving the issues of the team either technically or functionally.