Badges
Certifications
amarkadam00 has not earned any certificates yet.
Work Experience
DWH/BI Test Engineer
AMDOCS• January 2019 - Present
Experienced DWH/BI Test Engineer with demonstrated history of working in IT industry. Skilled in python ,Tearadata, MySQL & Oracle , ETL Testing and Data warehousing, Hadoop, HDFS, Hive, Sqoop. Experience working on windows and Unix platform. Roles and Responsibilities: Create test plan, create test case scenarios, test cases, execute test cases and exceptionally document the process to perform System testing of the application. Work with development team to deploy and test new Hadoop environments and expand existing Hadoop clusters. Ingest the data from various data sources (Files, RDBMS) to HDFS Gold using Ingestion Framework or Sqoop. Create and execute Hive queries which help to analyze the data ingested in HDFS Stage & Gold. Load large sets of structured, semi structured and unstructured data. Test & validated data at all stages of Hadoop testing. Extract generation & validation. Execution of test cases in TDP & Defect tracking. Create and execute Unix commands which help to validate data against source files. Run TWS jobs to load data into datalake. Automate repeated tasks (Null validation, Duplicate validation, Data validation for plain Ingestion, creation of mock data for purge job analysis etc.) Tool Used : Agile Craft, SQL Developer, Putty, TDP Hadoop/Big Data : Hive, HDFS, Spark, Sqoop, Ingestion Framework
System Engineer
Tata Consultancy Services Ltd• July 2016 - January 2019
Experienced DWH/BI Test Engineer with demonstrated history of working in IT industry. Skilled in python ,Tearadata, MySQL & Oracle , ETL Testing and Data warehousing, Hadoop, HDFS, Hive, Sqoop. Experience working on windows and Unix platform. Roles and Responsibilities: Develop/Modify Source to Target mappings. Designing and Executing test cases for end to end testing. Interact with developers and discussed technical problems, Bugs Trackingand Generating Reports. Reporting the Regular status to the higher authorities in a timely manner. Verifying files are generated in Unix box. Verifying Informatica job are running or not. Running Mapping and Session in Informatica if require. Involved in smoke Testing/Sanity Testing, Regression Testing, Source to target testing, Data validation testing. Writing simple/complex SQL queries for validation. Review the database objects (Tables, Core Views, Application Views, Procedures etc.) Involved in object migration process (Application only). Writing python scripts for generating analytical reports. Generating test suits for blast test (Python/Perl). Running Blast tests for checking performance of servers/ performance review. Tool Used : Teradata SQL Assistant, Informatica/OpsConsole , JIRA Roles : Developer CBO/ AppDBA
Education
Shivaji University
Computer Science & Engineering, B.Tech• August 2012 - May 2016
2019 pass out with 8.20 CPI.
Links
Skills
amarkadam00 has not updated skills details yet.