Avinash C Email & Phone Number

Illinois, United States

Designed and developed of ETL processes and data integration solutions using Java, Spring Batch, and Apache Camel frameworks. Develop and maintain ETL jobs for data extraction, transformation, and loading from various source systems to target databases using tools such as Informatica, Talend, and Apache NiFi. Optimize ETL workflows and performance by tuning SQL queries, implementing parallel processing, and optimizing data transformation logic. Designed and implemented data quality checks and error handling mechanisms to ensure the accuracy and reliability of ETL processes. Work closely with database administrators and infrastructure teams to troubleshoot performance issues and optimize database configurations for ETL processing. Implement best practices for version control, code management, and deployment automation using tools such as Git, Jenkins, and Docker. Collaborate with business stakeholders and data analysts to understand data requirements and design efficient data integration processes. Develop custom ETL scripts and programs using Java, SQL, and scripting languages to extract, transform, and load data from various source systems into data warehouses and data lakes. Optimize ETL workflows and processes to improve performance, scalability, and reliability of data integration jobs. Designed and developed ETL workflows and data pipelines using Java, Spring Batch, and Apache Camel to integrate data from disparate sources into a centralized data warehouse. Knowledge of Java, JavaScript, or Python can be beneficial, especially for complex transformations or integrating Pentaho with other systems. Implemented RESTful Web services in Service Oriented Architecture (SOA) to retrieve data from client side and made REST API calls from AngularJS and parsed the data to client and handled the security and Authorization using Spring Security and OAuth2authentication protocol respectively.

Washington, United States

 Designed and developed of ETL processes using Java and ETL tools such as Informatica, Talend, and Apache NiFi to extract, transform, and load data from heterogeneous sources into data warehouses. Collaborate with business analysts and stakeholders to gather and analyze requirements, and design scalable and efficient data integration solutions. Develop custom Java components and scripts to implement complex data transformations and business logic as part of ETL workflows. Assisted in the migration of ETL jobs and processes to new environments and platforms. Documented ETL workflows, data mappings, and transformation rules for reference and future maintenance. Collaborated with cross-functional teams to troubleshoot and resolve issues related to data integration and ensuring smooth operation of ETL workflows. Collaborated with cross-functional teams to troubleshoot and resolve issues related to data loading, transformation, and integration, ensuring smooth operation of ETL workflows. Optimize ETL processes for performance and scalability, utilizing techniques such as parallel processing and partitioning.Experience in data analysis, data modeling and database management with specialization in analyzing complex data sets,providing actionable insight, driving business growth. Skilled in programming, data extraction, data manipulation, and data visualization.ETL developer with Pentaho expertise is a journey of building a solid foundation in data handling principles, mastering a suite of specific tools, and continually adapting to the evolving data ecosystem. With the right mix of technical skills,certifications, and real-world experience, you can carve out a successful career path in this field.

Hyderabad, Telangana, India

 Responsible for understand the User Requirements, Functional Specifications and System Design Specifications of theProject. Developed Java applications and web services using frameworks such as Spring Boot, Hibernate, and Apache Struts. Designed and implemented RESTful APIs for data access and integration with third-party systems. Participated in code reviews and collaborated with QA engineers to ensure the quality and reliability of softwareapplications. Worked closely with business analysts and product owners to understand requirements and translate them into technicalsolutions. Developed the major Front-end modules for the application using Java Script, HTML and CSS. Used JPA mapping techniques such as One to One, Many to One and Many to Many mappings to represent relationbetween various entities in the project. Configured and used JBoss application server for creating Data source and enabling JNDI for beans and database lookups.Deployed components on JBoss and Web Sphere application server. Developed codes for Action Servlet, Request Processor and Action classes by extending Struts package. Prepared and Executed JUNIT Test Cases as per system requirements. Fixed the bugs which are identified in the TestPhase. Used spring framework and J2EE components to develop Action classes, backend processes, complex reports anddatabase interaction, Configured and worked with Apache Tomcat Server. Used Collection Framework features like Map, Object, List to retrieve the data from Web Service, manipulate the data toincorporate Business Logic and save the data to Oracle database. Used Multithreading to simultaneously process tables as and when a specific user data is completed in one table.

Hyderabad, Telangana, India

 Application and developed cross browser and multi browser compatible web pages using HTML5, CSS3, Ajax,JSON, JavaScript, ECMA Script, TypeScript, and Bootstrap. Worked on React JS Virtual DOM and React Views, using components which contain custom HTML tags Built dynamic web pages using the React JS framework. Used ReactJS components, Forms, Events, Keys, Router, Animations and Flux concept. Used React-Router to turn application into Single Page Application. Used advanced Java 1.8 features like Lambda expressions for array operations, collections, and enhanced concurrency methods etc., throughout the application for well-defined programming. Implemented Microservices architecture using Spring Boot for making application smaller and independent. Used Spring IOC for object instantiation, resource lookup. Monitored service health check from Spring Boot admin console using Swagger UI registered Microservices. Proficient in Core Java Design Patterns like Singleton, Proxy, Factory.  Build the services utilizing the Pivotal Cloud Foundry (PCF) as a platform as a service for RESTful services.  Designed and developed Microservices business components and RESTful service endpoints using Spring boot. Responsible for maintaining and expanding AWS (Cloud Services) infrastructure using AWS Stack especially worked with database setup and maintenance and created AWS EC2 instances. Migrated database from EC2 to RDS using AWS Data Migration Service (DMS). Developed AWS Lambda based Microservices interacting with DynamoDB & SNS/SQS using AWS-SDK.  Created advice to define aspects and its functionality using Spring AOP support Used expertise in J2EE Patterns, including MVC, DAO, POJO, Business Delegate.  Used Spring data JPA to communicate with PostgreSQL & DynamoDB (NoSQL). Extensively used Hibernate Query Language (HQL)  Wrote complex HQL queries for data retrieval and manipulation. Optimizing HQL queries for performance improvements.