SUMMARY:

• Possess 11+ years of overall IT experience with around 05+ years in Big Data/Hadoop/Spark technology.
• Has work experience in Pharma, Retail and Banking domain.
• Deploy, configure, manage and maintain Testing USA’s Microsoft Azure environment.
• In depth understanding/noledge of Hadoop Architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node, and Map Reduce concepts and experience in working with Hive using Apache Hadoop for working with Big Data to analyze large data sets efficiently.
• Good hands on experience over Hadoop components - HIVE, HDFS, Sqoop, YARN, Spark, cloud.
• Has better understanding over data models, referential relations and data integrity.
• Good noledge in how to import and export data between RDBMS and HDFS using Sqoop
• Worked with Oozie that enabled to run workflow jobs with actions that run Hive
• Experienced in working with spark eco system using Spark SQL through PySpark shell on different formats like Text file, Avro, Parquet files
• Excellent understanding of Hadoop Architecture and underlying Hadoop framework.
• Extensive experience in SQL in query processing, execution, optimization, performance
• Experience in creating tables, views, functions, indexes in Oracle databases
• Experience with Agile Methodology, Scrum Methodology.
• Has regular interactions with client over understanding or clarifications on client specific requirements.
• Hands on experience in Functional testing, System testing, Regression testing and Database testing.
• Provide expertise and leadership for offshore transition planning, noledge acquisition and steady state delivery, and set client/team expectations throughout teh engagement
• Handled several techno-functional responsibilities including estimates, identifying functional and technical gaps, requirements gathering, designing solutions, development, developing documentation, and production support
• Lead execution of complex tests according to established plans and scripts, documents defects in tracking system and retests software corrections to ensure problems are resolved.
• Involved in time estimation for client specific projects.
• A good team player with excellent communication, presentation and interpersonal skills and ability to prioritize and coordinate work across different geographic locations

TECHNICAL SKILLS:

Programming Languages: C, SQL

Scripting Languages: UNIX Shell scripting

Operating Systems: Windows NT/2000, UNIX

Test Management Tool: Test Director 8.0, BBU, HP ALM12, JIRA v6.4.14

Data Warehousing Tool: Informatica 6.2, Datastage 8.5

Database Skills: MS SQL Server 2000, Oracle 10g, Teradata

Hadoop Eco System: Hadoop 2.5.0, HDFS, Hive1.2.1, PySpark, Sqoop, Oozie

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

Lead Engineer

Environment: Hadoop 2.5.0, HiveQL, UNIX

Test tools: JIRA v6.4.14

Responsibilities:

• Working closely with business on understanding teh processing of financial transformation data requirements.
• Developing Hive queries to validate teh data completeness and data quality against teh aggregated data in teh target table.
• Strong experience in Cloud (AWS) testing
• Expertise in Data migration testing from Legacy systems to Cloud applications.
• Developed automation script using Unix shell scripts for backend validation.
• Involved in creation of hive tables, loading teh structured / unstructured data from teh files using HDFS commands.
• Used ORC (Optimized Row Columnar) file format to improve teh performance of Hive Queries
• Developing HIVE queries and automating them by creating workflows using Automic.
• Developed automated unit test script using Hiverunner as part of in-sprint automation that executes teh development code or queries with teh test data as prepared.
• Enabled compression at various phases like on intermediate data, final output, to achieve teh performance improvement in Hive Queries
• Analyze large amounts of data sets writing PySpark scripts and Hive queries.
• Worked on data extraction, aggregation and analysis in HDFS by using PySpark and store teh data needed to Hive
• Validating teh completeness, integrity and accuracy of data across various systems.
• Integrated teh Automated script on to teh existing CICD flow through Jenkins / Looper from GIT Hub repository.
• Has regular interaction with business users for any clarifications with respect to domain.
• Has led teh offshore team in driving teh project activities from onsite.
• Identify teh process gaps by analyzing data from Jira and Confluence tools to understand teh gaps and dash boarding them and provide alternate ways of working to project team.

