Ashok Kumar Sahu Email & Phone Number

Toronto, On, Ca

Toronto, On, Ca

India

Role: SDET/ETLLead a Team of 5 members.Vivid experience in End-End Release process such Release Planning, Scheduling, defining release strategies, maintaining release documentation as Release-Coordinator.Launching Amazon EC2 Cloud Instances utilizing Amazon Web Services (Linux/Ubuntu) and Configuring propelled examples as for particular applicationsSetup and build AWS infrastructure with various resources like VPC, EC2, S3, IAM, EBS, Security Group, Auto Scaling.Release Engineer for End-to-End process deploying to Production.Developed ETL test scripts based on technical specifications/Data design documents.Prepared Test plan and Testing strategies for Data Warehousing Application.Validating the data sources by performing data count check, removing duplicate data, verifying that the table and column data types meet specifications of data model.Design ETL mapping scenarios, create SQL scripts and define transformation Rules and validating mapping document.Applied Transformation logic before loading data ensuring the data is transformed to match the schema of target warehouse and validating data threshold , record count check.Performed a record count check before and after the data is loaded from staging to target data warehouse.Maintained Pre-Release summary notes, SQL/ENV Configuration changes note & post release notes.Identified and resolved release blockers, working closely with development & QA to ensure timely release.Configured Jenkins (CI/CD) with Slack to send the notification/alert to stake holders.Configured Jenkins to perform Execution summary report post release.

Pune, Maharashtra, India

Role: Cloud EngineerBuilt and configured automated CI/CD pipeline in various environment such as Jenkins, GIT, Docker, Maven.Configured GIT as source code repository and managed Branches ,Tags for each release and merged branches after code freezes.Developed Terraform templates to create VPC, subnets, NAT instances to ensure successful deployment of web applications and database templates.Created required IAAS in AWS and pipelines in DEV, TEST, STAGE and PRODUCTION.Using Kubernetes as orchestration tool, managing podsCompetence in designing AWS cloud automating infrastructure in AWS using amazon Web Services and configuring EC2 instances ,Route 53,ELB.Involved in designing and deploying multitude applications and AWs solutions like security group, Elastic load balancer, Auto Scaling and RDS.Automated backups of ephemeral data-stores to S3 buckets, EBS and Create AMI's for mission critical production servers as backups.Monitored resources and applications using AWS CloudWatch including creating alarms to monitor metrics such as EBS, EC2, ELB, RDS, S3 and configured notifications for alarms generated based on events defined.

Pune, Maharashtra, India

Role: ETL TesterResponsible for creating test cases, test plans, test data ensuring accurate coverage of requirements and business processes.Involved in ETL(Extract, Transform, Load) process testing using Informatica ETL tool.Involved in writing SQL queries and Database Checkpoints to verify data quality and calculations.Worked with data analyst to implement Informatica mappings and workflows.Wrote complex queries to compare the counts and data from Source to target.Performed database testing to verify back-end database transactions.Tested a number of complex ETL mappings, mapplets and reusable transformation for daily data loads.Validated the data of reports by developing SQL queries in SQL Developer against Data Mart tables.Involved in user training sessions and assisting in UAT(User Acceptance Testing).Worked with ETL groups for understanding mappings for Dimensions and Facts.Extracted data from various sources like Oracle, flat files, SQL serverWorked on issues with migration from development to testing.Compare SQL results with application results by writing SQL QueriesExposure to various types of Testing incl. Smoke, Functional, Integration, System Testing, Compatibility, Usability, Accessibility, regression, globalization, defect life cycle.Worked on projects operating on Scrum (Agile) model.Optimized test cases to maximize success of manual software testing