Karthik Hulkoti

Environment:

Datawharehouse, HDFS,Hive,Sqoop,Gerrit,Jekins,Shell,Teradata,Python, Agile,Scrum Model ,Tidal scheduling tool, PL/SQL,Jekins,Gerrit, Jira , OBBIE and Tableau reporting tool.Data Analysis,Business system Analysis ,Data profiling, Data governance

Responsibilities:

• Analyzed Business Requirements ,Rules and work with Business Analysts and Users in designing Data flow mapping ,test plan and business solutions related to ETL logic needed to load heterogeneous data from various source system of bank
• Providing QA estimates for all Test deliverables, review Business requirement and technical specification document
• Working in Agile development life cycle and follow Test driven iterative development
• Attend sprint-planning sessions- Prioritize story(work), daily stand ups and provide estimate story for preparing QA scripts, test cases, test execution and Product Owner review
• Create Test Strategy, Test optimization, effort distribution in agile environment, facilitate review of strategy and secures approvals from appropriate stakeholders for all QE activities, analyzing data gaps
• Actively collaborating with developers and business stakeholders to clarify requirements, especially in terms of testability, consistency, and completeness
• Develop UDFs to encrypt and decrypt customer personal information for protecting personal information
• Generate and Validated reports and data in Tableau using aggregated data to give visual representation
• Develop automated and manual SQL test scripts to test ETL loads, data aggregations, data conversions , data extracts and Datawarehouse and Slowly changing dimension(SCD) types
• Preparing complex SQL & PL/SQL scripts for data validation in Oracle, Teradata and other databases and automate the count and mapping test for various schemas and tables across the database
• Build and maintain CICD automation framework to automate all test cases used to validate Data in file and table
• Prepare test scenarios/test cases based on acceptance criteria and review with product owner
• Prepare test data for different test scenarios/business rules
• Validate regulatory reports like EU LCR,US LCR ,FR2052a,ILST and CORRE as part of federal regulatory submissions which had complex business rules
• Design of Automation scripts for Sanity, Smoke and Regression tests using Unix shell scripting ,python programming and Jenkins to create builds to setup automation framework
• Sqooping data from Oracle database and other source files into Hive and Oracle tables using shell scripts and HDFS commands
• Record and track all defects identified during testing phase any cycle back with core development team for any fix/fine-tuning
• Develop defect Matrix Report for various project stakeholders and teams
• Perform business system analysis ,Data analysis ,root cause analysis and recovery method From major/critical system issues and provide impact analysis report to business and Dev team as and when required
• Perform validation of report on OBIEE and Tableau Dashboards ,data quality checks and
• KPI’s( Key process indicators) using SQL and PL/SQL scripts
• Identifying Automation scope with in project and propose feasible automation frame work
• Develop Mapping logic ,Health check solution for data elements to make sure data profiling and data quality is not breached
• Using knowledge of Metadata and Star and snowflake schemas ,setup scripts to create test source tables and data in support of testing loading of Staging area ,Fact and Dimension tables in Target Datawarehouse
• Setup and Launch unix scripts to trigger Batch jobs to load Target tables through backend
• Produce reports that are clear,effective ,insightful and traceable-whether for defect discovered during test or non-compliance issues found during process review or audit .Utilize existing tracking systems,report mechanisms ,agreed conventions ,and metrics when preparing and providing such reports.

Environment:

• Datawharehouse,Bigdataecosystem,GoogleCloudplatform(GCP),HDFS,Hive,Sqoop,Gerrit,Jekins,Shell,Teradata,Python,Spark,Agile, Scrum Model ,Tidal scheduling tool,PL/SQL,Jekins,Gerrit, Jira , OBBIE and Tableau reporting tool

Responsibilities:

