SUMMARY:

• Over 7+ years of experience in Analysis, Design, Development of various business applications in different platforms Informatica 9.5.1/ 9.1/8.6.1/7.1,Oracle 9i/10g/11g /12c.
• Experience in Application Design, Data Extraction, Data Acquisition, and Data Mining Development, Implementations and Testing of Data warehousing and Database business systems.
• Expertise in using Informatica 9.6.1/9.5.1/8.6.1/8.1.1/7.1 (Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer).
• Good working knowledge of OLTP systems, Analysis E - R Modeling, Data Modeling using data modelers, Star schema, Snowflake schema, Fact and dimensions table using ERWIN.
• Experience in integration of various sources like Oracle,DB2,Tera data, SQL Server, Fixed width, Delimited Flat Files, XML Files and Main Frames .
• Strong experience on Workflow Manager Tools - Task Developer, workflow and Worklet Designer.
• Worked on Informatica Developer Tool 9.5.1 for profiling purpose and also worked on transformations like Address Doctor, Filter, Joiner, Expression etc.
• Extensively used Source Qualifier, Connected and Unconnected Lookup, Normalizer, Router, Filter, Expression, Aggregator, Stored Procedure, Sequence Generator, Sorter, Joiner, Rank, Update Strategy, Stored Procedure Transformation, Union Transformations, and Mapplets.
• Experience in Mappings, Mapplets, Worklets, Reusable Transformations, Sessions/Tasks, Workflows and Batch Processes in Informatica Server.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCD’s (Type 1/Type 2/ Type 3) loads.
• Involved in PL/SQL Programming (Stored Procedures, Triggers, Functions and Packages) Using Oracle.
• Created ETL Mappings using Informatica Power Center to move Data from multiple sources like XML, DB2, SQL Server, Flat Files, and Oracle into a common target such as Data Marts and Data warehouses.
• Proficient in Functionality Testing, Regression testing, Performance testing process and have good experience in writing Use Case documents, Detailed Design Documents, Test Plans, Test Cases, Use Cases and User Manuals.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, MVS, COBOL files & XML Files.
• Involved in Informatica Developer Tool for Data Quality purpose using address validation transformation during the analysis.
• Also have good knowledge in Performance Tuning at both Database Level and Informatica.
• Good Experience in UNIX Shell Scripting and ETL Process Automation Using Shell Programming.
• Strong logical and Analytical Reasoning Skills, Excellent Communication with Good Listening Presentation and Intrapersonal Skills.

TECHNICAL SKILLS:ETL Tools: Informatica Power Center 9.6.1/9.5.1/8.6.1/8.1/7.1.4 , Informatica Developer 9.5.1, Informatica Analyst, Power Exchange, Metadata Manager, PMPC 3.0

Data modeling: ERWIN 7.0/4.0/3.0,Dimensional modeling, Snowflake, Star schema

Programming: C /C++/ HTML / UNIX Shell Scripting, PL/SQL, Perl.

GUI: TOAD 8.5/10.5.1.3 , SQL * LOADER, SQL Developer, ToadSQLServer

Databases/RDBMS: ORACLE 8i/9i/10g/11i, SQL Server 2000/2005/2008 , PL/SQL, Teradata V2R4/V2R5, SQL* PLUS, DB2 9.0

Operating Systems: Windows 98/2000/XP/ 7/8, MSDOS, UNIX, LINUX

Version Control: SCM, Dimensions

Scheduling: TIVOLI, AutosysPROFESSIONAL EXPERIENCE:

Washington, DC

IDQ/ETL Developer

Responsibilities:

• Work closely with the Business Analyst to gather all requirements.
• Perform the Data Analysis to prepare the Data Quality Rules.
• Prepare the Initial Data Load, Incremental Data Load and Design Document.
• Work Closely with ETL Lead to design the ETL/DQ Mappings and Mapplets.
• Developed all Mappings /Mapplets in Informatica Power center 9.6.1/ to load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected),Expression, Filter, Normalizer, Router, Union, Lookup(Unconnected/Connected), Aggregator, Update Strategy, Sorter etc..
• Worked on profiling data using IDQ and took the results to create Informatica data quality rules for standardization mapplet.
• Developed all Mapplets in Informatica Data Quality for standardization of the Address using Address Validator.
• Worked on Parser Transformation, Standardizer Transformation, Case Convertor Transformation, SQL transformation in IDQ for performing the standardization.
• Worked on Unit Test Document for the code that is developed and took the Results.
• Worked on creating the Tables for the pre staging tables, Involved in writing the views, Stored Procedures.
• Used SQL Loader for loading the data from Files into Tables for the Pre-Staging Tables.
• Used PMCMD Commands and created UNIX shell scripts to run session workflows for Informatica mappings.
• Used Informatica tool for the Job Scheduling.

Environment: Informatica 9.6.1, Oracle SQL Developer 4.1.2, Oracle Database 12c, LINUX, WINSCP

Columbia, MD

Informatica Developer

Responsibilities:

• Converting the SQL Replication project using Informatica and load it into Target database.
• Worked closely with Informatica Admin and DBA to replicate all the ETL Code.
• Worked on updating the mapping documents, design documents and defect
• Captured the data using incremental load using ETL Informatica.
• Converted to load using the csv all the files loading from Stored Procedures and Views using Informatica.
• Imported the views/ Stored procedures using Informatica
• Used different transformations like source qualifier, Filter, Router, Expression, Lookup, Stored Procedure transformation, Update Strategy, Router,.
• Worked on loading from tables to flat files.
• Worked on multiple sources like Oracle/SQL Server/Flat Files.
• Involved in converting the data stage code using a tool to load into Informatica.
• Used Oracle for implementing new Stored Procedures and views.
• Worked closely with testing team to fix the bugs and issues we had during the testing.
• Worked on writing UNIX shell scripting.
• Worked on Dimensions tool for the code migration and versioning purpose.
• Used Tivoli scheduler to schedule the jobs in SIT and PROD.

Environment: Informatica 9.5.1, Oracle SQL Developer 4.0, TOAD for SQL SERVER 4.5.0, Oracle Database 12c, AIX 6, Tivoli.

Informatica Developer

Responsibilities:

• Gathered all the requirements and interacted with Business Users regarding the requirements.
• Developed and automated IDQ Profile level rules and Scorecards.
• Worked on Informatica Developer Tool 9.5.1 for profiling purpose and also worked on transformations like Address validator, Filter, Joiner, Expression, Sorter, Router etc.
• Developed mappings in IDQ for Profiling and used in Informatica designer and integrated with existing mappings.
• Created and ran profiles to analyze the structure and content of enterprise data and identify strengths and weaknesses.
• Create scorecards to score the valid values for any column or the output of rules.
• Use rules to further validate the data in a profile and to measure data quality progress
• Worked on Source to Target Mappings Based on the requirements.
• Maintained all the documents for the Data Model changes.
• Developed complex mappings in Informatica to load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure and Router.
• Created Design documents for the BHI Stage III based on new requirements.
• Extensively used Informatica Power Center 8.6.1/9.5.1 to extract the data from XML and flat files and other RDBMS databases like Oracle and DB2, into staging area and then populate the data warehouse.
• Worked on Data Quality Tickets in 9.5.1 and created BIDR For the Data Quality Tickets.
• Analyzed complex ETL requirements/tasks and provide the estimates/ETC.
• Analyzed the session, event and error log for troubleshooting mappings and sessions.
• Created Impact Analysis Documents which is used for migrations.
• Involved in writing the Complex Queries in SQL.
• Performed Performance Tuning of sources, targets, mappings, transformations and sessions.
• Developed Shell Scripts that generate the parameter files, Checks the source systems to see if the data is loaded and then automatically start the workflows.
• Worked on Emergency SEV-1/SEV-2 tickets.
• Involved in Unit Testing and created Test Cases for those mappings.
• Worked with QA Team in resolving the defects. Provided assistance by responding to inquiries regarding errors, problems, or questions about the Informatica Mappings, Sessions.
• Developed Shell Scripts that generate the parameter files, Checks the source systems to see if the data is loaded and then automatically start the workflows.
• Worked with QA Team and helped them in Testing.
• Worked with QA Team in resolving the defects. Provided assistance by responding to inquiries regarding errors, problems, or questions about the Informatica Mappings, Sessions.
• Used HPOpen View Service center to keep in track about the DQ tickets.
• Supporting development teams with Performance tuning and troubleshooting issues.

