SUMMARY:

• Over five years of experience in Information Technology with a strong background in Data Warehousing.
• Experienced in both Web applications and Client/Server applications.
• Extensive experience in working on various test strategies and preparing Test Plans, Test Cases and Analyzing Test Results based on business requirements.
• Extensive experience in using different tools like Quality Center, ALM QC and Test Director. Experience in using automated tools like QTP.
• Experienced in Integration Testing, System Testing, Regression Testing, Web Testing, GUI Testing, Functionality Testing and Database Testing.
• Well versed in Software Development Life Cycle (SDLC) models like Waterfall & Agile Models (Scrum & Kanban).
• Developed Test Strategy, Test Plan, Test Cases for Functional requirements.
• Work experience reviewing and testing of data maps between various legacy systems and relational databases.
• Experience includes testing of applications which use integrated database using Informatica, Business Objects, Oracle (11g, 10g, 9i, 8i) and DB2.
• Excellent Functional knowledge on various domains like Insurance, Finance/Banking, ETL/Database management
• Hands - on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum, RAD, TDD.
• Proven analytical skills in solving problemswhen defects are raised.
• Knowledge in understanding applications that are developed in Microsoft Test Manager, Visual Studio, Team Foundation Server, MS SQL Server, C#.
• Proven ability to create test artifacts (strategies, test plans and test cases, etc.…) Good exposure to .Net, Visual Basic, JAVA, J2EE, ASP, HTML, Shell Scripts, Oracle, SQL Server development environments.
• Solid understanding of Oracle & SQL Server databases and Windows/UNIX operating systems.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Experience in database, data analysis, SQL and Database testing skills.
• Communicated with business & development teams to resolve issues during test execution.
• Self-Starter, ability to adapt to any industry new technologies and trends.
• Highly motivated team player and ability to work in all environments to meet targets.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Tester

Responsibilities:

• Reviewed Business Requirement Document (BRD) for accuracy and Completeness.
• Designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Written test cases to test the application manually in Quality Center
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Creating test cases for ETL mappings and design documents for production support worked with flat files and excel sheet data sources.
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing.
• Used PLSQL developer, SQL *Plus to run SQL queries and validate the data.

Environment: Informatica Power Center 9.1, Oracle10g, SQL Server 2008, Flat Files, Linux, Windows XP. Tableau.

Confidential, MN

Informatica Developer/Tester

Responsibilities:

• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Developed Test Cases and SQL Queries to perform various Validations.
• Performed Unit Testing, Integration Testing, User Acceptance Testing and Requirement Testing.
• Executed Test Cases with respect to Source and Target database tables.
• Written SQL queries to validate reports against the database.
• Extensive SQL querying on Staging, Datawarehouse and Data Marts.
• Developed and implemented ETL processes using Informatica to move data from different sources into Data mart.
• Define, create and access data source layouts and target data warehouse and data mart Schemas through Informatica Power Mart Designer.
• Developed various Mappings, Transformations and Mapplets for migration of data using Informatica Designer.
• Worked with complex mappings using expressions, aggregators, filters, lookups, Update strategy, router, joiner, rank, sequence generator transformations in Informatica.
• Increased the cache size of transformations depending upon the requirements.
• Done data migration, data cleansing and aggregation while transformation.
• Done Performance tuning in Informatica.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on Oracle SQL Developer to develop queries & create procedures and packages in Oracle.
• UsedWorkflow Managerfor Creating, Validating, Testing and Running the sequential and concurrentBatchesandSessions, scheduled them to run at a specified time.
• Done Error Handling and debugging using Informatica debugger.
• Applied slowly changing dimensions Type I and II effectively to handle the Loads.
• Involved in Performance tuning of various queries understanding the need of indexes after having complete note of the Explain Plan.
• Validated reports based on Functional Requirements.
• Checked the reports for any naming inconsistencies and to improve user readability.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data. Imported data from various sources transformed & loaded into Data Warehouse Targets using Informatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Used UNIX cron jobs to schedule the sessions to automate the update process in the workflow manager
• Worked closely with the reporting teams to design the Datamart which was further used by SAS team to customize reports as per business requirement
• Worked with different sources such as Oracle, MS SQL Server and flat files.
• Knowledge of slowly changing dimension tables and fact tables.
• Writing documentation to describe program development, logic, coding, testing, and corrections.
• Optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica Power Center 8.6, Oracle 9i/8i, Teradata, SAS, MS SQL Server, ERWIN 4.0, SQL, PL/SQL, SQL*Loader, SQL Navigator, SQL Server 2000, Windows NT/2000, HP-Unix.