K.Vijaya Kumar
Henrico,VA
Summary
Experienced Data Engineer with over 14 years of expertise in cloud computing, data warehousing, and ETL processes, having worked across leading platforms including AWS, GCP, Snowflake, Teradata, and Informatica. Adept at designing, developing, and optimizing data pipelines, integrating diverse data sources, and leveraging cloud technologies to drive data-driven decision-making. Skilled in building scalable and high-performance solutions, with a strong focus on data migration, transformation, and cloud data architecture. Proven ability to work across teams, delivering end-to-end data solutions in both on-premise and cloud environments.
Overview
14
14
years of professional experience
1
1
Certification
3
3
years of post-secondary education
Work History
Senior Data Engineer in EARL App
Carelon Global Solutions (Elevance Health)
02.2022 - 12.2024
- Designed and implemented data pipelines using Snowflake to support analytics and reporting for various business units, increasing data processing efficiency by 35%.
- Developed ETL processes in AWS Glue to automate data extraction and transformation from on-premise systems to AWS S3 for further analysis.
- Utilized AWS Lambda to automate data processing tasks and reduce latency by 20%.
- Implemented a data lake architecture using AWS S3 and AWS Glue to centralize data storage, improving accessibility and reporting capabilities for data teams.
- Created objects like Materialized Views, Views (Secured & Normal), Schemas and Databases, Task, Streams, Stored Procedures, UDF’s and managed users based on RBAC.
- Test integration of AWS Athena with Snowflake for querying data stored in S3, ensuring performance and accuracy in querying large datasets.
- Collaborated with stakeholders to build data models, dashboards, and reports, ensuring alignment with business goals.
Data Engineer in VBSR App
Carelon Global Solutions (Elevance Health)
01.2021 - 01.2022
- Work with Business Customers in understanding the business requirements and implementing solutions
- Automated data pipeline monitoring and error handling, reducing downtime and manual intervention by 50%.
- Developed and optimized ETL processes in AWS using AWS Glue, and S3 to extract, transform, and load data for analytics and reporting.
- Expertise in loading (Copy INTO) and creating the pipelines for bulk loading of data for batches.
- Optimized query performance on Snowflake, reducing execution time by 15% by fine-tuning schema and leveraging clustering.
- Developed custom data solutions using AWS Lambda to handle real-time data processing requirements.
- Optimized SQL queries in Snowflake, reducing job execution time by up to 30%.
- Collaborated with cross-functional teams to define requirements for new cloud-based data systems and led solution design and implementation.
- Perform user access control testing in Snowflake and AWS, validating that sensitive data is protected and only accessible by authorized users.
- Involved in testing to understand best possible ways to use the cloud resources.
Data Engineer in PCMS App
Carelon Global Solutions (Elevance Health)
01.2020 - 12.2020
- Collaborated with business stakeholders to understand requirements and defined the scope for migration.
- Conducted detailed analysis of the current Teradata environment to identify dependencies, performance bottlenecks, and optimization opportunities.
- Created a detailed migration plan outlining data extraction, transformation, validation, and loading (ETL) steps, ensuring minimal downtime during the migration process.
- Assisted in the migration of on-premise Teradata systems to the cloud database - Snowflake , resulting in a 40% reduction in infrastructure costs.
- Utilized AWS services like S3 (for data storage), Glue (for ETL), Redshift Spectrum (as a bridge for querying), and Lambda (for serverless processing).
- Configured AWS DMS (Database Migration Service) to migrate the schema and data from Teradata to Snowflake in parallel with minimal downtime.
- Led the development of ETL pipelines using AWS Glue and Snowflake's Snowpipe for continuous data ingestion.
- Ensured data transformation logic matched Teradata’s queries, adjusting for Snowflake's SQL syntax and performance considerations.
- Wrote optimized SQL queries and stored procedures in Snowflake for data manipulation.
- Led unit and integration testing to ensure data integrity between the legacy Teradata system and Snowflake.
- Used AWS tools like AWS CloudWatch for monitoring and alerting to ensure smooth migration with no performance degradation.
- Identified and resolved performance issues related to the migration process (e.g., query optimization, indexing, partitioning strategies).
- Implemented Snowflake-specific optimizations such as clustering keys, materialized views, and query optimization techniques.
- Provided post-migration support, including troubleshooting, user training, and documentation.
- Conducted knowledge transfer sessions to internal teams on Snowflake best practices, AWS architecture, and data modeling techniques.
Senior Developer in AEDW/ODS App
Tetrasoft India Pvt. Ltd (Elevance Health)
01.2018 - 11.2019
- Collaborate with data architects and business analysts to understand requirements and translate them into efficient database solutions.
- Write complex SQL queries and stored procedures to support ETL processes and data warehousing.
- Perform data integration and transformation tasks using Teradata utilities (BTEQ,FastLoad, MultiLoad, TPump).
- Implement query optimization techniques, including partitioning, indexing, and statistics collection to improve performance and reduce runtime.
- Lead the migration of legacy systems to Teradata, including data cleansing, transformation, and load processes.
- Provide regular performance reports and identify bottlenecks in data workflows.
- Conduct code reviews and optimize existing SQL scripts for better performance.
Software Engineer in AEDW App
Tetrasoft India Pvt. Ltd (Elevance Health)
06.2014 - 12.2017
- Provide end-to-end support for Teradata and Informatica environments, ensuring seamless data flow between systems.
- Analyzed and troubleshot failed ETL jobs by reviewing session logs, error logs, and system alerts to determine root causes.
- Work closely with the development team to resolve incidents, application errors, and data discrepancies within the Informatica workflows.
- Managed batch processing and job scheduling using tools like Informatica Workflow Manager and Teradata Workload Manager.
- Conduct root cause analysis for data-related issues, providing timely solutions and recommendations to improve the overall data integration process.
- Implemented performance tuning strategies that resulted in a 20% improvement in the overall speed of data loads.
- Ensure the integrity, reliability, and availability of data platforms through routine maintenance, patching, and upgrades.
- Provide ad-hoc troubleshooting and support for emergency data loads, data refreshes, and database issues, ensuring that business processes continue without interruptions.
- Maintain up-to-date documentation of configurations, processes, and troubleshooting steps.
- Participate in data migration, transformation, and extraction projects to support data-driven initiatives.
Associate Software Engineer in BI APP
Tetrasoft India Pvt. Ltd (Elevance Health)
04.2011 - 06.2014
- Provide 24/7 production support for Teradata and Informatica environments, ensuring smooth ETL processes and data integration workflows.
- Monitor and troubleshoot issues related to ETL jobs, Teradata load processes, and system performance.
- Coordinate with developers and business users to analyze and resolve data-related incidents, including system downtime, job failures, and performance bottlenecks.
- Perform root cause analysis (RCA) for failed jobs and work with cross-functional teams to implement corrective actions.
- Support the implementation of changes, upgrades, and patches for both Teradata and Informatica environments.
- Manage daily and weekly batch jobs, including monitoring the job flow, resolving failures, and coordinating with the scheduling team for reruns and recovery.
- Create and maintain documentation for production issues, solutions, and system configurations.
- Develop and implement automated scripts to streamline routine support tasks, such as log management and alert notifications.
Skills
- Cloud Platforms: AWS , Google Cloud Platform (GCP)
- Compute Services: Compute Engine, Kubernetes Engine, App Engine, Cloud Functions
- Storage & Databases: Snowflake, Teradata, Oracle, ASW S3, HDFS, BigQuery
- ETL Tools: AWS Glue, AWS Lambda, Informatica PowerCenter
- Networking: Virtual Private Cloud (VPC), Load Balancer, Cloud DNS, Cloud CDN
- DevOps & CI/CD: Terraform, Jenkins, GitHub/GitLab CI/CD, Cloud Build, Cloud Deployment Manager
- Containers & Orchestration: Kubernetes, Docker
- Monitoring & Logging: AWS cloudwatch, Teradata Viewpoint
- Scripting & Automation: Python, Bash, Terraform
- Security: IAM, VPC Service Controls, Cloud Identity, Cloud Key Management
- Scheduling Tools: WLM, ContrlM
- Operating Systems: Linux (Ubuntu) Windows
- Code Editors: Visual Studio Code
- Project Management Tools: Jira
Certification
- AWS solutions architect professional
- AWS solutions architect associate
- Snowflake SnowPro Core
- PINCE2 - Foundation and Practitioner
- ITIL v3
WORK EXPERIENCE
- Tetrasoft India Pvt Ltd - from 04/2011 to 05/2020
- Carelon Global Solutions India - from 05/2020 to 12/2024
Education
MCA from Acharya Nagarjuna University in 2008.
www.linkedin.com/in/vijaya-kumar-konduri
Education
MCA -
Acharya Nagarjuna University
06.2005 - 06.2008
Timeline
Senior Data Engineer in EARL App
Carelon Global Solutions (Elevance Health)
02.2022 - 12.2024
Data Engineer in VBSR App
Carelon Global Solutions (Elevance Health)
01.2021 - 01.2022
Data Engineer in PCMS App
Carelon Global Solutions (Elevance Health)
01.2020 - 12.2020
Senior Developer in AEDW/ODS App
Tetrasoft India Pvt. Ltd (Elevance Health)
01.2018 - 11.2019
Software Engineer in AEDW App
Tetrasoft India Pvt. Ltd (Elevance Health)
06.2014 - 12.2017
Associate Software Engineer in BI APP
Tetrasoft India Pvt. Ltd (Elevance Health)
04.2011 - 06.2014
MCA -
Acharya Nagarjuna University
06.2005 - 06.2008
Similar Profiles
Ahmed Abdul MuqueethAhmed Abdul Muqueeth
Lead Systems Analyst at Carelon Global Solutions, Elevance Health - USALead Systems Analyst at Carelon Global Solutions, Elevance Health - USA
Ronan Garcia, RNRonan Garcia, RN
Utilization Management Nurse (Nurse Medical Manage at Carelon Global Solutions (Elevance Health)Utilization Management Nurse (Nurse Medical Manage at Carelon Global Solutions (Elevance Health)
Satish PatidarSatish Patidar
Senior Business Analyst at Carelon Global Solutions India (Elevance Health)Senior Business Analyst at Carelon Global Solutions India (Elevance Health)
Sawyer DavisSawyer Davis
Teacher at Henrico County Public SchoolsTeacher at Henrico County Public Schools
Daron HodgesDaron Hodges
Assistant Manager/Sales Associate at Domino’s PizzaAssistant Manager/Sales Associate at Domino’s Pizza