• Analyzed Business Requirements and Rules and work with Business Analysts and
• Business Users in preparing Test Plan
• Providing QA estimates for all Test deliverables
• Working in Agile development life cycle and follow Test driven iterative development
• Attend sprint-planning sessions- Prioritize story(work), estimate story for preparing QA scripts, test cases, test execution and Product Owner review
• Attend daily stand ups and update scrum team about previously done tasks and also next tasks planned to do
• Create Test Strategy, Test optimization, effort distribution in agile environment, facilitates review of strategy and secures approvals from appropriate stakeholders for all QE activities
• Actively collaborating with developers and business stakeholders to clarify requirements, especially in terms of testability, consistency, and completeness
• Measuring and reporting test coverage across all applicable coverage dimensions
• Process Demand,Verified data and Offers to analyze various Loyalty and Kohls charge program using Spark
• Implement incremental model for multiple databases to ingest data from GCP
• Mysql,Teradata to GCP big data bucket using sqoop
• Devlop UDFs to encrypt and decrypt customer personal information for protecting personal information
• Generate and Validate reports and data in Tableau using aggregated data to give visual representation
• Migrate and validate aggregated data from Hive to BigQuery for faster query responses for business teams
• Analyze and fix code optimize flows to avoid long processing and wastage of cluster resources
• Perform tableau report validation as part of Tableau version upgrade also created test automation suite using BI validator tool
• Analyze YARN to understand major blockages
• Worked on GCP Devops ,Security Developers to fix environmental issues and integrate projects into GCP environment
• Build and maintain CICD automation framework to automate all test cases used to validate Data
• Prepare test scenarios/test cases based on acceptance criteria and review with product owner
• Prepare test data for different test scenarios/business rules and manage it in google cloud/Teradata database environment
• Preparing complex SQL and HQL scripts for data validation in hive, Oracle and other databases
• Validate regulatory reports like EU LCR,US LCR ,5G and CORRE as part of federal regulatory submissions
• Perform Integration, System, Regression testing, UAT and Deployment Support for implementations of various Business requirements
• Sqooping data from Oracle database and other source files into Hive tables
• Perform Integration, System, Regression testing, UAT and Deployment Support for implementations of various Business requirements
• Record and track all defects identified during testing phase any cycle back with core development team for any fix/fine-tuning
• QA artifacts preparation from Master Test Plan (Contains overall Testing Activities and testing strategy to be covered) till Test Closure Summary
• Preparing daily status, defect reports and reviewing them with stake holders
• Provide root cause analysis and recovery method from major/critical system issues
• Perform business system analysis and provide impact analysis report to business and Dev team as and when required
• Perform validation of report on OBIEE and Tableau Dashboards
• Perform validation of data quality checks and KPI’s( Key process indicators) using SQL and PL/SQL scripts
• Identifying Automation scope with in project and propose feasible automation frame work
• Implement and maintain CICD automation framework using Jenkins for Devops
• Maintain Jenkins build executed jobs and represent same when customer requests it
• Implementation and validation of semi structured data formats like XML and Json
• Maintaining code versioning using GitHub, Gerrit and Jenkins
• Prepare POC’s (Proof of concept) to demonstrate advantage of new technologies and to propose more creative and better solutions to business needs.

Environment:

Teradata SQL Assistant, Informatica, Toad SQL assist, Oracle and TeradataDB.TWS scheduling tool,PL/SQL,Unix shell scripting , Perl programming

Responsibilities:

• Requirement Gathering and liaising between Business and Project team
• Actively collaborating with developers and business stakeholders to clarify requirements, especially in terms of testability, consistency, and completeness
• Providing QA estimates for all Test deliverables
• Prepare test scenarios/test cases based on acceptance criteria and review with product owner
• Prepare test data for different test scenarios/business rules and manage it in google cloud/Teradata database environment
• Data Loading in Target tables using ETL Tool Informatica
• Creating complex SQL scripts to be executed on Teradata SQL Assistant and doing a source to target validation
• Analyzed Business Requirements and Rules and worked with Business Analysts and
• Business Users in preparing Test Plan & Test Design
• Providing test plan , test case & result walkthrough to all Business users ,stakeholders and Product owner to sign-off testing
• Executing stored procedures for testing PL/SQL codes for various stages of data load to data DW and data mart
• Involved in extensive DATA validation using SQL queries and back-end testing
• Communicating with Dev, BA’s , Project manager regularly and ensuring project deliverables are on Track
• Onsite & offshore QA Team co-ordination
• Managing all QA activities like test planning , requirement gathering ,release management ,test execution and managing defects in ALM and quality center
• QA artifacts preparation from Master Test Plan (Contains overall Testing Activities and testing strategy to be covered) till Test Closure Summary
• Extracting Data from Heterogeneous Sources and processing them to staging layer,Work tables and Target tables
• Loading data into tables using TWS (Tivoli workload Scheduler) and Control-m scheduling tool
• Validating data by applying all business rules and processing data till BASE layer
• Creating SQL scripts to be executed on Teradata SQL Assistant and doing source to target validation
• Validating CDC logic correctness on target tables
• Optimizing/Tuning several complex SQL queries for better performance
• Keeping track of defects in ALM in HP ALM and QC, working with dev & BA team to resolve issues faster in order to unblock testing activities
• Communicating with Dev
• Leads, BA’s , Project manager, offshore team and onshore regularly and ensuring project deliverables are on Track
• Measuring and reporting test coverage across all applicable coverage dimensions
• Preparing daily status, defect reports and reviewing them with stake holders
• Perform Unit, Integration, System, Regression, End-to-End Testing(Manual &
• Automated)
• Automate file validation and file to table comparison using shell scripting and perl
• Scripting.