Confidential, Bentonville, AR

Lead Engineer

Environment: Hadoop 2.5.0, HiveQL, UNIX

Test tools: JIRA v6.4.14, HPALM 12

Responsibilities:

• Analyze and understand source to target mapping requirements and be able to translate those requirements into written test plans, detailed test cases and complex Hive queries as part of test scenarios.
• Building HIVE queries to validate teh data completeness and data quality against teh aggregated data in teh target table.
• Involved in creation of hive tables, loading teh structured / unstructured data from teh files using HDFS commands.
• Interacted with business users for any clarifications with respect to domain and incorporated teh related scenarios in testing.
• Has led teh offshore QA team in driving teh testing activities from onsite and assisting teh team in understanding on each User stories.
• Preparation of Test script comprising both positive and negative test scenarios.
• Involved in peer review of test deliverables within teh team and has arranged review meetings with other teams such as Dev/UAT team etc.
• Validating teh completeness, integrity and accuracy of data across various systems.
• Preparation of test reports and metrics based on execution and defect process and responsible for sending teh daily and weekly status reports to teh client and project managers within Wipro.
• Ensured that design and execution of test cases and defect management are maintained through JIRA.
• Ensured that teh test cases are linked to teh respective user stories in JIRA in compliance to Agile Methodology.

Confidential

ETL Test Lead

Environment: Teradata, Datastage 8.5, UNIX

Test tools: ETL Testing, Quality Center 11.0

Responsibilities:

• Analyze and understand ETL mapping requirements and be able to translate those requirements into written test plans, detailed test cases and complex test SQL scripts.
• Has played teh Lead role for a team size of 15 working @ Wipro ODC and has provided direction and support to QA team members with respect to testing activities co-ordinating with team lead @Client (Target India).
• Interacted with business users for any clarifications with respect to domain and incorporated teh related scenarios in ETL testing.
• Has led teh team in driving teh assigned track and as a senior test analyst has involved in core test activities.
• Preparation of Traceability Matrix with respect to functional requirement.
• Preparation of Test script comprising both positive and negative test scenarios.
• Create and Execute Test cases for Functional and System Testing and maintain teh test results in Quality Center.
• Involved in peer review of test deliverables within teh team and has arranged review meetings with other teams such as domain, UAT team etc.
• Validating teh completeness, integrity and accuracy of data across various systems.
• Preparation of test reports and metrics based on execution and defect process and responsible for sending teh daily and weekly status reports to teh client and project managers within Wipro.
• Has participated and ensure teh participation of other team members in status meetings arranged by teh client and has been responsible in providing detailed information.
• Ensure that defect logging and tracking is maintained through Quality Center.
• Ensure that testing activities are followed in accordance with project plan and customers quality process.
• Has supported teh UAT team with respect to data load and data mock up activities.

Confidential

Senior ETL Tester

Environment: Oracle 10g, UNIX

Responsibilities:

• Regular interaction with onsite developers in relation with understanding teh requirement.
• Involved in providing teh time estimation for teh client specific project.
• Involved in teh preparation of Test plan with Testing scope and approach.
• Preparation of Traceability Matrix with respect to functional requirement.
• Preparation of Test script comprising both positive and negative test scenarios.
• Executed Test cases for Functional and System Testing.
• Involved in validation of processing of data load to ODS, Data Mart and NP systems.
• Ensuring teh data flow is accurate across various systems.
• Validating teh completeness, integrity and accuracy of data in ODS and Data Mart systems.
• Bug allocation and tracking through Defect Tracking tool JIRA.
• Performed Performance and Regression testing.
• Attainment of teh noledge over teh assigned module thro’ KT.
• Identification of Test requirements by exploring SRS and HLDs of teh respective module.
• Performed Integration Testing.
• Executed Test cases for Functional and System Testing.
• Bug allocation and tracking.
• Used to take follow up about teh status of teh module from teh other Team members.
• Attending teh status meeting twice in a week.
• Performed Impact and regression testing.