PROFESSIONAL SUMMARY:

• 6+ years of IT experience, Working as ETL tester on various Data Warehouse Environments in multiple domains.
• Experience in full software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Expertise in understanding Business Requirements, Functional Requirements, decomposing into HLD's and ETL Specifications into Test Cases for positive and negative test conditions.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in gathering functional requirements from users and designing data model for ETL development.
• Experience in writing and development of test cases, test scripts and test procedures.
• Identifying and tracking performance issues and defects during testing.
• Experienced with coordinating cross - functional teams, project management and presenting technical ideas to diverse groups & proven ability to implement technology-based solutions for business problems.
• Experience in Data Profiling, Data Extraction, Data Integration, Data Testing and Data Cleansing.
• Excellent communication skills, team player and hard working.
• Have academic exposure to software development life cycle like Feasibility, Design, Coding, Testing, Implementation and Maintenance.
• Application Data warehousing experience in Financial, Banking, Confidential and Confidential .
• Experienced in running SQL queries using Toad (Oracle), Teradata SQL Assistant and SQL server.
• Experience in Performance Tuning of SQL and stored procedures.
• Passionate worker to contribute individually and as part of a team.
• Ability to learn modern technologies quickly with good analytical and problem-solving skills. Authorized to work in United States for any employer.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr.ETL Tester

Responsibilities:

• Worked on ETL Data Warehousing, database testing using Informatica for Workflow process
• Defects tracking, review, analyze and compare results using Quality Center.
• Defined the Scope for System and Integration Testing.
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
• Involved in Test Scheduling and milestones with the dependencies.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios)
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Tested the reports developed in Cognos against the database.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation.
• Used T-SQL for Querying the SQL Server2008 database for data validation and data conditioning.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Tested Desktop Intelligence and Web Intelligence reports.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio.
• Used Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard).

Environment: Informatica, QTP, SQL Server, Quality Center, Agile, PERL, Oracle, Java, Cognos, T- SQL, SAS, XML, XSLT, XML Spy, SQL, PL/SQL, Teradata.

Confidential, Charlotte, NC

Sr.ETL Tester

Responsibilities:

• Analyzed the key functionalities of the institute and performed Data Analysis and abstracted the transactional nature of data.
• Used Informatica Power Center 9.5/9.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Developed complex mappings in Informatica to load the data from various sources.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Experience in working with SQL Server Integration Services (SSIS).
• Worked with Informatica IDQ to determine Data Quality issues and Remediation process for bad data.
• Developed PL/SQL scripts to transfer tables across the schemas and databases.
• Writing validation packages using PL/SQL package using Data Structures.
• Used Ref cursors and collections for accessing complex data resulted from joining of enormous number of tables in PL/SQL blocks and even have experience with exception handling.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.
• Assisted Data Analyst in all stages of development processes including extraction, transformation and loading(ETL) data from various sources like IBM web sphere application server, Sterling file gateway, Sybase facets performance analytics.
• Co-ordinate with Offshore team to analyze, develop and test Migration projects.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Successfully developed drill down reports and hierarchies, created cascading values using Cognos.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages Oracle.

Environment: Informatica Power Center 9.6.1/9.5, Informatica Data Quality (IDQ), Facets, Informatica Cloud REST API, AWS Redshift, Oracle 11g, MS-SQL Server, Informatica servers on Unix Putty, SSIS.

Confidential, Silver Spring, MD

ETL Tester

Responsibilities:

• Tested Informatica mappings. Performed data validations against Data Warehouse.
• Involved in job scheduling using MS SQL server Agent.
• Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Prepared and Scheduled for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases.
• Created roles, and set permissions to ensure that company's security policies are enforced and in effect.
• Created test case scenarios, executed test cases and maintained defects in Remedy.
• Tested reports and ETL mappings from Source to Target.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).
• Optimized, partitioned cubes to speed up report latency and performance optimizations.
• Assisted in Troubleshooting of Report deployment on multiple servers.
• Responsible for extensive data validations on Data warehouse and reports.
• Responsible for leading team and co-coordinating with offshore team.
• Prepare and set up environment for Disaster recovery.

Environment: Informatica, Microsoft SQL Server 2008, Enterprise Manager, Database Transformation Services (DTS), VB Script, T-SQL, SQL Profiler, MS Access, XML, XSLT, XSD

Confidential

ETL Tester

Responsibilities:

• Prepared and Scheduled for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases.
• Created roles, and set permissions to ensure that company's security policies are enforced and in effect.
• Created test case scenarios, executed test cases and maintained defects in Remedy.
• Tested reports and ETL mappings from Source to Target.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Tested Informatica mappings. Performed data validations against Data Warehouse.
• Involved in job scheduling using MS SQL server Agent.
• Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Responsible for extensive data validations on Data warehouse and reports.
• Responsible for leading team and co-coordinating with offshore team.
• Prepare and set up environment for Disaster recovery.
• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).
• Optimized, partitioned cubes to speed up report latency and performance optimizations.
• Assisted in Troubleshooting of Report deployment on multiple servers.

Environment: Informatica, Microsoft SQL Server 2008, Enterprise Manager, Database Transformation Services (DTS), VB Script, T-SQL, SQL Profiler, MS Access, XML, XSLT, XSD.