SUMMARY:

• Over 10 + years of experience in Information Technology with a strong back ground in Analyzing,Designing, Developing, Testing, and Implementing of Data Warehouse development in variousdomains such as Banking, Insurance, Health Care, Telecom.
• 7+ Years of Professional experience in Data Warehousing ETL Technologies using Informaticapower center Client tools and hands on experience in SDLC, QA Lifecycle, testing of Webapplications, Data Warehousing and Business Intelligence (BI) applications.
• In depth knowledge of Data warehousing concepts, Dimensional Data modelling, Starschema and Snow flake schema.
• Have worked with business analysts, development leads and managers in outlining entry andexit criteria for QA.
• Proficient in developing Testing Strategies, Test Cases, Test Plans for Data warehouseProjects.
• Developed Test Plans, Test Requirements, Test Cases, Test Reports, and defect tracking asrequired by the project.
• Having good experience on Health care and telecommunication domain.
• Ability to conduct walkthroughs in order to formulate and design complete and detailed testplans and test cases for System, Functional, and User Acceptance Testing.
• Proficient in SQL, experience in writing queries for back - end testing to validate datatransactions.
• Experienced in Data Warehouse testing errors and provide support to programmers tocorrect defects in the system.
• Extensively worked on Quality Center to Design Test Steps, Requirement Mapping, ExecutingTests, Defect Logging and Bug Reporting.
• Requirement Mapping, Executing Tests, Defect Logging and Bug Reporting.
• Experience in integration of various data sources with Multiple Relational Databases likeOracle, SQL Server and Worked on integrating data from flat files like fixed width anddelimited.
• Extensive experience in extraction, transformation and loading of data from differentheterogeneous source systems like flat files and Oracle.
• Proficient in ETL design using ETL tool like Informatica power center 7x/8x/9x and hands onexperience with Data Extraction, Transformation and Loading.Knowledge on TWS (Tivoli Workload scheduler) System for Scheduling.
• Process Oriented and have excellent Understanding of SDLC process, have ability to learnthings quickly and implement.
• Extensively used ETL methodology for supporting Data Extraction, transformation andloading, in a corporate-wide- ETL Solution using Informatica.
• Hands of experience on UNIX commands and extensively worked on UNIX shell scripting.
• Have also worked in an Onsite - Offshore model have carried out the different phases of theprojects effectively by excellent co-ordination activities.
• Excellent problem solving skills with strong technical background and good interpersonaskills. Quick learner and excellent team player, ability to meet deadlines and work underpressure.

TECHNICAL SKILLS:

Hadoop: HDFS, Pig, Hive, Sqoop and Oozie

ETL tools: Informatica Power Center (9.x/8.x/7.x), Informatica IDQ 9.x

Programming Language: Cobol

Databases: Oracle (9i,10g,11g),DB2,Teradata,SQL Server

Tools: and Utilities: Teradata utilities like BTEQ, Multiload, FastLoad, FastExport, TPT

SQL Assistant, WINSCP, SQL*PLUS and TOAD, Super Putty, Quality Centre 9.0,: TWS (Tivoli Workload Scheduler),Manual Testing

Scheduling Tool: Control M, Active Batch, Autosys

Reporting Tool: Cognos

Operating Systems: MVS Z/OS,Windows 2000/XP/2007,UNIX and Shell Scripts

DB2 Utilities: QMF, SPUFI and BMC

Software Configuration Management Tool: ENDEVOR

SCM Tools: MS Visual SourceSafe,Win CVS,Tortoise SVN

EXPERIENCE:

Confidential, CO

Sr.ETL Tester

Responsibilities:

• Worked on the creation of standard test environments, tests plans, and test scripts andtest execution.
• Design and Develop Test Plans for different application releases.
• Created and executed detail functions DW test scripts based on the DW Mapping DesignDocuments.
• Responsible for Data Mapping testing by writing SQL Queries.
• Tested data warehouse components, data marts, testing of Dimension and Fact tables.
• Performed various types of testing, such as Black box, Functional and Regression testing.
• Determined testing scope and prioritized deliverables in different phases.
• Work closely with DW Developer to follow up on defects to get closed within the timelinesand the same to be informed to stake holder.
• Written SQL queries for checking the Data Transactions.
• Responsible for verification and validation of all custom code, fixes enhancements andinterfaces to the various subsystems.
• Performed reviews on the schedules created in Tivoli to make sure schedule has beencreated as per the requirement.
• Extensively used Mercury Quality Center (QC), for test planning and reporting.
• Used Toad to write and execute SQL queries

Environment: Windows 7, Informatica Power Center 9.6.1, Linux, DB2, Toad, Tivoli schedulerQuality Centre 9.0

Confidential, Nashville, TN

Sr. ETL Tester

Responsibilities:

• Knowledge on executing batch processing workflows like Sequential batch processing andparallel batch processing workflows.
• Verified throughput in workflow monitor, Session logs and workflow logs for workflows.
• Worked with pmcmd command line for executing workflows and verifying the session logsrunning session details, Task details and workflow details for verifying the test results.
• Promoted Unix/Informatica application releases from development to QA and to UAT

• Automated and scheduled the Informatica jobs using UNIX Shell Scripting for testing needs.
• Done performance testing for Informatica mappings.
• Done integration testing for Informatica workflows.
• Identifying duplicate records in the staging area before data gets processed.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Experienced in writing test cases, test scripts, test plans and execution of test casesreporting and documenting the test results using HP Quality Center.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Analyzed business requirements, system requirements, data mapping requirementspecifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Checking the status of ETL jobs in UNIX and tailing the log files while the loading is underprocessing.
• Compared query result sets from different database systems using UNIX diff command.
• Tested the Application in UNIX Environment and collecting the Test data from the BusinessTeam.
• Written several SQL queries for validating different complex data scenarios.
• Experience in using SQL, PL/SQL Procedures/Functions, for ETL process.
• Tested several Business Objects reports for data quality, fonts, headers and cosmetic.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Executed SQL Queries to check table updates and data retrieval
• Extensively participated in project status meetings related to testing.

Environment: Informatica 9.6, Oracle, SQL, PL/SQL, HP Quality Center, Excel, XML,TOAD, Korn Shell Scripts, UNIX, Windows XP