SUMMARY

• 7+ years of experience in Software Testing and Quality Assurance
• Strong understanding of Software Development Life Cycle (SDLC) and object oriented methodologies
• Expertise in Manual and Automation testing of Web Based applications
• Expertise in Functional and Regression testing using Selenium RC and Selenium Web Driver with TestNG framework
• Good programming skills in C,C++,C# and JAVA
• Expertise in using Front End web technologies such as HTML and XPath
• Expertise in working with JUNIT, TestNG testing frameworks
• Experience in Manual testing, Automation testing, Functional testing, Regression testing, Black Box Testing, White Box Testing and DB testing
• Experience in implementing dynamic web applications using Apache Tomcat and deploying in Windows environment
• Good understanding of build automation tool Apache Ant
• Good understanding of RDBMS concepts and good exposure to databases such as Oracle and SQL Queries
• Good knowledge of various Software Development and Testing Methodologies such as Waterfall, Iterative, Spiral, AGILE:SCRUM
• Well versed with UNIX Commands
• Experience in Defect management and Bug Reporting using bug - tracking tools such as Quality Center and JIRA
• Good understanding of XML technologies such as XML schema and Xpath
• Experience in Functional and Regression Test Automation using QTP
• Expertise in understanding Business Requirement Specifications, Functional Specifications and Design documentations and converting them into comprehensive Test Scenarios with Test Strategies and Test plans
• Experience in Defect management, Defect coordination, coordination between onsite-offshore team and bug management
• Self-motivated with quick learning capabilities and good communication skills
• Hard working and result oriented with a quest and zeal to learn new technologies and undertake challenging tasks

PROFESSIONAL EXPERIENCE

Informatica/Etl Developer

Primary Skills: Informatica Power Center 9.x / 8.x / 7.x / 6.x, Teradata, IBM DB2, MS SQL Server, Erwin, E/R Studio

Confidential

Responsibilities:

• Over 8+ years of IT experience in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) using Informatica Power Center with Oracle, MS SQL server, DB2 and Teradata databases.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post - implementation review.
• Proficient in implementing complex business rules through Informatica transformations, Workflows/Worklets and Mappings/Mapplets.
• Experience in debugging and Performance tuning of targets, sources, mappings, sessions and system and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Experience in Installation, Configuration, and Administration of Informatica Power Center Client, Server and having handled FTP systems and release management.
• Experience in 24X7 on call Production support and preparing procedures/documentation whenever necessary.
• Possess excellent documentation skills, prepared best practices document’sand have experience in data modeling and data modeling tools like Erwin.
• Extensive Experience in writing SQL queries, stored procedures, functions, packages, triggers, exception handlers, Cursors.
• Expert in Unit Testing, Integration testing and System Testing.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.

Informatica Developer

Primary Skills: Informatica Power Center 9.X/8.X/7.0/6.x/x, Datamart, ETL, Erwin 4.0/3.5.2/2.x

Confidential

Responsibilities:

• Around 7 years of experience in the IT field, of which 6 years related to various aspects involving business understanding, requirement gathering, Data Analysis, design, ETL development, Enhancement, production support experience in data warehouse and business intelligence applications.
• 6 years of experience in data extraction, migration transformation and loading using Informatica PowerCenter (Source Analyzer, Repository Manager, Data Warehousing Designer, Mapping Designer, Mapplet Transformation), Informatica Power Connect for SAP/DB2.
• Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings, PL/SQL Stored Procedures.
• Proficient in using Workflow Manager Tools like Task Developer, Worklet Designer.
• Hands on experience in DWH concepts, Data Modeling, Data Profiling and Data Clanging.
• Experience in designing/developing complex mapping using Connected and Unconnected Lookups, Normalizer, Source Qualifier, SQL Transformation, Router, Filter, Expression, Aggregator, Sorter, Joiner, Update Strategy and Stored procedure etc
• Extensively used Slowly Changing Dimension (SCD) technique for incremental updating of the targets.
• Experience in Oracle 11g, IBM DB2, MS SQL Server 2008, PL/SQL.
• Good knowledge of Dimensional Data Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Good Knowledge of OLTP and OLAP Concepts and knowledge of Ralph Kimball data warehousing methodologies.
• Experienced in Windows 7/NT/XP/2000/NT/98, UNIX, and Linux.
• Experienced in Testing, Debugging, Validation and Tuning of mappings, workflows.
• Extensively worked with Parameter files, Pipeline Partitioning, Pushdown Optimization, and Informatica Scheduler.
• Extensively worked on DAC for scheduling informatica workflows. Create New Execution Plans and scheduled them.
• Strong experience in Error handling, Performance tuning and Optimizing- the source, mappings, transformations, sessions, and the targets, and expertise using Informatica Debugger.
• Solid experience in writing SQL queries, PL/SQL, Stored Procedures, and optimization.
• Experience in Unix Shell Scripting for scheduling/running ETL jobs in production environment.
• Experience in Customer relationship Management and addressing customer issues.
• Strong Team working spirit, communication and relationship management skills.