Environment:InformaticaPowerCenter 7.1/8.6.1/ 9.5 ,Putty, WINSCP, Toad 10.5.1.3, HP Open View Service center, Software Change Management Workbench 12.0,windows XP, Tivoli, Oracle 11g/SQL Server 2000,AIX 6.2.2, SCM 10.1

Minnesota, MN

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Users and understood the design requirements of the users.
• Used different kinds of transformations like Router, Sorter, Source Qualifier, Joiner, Aggregator, Stored Procedure, Lookups both Connected and Unconnected Lookups, Expression, Expression, XML Sequence Generator, Union, Update Strategy to load data into target tables.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Worked on Incremental Aggregations for improving performance in Mappings and Sessions.
• Created Mappings for Populating data to dimensions and fact tables.
• Extensively used Power exchange  to import source files from Mainframe systems
• Extensively used ETL to load data from wide range of source such as flat files, Mainframes to DB2.
• Used Debugger in troubleshooting the existing mappings.
• Extensively used Toad for DB2 for executing the queries.
• Used IBM Rational Clear Quest to track the Incidents.
• Implemented both SCD’s (Slowly Changing Dimensions) TYPE-1 and TYPE-2.
• Used Mapping Parameters and Variables, Dynamic parameter files, Shortcuts, Reusable Transformations.
• Immediately assisted in Troubleshooting of our application performance issue.
• Involved in migrating folders from Development to Testing and from Testing to Production Environments, creating Connect Strings and synchronizing the Connect Strings and Connection Objects in Dev, Test and Prod environments.
• Involved in Unit Testing and created Test Cases for those mappings.
• Worked with QA Team and helped in Testing at Integration Level.
• Extensively used various tasks like Session task, Event Wait task, Decision task, Email task, Command task.
• Developed Stored Procedures, Functions, Triggers, Indexes and Views.
• Created UNIX shell scripts to run session workflows for Informatica mappings.

Environment: Informatica Power Center 8.6.1, IBM Db2 V9.5, SSH Secure Shell 3.2.9, Putty, Scheduler CA7 for Mainframes, Erwin, Clear CaseQuick 3270 V2.5 Mainframes, IBM Rational Clear Quest, Microsoft Visio, Toad 9.0,Power Exchange, windows XP,PVCS

Confidential

Sunnyvale, CA

SQL/ETL Developer

Responsibilities:

• Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Worked on creating mapping/Imported Sources/Targets etc. using Informatica Power center 7.1
• Developed and tested all the Informatica mappings involved complex lookups and update strategies.
• Created Stored Procedures, Views and Packages in Oracle.
• Designed and documented the validation rules, error handling and test strategy of the mappings.
• Implemented Slowly Changing Dimensions (SCDs, Type 2).
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Configured sessions with email when failure and decision task
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema using Erwin 4.0.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities
• Analyzed the session, event and error log for troubleshooting mappings and sessions.
• Responsible for submitting DBA requests using LOTUS NOTES, following up with data base DBA’s and Informatica administrators, creating remedy ticket, handling all the signoff’s for the production, updating all changes with new versions using START team, creating test cases using Quality Center.
• Involved in Data Profiling using Data Explorer.
• Expert knowledge in SQL Queries, Triggers, PL/SQL Procedures, Packages to apply and maintain the Business Rules.
• Using Toad to increase User productivity and application code quality while providing an interactive community to support the user experience.
• Involved in Performance Testing created test cases and captured test results.
• Used PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Did the Performance tuning in Oracle to run the queries faster in the application Dash board.
• Worked with mapping variables, Mapping parameters and variable functions like Set Variable, SetCountVariable, SetMinVariable and SetMaxVariable.
• Worked on Batch Processing or Scheduling and Shell Scripting.

Environment: Informatica Power Center 8.6.1, Teradata V2R5, Erwin 4.0, Oracle10g, PL/SQL, Shell Scripting, Toad, UNIX