Ashok Penmatsa
Toronto,ON
Summary
Experienced development professional knowledgeable about managing data extraction, transformation and loading. Hardworking team player with advanced skills in managing project design and implementation. Proficient in gathering requirements, reducing risk, and developing consistent standards.
Overview
6
6
years of professional experience
Work History
Lead QA Engineer
Blackbuck Insights
Bangalore, Karnataka, India
12.2021 - Current
- Conducted functional, regression, performance, integration and user acceptance testing.
- Developed test plans and strategies for QA testing.
- Participated in daily stand-up meetings to discuss progress on projects and tasks assigned.
- Identified and documented any defects found during the course of testing.
- Worked closely with development teams to ensure quality assurance standards were met throughout the project life cycle.
- Created detailed bug reports with steps to reproduce identified issues.
- Collaborated with developers to troubleshoot problems and resolve them in a timely manner.
- Reviewed requirements specifications for completeness and accuracy prior to beginning the QA process.
- Analyzed test results from multiple platforms to ensure consistent behavior across all devices.
- Investigated customer reported issues by reproducing bugs in staging environment.
- Evaluated existing systems for areas of improvement or optimization.
- Assisted in developing processes that would improve overall code quality.
- Conducted peer reviews of other team members' code prior to release into production environment.
Senior Data Engineer
Larson & Toubro
Bangalore, Karnataka, India
01.2021 - 12.2021
- Created ETL scripts to move and transform data from various sources into a centralized repository.
- Developed data pipelines to ingest and process large datasets.
- Integrated multiple heterogeneous sources into one unified source via ETL processes.
- Optimized existing queries in order to improve query performance and reduce the load on the server.
- Identified performance bottlenecks in existing mappings by analyzing session logs and modified them accordingly.
- Maintained version control system for all ETL objects using Informatica Repository Manager.
- Designed complex mappings involving multiple sources and targets with various transformations like Lookup, Joiner, Router, Aggregator, Expression.
- Implemented incremental loading of data by making use of different techniques like Update Strategy Transformation, CDC.
- Created reusable components like Mapplets, Reusable Transformations to improve the development process efficiency.
- Performed unit testing of mappings and troubleshoot mapping errors.
- Assisted junior developers in understanding business requirements and troubleshooting issues during development phase.
- Developed UNIX scripts for scheduling jobs on daily basis or specific time intervals as per requirement.
Senior Informatica Developer
Tata Consultancy Services
Bangalore, Karnataka, India
03.2018 - 01.2021
- Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
- Monitored loading jobs on daily basis to ensure that all ETL jobs are running as scheduled.
- Provided production support for all ETL related issues involving Informatica PowerCenter.
- Migrated existing code base from lower version of informatica to higher version.
- Identified data quality issues and worked with business users to resolve them in a timely manner.
- Assisted QA team by providing necessary information which is needed while performing Unit Testing activities.
- Worked closely with Business Analysts and End Users for gathering requirements and providing technical solutions during design phase .
- Implemented error handling logic for failed ETL loads using error log tables in Oracle Database or flat files generated by Informatica PowerCenter.
- Coordinated with DBA team for creating new databases, tablespace configurations, user accounts creation and privileges management, when required for development purpose or migration purpose across different environments .
- Configured session parameters such as commit intervals, buffer size, based on volume of data being processed through each mapping or workflow within an application environment utilizing Workflow Manager feature of Informatica PowerCenter 8.x and 9.x versions .
Education
Master of Science - Mobile Computing And Communications
University of Greenwich
London04-2011
Bachelor of Science - Electrical And Computer Engineering
SIET
INDIA03-2009
Skills
- Test Planning
- Regression Testing
- Project Requirement Evaluation
- Mapping Skills
- Error Handling Techniques
- Continuous Integration Systems
- Databases: Oracle, Teradata & PostgreSQL
- Analytical and Critical Thinking
Timeline
Lead QA Engineer
Blackbuck Insights
12.2021 - Current
Senior Data Engineer
Larson & Toubro
01.2021 - 12.2021
Senior Informatica Developer
Tata Consultancy Services
03.2018 - 01.2021
Master of Science - Mobile Computing And Communications
University of Greenwich
Bachelor of Science - Electrical And Computer Engineering
SIET
Similar Profiles
JAYAPRAKASH JJAYAPRAKASH J
Senior Test Engineer at Blackbuck Insights Pvt Ltd (BBI)Senior Test Engineer at Blackbuck Insights Pvt Ltd (BBI)
AKSHAY KINGEAKSHAY KINGE
Software Engineer at Blackbuck InsightsSoftware Engineer at Blackbuck Insights
Vaishnavi SureshVaishnavi Suresh
Consultant at Blackbuck InsightsConsultant at Blackbuck Insights
HARITHA VRHARITHA VR
Technical Manager/ Sr. SAFE Scrum Master at BlackBuck InsightsTechnical Manager/ Sr. SAFE Scrum Master at BlackBuck Insights
Agnes LubegaAgnes Lubega
Registered Nurse – Trauma Unit at Sunnybrook Health Sciences CentreRegistered Nurse – Trauma Unit at Sunnybrook Health Sciences Centre