Etl Developer

Primary Skills: InformaticaPowerCenter9.x/8.x/7.x/6.xOLAP, OLTP, Star Schema

Confidential

Responsibilities:

• Over 8+ years of experience in Software industry with special emphasis on Design and Development of Data Warehousing using Informatica Power Center.
• 5 years of Experience in all the phases of the Data warehouse life cycle involving design, development and analysis and testing in various areas of Data warehousing.
• Extensively used Informatica Client tools such as Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager/Monitor, Informatica Repository Manager and Informatica Server Manager.
• Created ETL mappings using Informatica PowerCenter to move data from multiple sources like XML, SQL server, Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Implemented Slowly Changing Dimension methodology for accessing full history of dimension data.
• Have good understanding and exposure to Data Warehousing techniques such as Star-Schema Modeling, Snowflake Modeling, OLAP, Fact tables, Dimension tables.
• Hands-on experience in Tuning Mappings, identifying and resolving Performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Proficient in Oracle 10g/9i, SQL, PL/SQL, SQL*Plus, SQL developer and Toad.
• Experienced with coordinating cross-functional teams and presenting technical ideas to diverse groups.
• Ability to work independently as well as in a team and in a challenging environment.

QA Engineer

Primary Skills: Selenium 2.0, Selenium IDE, Selenium RC Confidential:

Confidential

Responsibilities:

• Over seven years of professional experience in Information Technology with emphasis on Software Quality Assurance and Automation Testing.
• Hands on experience in Manual testing at all levels of STLC (Software Testing Life Cycle).
• Exposure to all stages of SDLC (Software Development Life Cycle)
• Solid Expertise in Automation of web based Application in Selenium WebDriver, Selenium RC, Selenium IDE and Selenium Grid.
• Solid expertise in automated testing tools suite - Selenium, and good exposure on tools Eclipse, JIRA, Bugzilla, Test Director, Quality Center
• Experience in testing Web services using SOAP over HTTP, JSON over HTTP using JUNIT.
• Extensively proficient in Functional testing, Performance testing, Integration testing, GUI testing, and Regression testing, Automation testing, Load testing, UAT testing on client/server as well as web-based applications
• Expertise in Test Plan creation, Test Case Design, Test case Review, Test Case Execution, Writing Test scripts, Testing tool Usage, Defect management, Prepare Test reports.
• Strong experience as a Java Programmer / Software Developer in Web/Intranet, Client/Server Technologies using Java, J2EE, XML, IBM Web Sphere Server 6, JDBC, Oracle, DB2.
• Developed automated scripts using java to perform functional and regression testing for Java based web Application.
• Coded many helper and Utility classes in Java. Used Java Log4j logging framework for logging and debugging.
• For testing purpose, added print statements in Java code to check the dynamic values in the logs and to check the sequence and flow of execution of Java API.
• Created Java Test Scripts to automate test scripts in different browser like Firefox, Safari, IE and Chrome.
• Using TestNG performed functionality testing. Using TestNG in Eclipse executed and tested various functional modules in Java code using assertion.
• Using Selenium Web driver written automated web application UI tests in Java for testing speed, effectiveness of computer, network and efficiency of application, Checked and verified response time.

TECHNICAL SKILLS

Testing Tools: Selenium Web Driver, Selenium RC, Selenium IDE, JUnit, TestNG, QuickTestPro(QTP)Programming Languages: C, C++,C#.Net,JAVA

Web Technologies: HTML, CSS, JavaScript, AJAX,XML,Xpath

Defect Tracking Tools: HP Quality Center(QC), JIRA, BugZilla

Databases: Oracle 11g, MS SQL server, MySQL

Operating Systems: Windows XP/2003/Vista,UNIX, Linux

Build Tools: Apache Ant

App/Web Server: Apache Tomcat

IDE: Eclipse(JUNO)

Browsers: IE 7.x/8.x/9.x, Firefox, Chrome

Packages: Microsoft Office Suite

Total Exp: 7+ Yrs, Available Immediate, Relocation Except CA