HARIKA VOOTKURI
ETL Developer
Nalgonda
Summary
Results-driven ETL expert specializing in data integration, transformation, and loading processes, with a proven track record of delivering high-quality, scalable solutions through effective teamwork. Proficient in SQL, data warehousing, and various ETL tools, ensuring seamless data flow and optimal performance. Recognized for adaptability and the ability to achieve consistent results in fast-paced environments. Committed to leveraging technical expertise to drive data-driven decision-making and enhance organizational efficiency.
Overview
6
6
years of professional experience
1
1
Certification
Work History
ETL Developer
Capgemini
06.2021 - Current
- Worked on the development, customization, and maintenance of business applications, ensuring smooth operations and alignment with business requirements.
- Developed and optimized ETL pipelines using Informatica Cloud (IICS), enabling seamless extraction, transformation, and loading of data from Netezza, Oracle, SQL Server, and flat files.
- Managed end-to-end ETL processes for large-scale data warehouses, including implementation, administration, and ongoing support to ensure data integrity and availability.
- Collaborated with cross-functional teams to define data requirements, resulting in accurate and timely delivery of business-critical data.
- Streamlined data extraction, transformation, and loading for improved overall system performance.
- Provided support during production deployments by troubleshooting issues and ensuring seamless transitions between environments.
- Optimized performance by identifying bottlenecks in ETL processes and implementing solutions to resolve them.
- Developed mappings, workflows and tasks using .
- Proactively identified potential risks within projects, taking necessary steps to mitigate them before they became critical issues.
- Conducted data analysis, requirement gathering, and mapping for ETL processes to translate business needs into technical solutions.
- Tuned ETL mappings, sessions, and SQL queries to resolve performance bottlenecks, improving pipeline efficiency and reliability.
- Built complex SQL queries, unions, joins, and views to support reporting and analytics requirements.
- Automated workflows using UNIX shell scripting, reducing manual effort and streamlining data processes.
- CLIENTS | PROJECTS:
- Boehringer Ingelheim | EOC:
- Boehringer Ingelheim is a global pharmaceutical company focused on research, development, and manufacturing of innovative healthcare solutions
- Have been part of end-to-end integration development between multiple data sources such as SQL Server, flat files, Veeva Vault, and Salesforce CRM using Informatica Cloud Application Integration (CAI).
- Involved in requirement analysis, process design, and implementation of integrations that enable smooth and automated data exchange between cloud and on-premise systems.
- Built and configured Service Connectors in CAI to securely communicate with external REST and SOAP APIs for systems like Veeva Vault and Salesforce CRM.
- Developed and tested real-time and batch workflows to synchronize data across multiple environments, ensuring data consistency and accuracy.
- Configured error handling, logging, and retry mechanisms to manage failed transactions, ensuring high availability and reliability of integration processes.
- Participated in process debugging and performance tuning, identifying root causes of failures and improving process efficiency.
- Worked with data and application teams to analyze business requirements and translate them into functional integration solutions within CAI.
- Collaborated in creating documentation and process flow diagrams, and supported UAT and production deployment activities.
- Supported integration of CAI with CDI (Cloud Data Integration) for scenarios that required both API and data pipeline orchestration.
- VOLVO | MOBIL:
- Volvo is a global leader in automotive and heavy machinery manufacturing, known for its focus on safety, quality, and sustainable innovation
- Executed end-to-end migration from Informatica PowerCenter to Informatica Cloud (IICS) and database migration from Netezza to Azure Synapse Analytics, developing optimized ETL workflows and ensuring seamless data integration for reporting and analytics.
- Analyzed and assessed existing Informatica PowerCenter mappings, workflows, and sessions to design a seamless migration strategy to Informatica Cloud (IICS).
- Rebuilt and optimized complex ETL workflows in IICS using transformations such as Router, Aggregator, Joiner, Expression, Lookup, and Sequence Generator for efficient data integration.
- Migrated database objects and data from Netezza to Azure Synapse Analytics, ensuring schema alignment, data consistency, and performance optimization throughout the migration process.
- Implemented parameterization in mappings, tasks, and connections to improve reusability, scalability, and environment flexibility.
- Performed System Integration Testing (SIT) and User Acceptance Testing (UAT) to verify data accuracy and ensure consistent results between PowerCenter and IICS environments.
- Implemented Pushdown Optimization (PDO) and partitioning strategies in Informatica Cloud (IICS) to enhance ETL performance and ensure efficient data processing
- Monitored and scheduled IICS taskflows to ensure accurate and timely data loads, leveraging IICS activity logs for proactive performance tracking.
- Diagnosed and resolved session failures, dependency issues, and performance bottlenecks using advanced debugging and optimization techniques.
- Collaborated with business and data engineering teams to enhance migrated workflows and incorporate new business logic using IICS Cloud Data Integration (CDI).
- Utilized UNIX shell scripts and SQL scripts to automate validation, pre/post-load checks, and batch executions across environments.
- Documented end-to-end migration procedures, scheduling processes, and post-deployment validations to support production and future enhancements.
- Kaji info tech | TCR:
- TCR is a US-based company that provides traffic control and equipment rental services. The project focused on improving database performance and optimizing SQL queries used in daily operations and reporting.
- Have been part of the SQL development and analysis team for performance optimization.
- Worked on understanding and analyzing existing SQL code, mainly focusing on nested loop queries.
- Supported in identifying performance bottlenecks and suggesting improvements in SQL logic.
- Assisted in testing, validation, and documentation of optimized SQL scripts.
SQL DEVELOPER
KAJI INFOTECH PVT LTD
10.2019 - 03.2020
- Worked on the development, customization, and maintenance of business applications, ensuring smooth operations and alignment with business requirements.
- Developed and optimized ETL pipelines using Informatica Cloud (IICS), enabling seamless extraction, transformation, and loading of data from Netezza, Oracle, SQL Server, and flat files.
- Managed end-to-end ETL processes for large-scale data warehouses, including implementation, administration, and ongoing support to ensure data integrity and availability.
- Designed data models using Star Schema and Snowflake modeling, creating FACT and Dimension tables with accurate logical and physical structures.
- Conducted data analysis, requirement gathering, and mapping for ETL processes to translate business needs into technical solutions.
- Tuned ETL mappings, sessions, and SQL queries to resolve performance bottlenecks, improving pipeline efficiency and reliability.
- Built complex SQL queries, unions, joins, and views to support reporting and analytics requirements.
- Automated workflows using UNIX shell scripting, reducing manual effort and streamlining data processes.
- CLIENTS | PROJECTS:
- Boehringer Ingelheim | EOC:
- Boehringer Ingelheim is a global pharmaceutical company focused on research, development, and manufacturing of innovative healthcare solutions
- Have been part of end-to-end integration development between multiple data sources such as SQL Server, flat files, Veeva Vault, and Salesforce CRM using Informatica Cloud Application Integration (CAI).
- Involved in requirement analysis, process design, and implementation of integrations that enable smooth and automated data exchange between cloud and on-premise systems.
- Built and configured Service Connectors in CAI to securely communicate with external REST and SOAP APIs for systems like Veeva Vault and Salesforce CRM.
- Developed and tested real-time and batch workflows to synchronize data across multiple environments, ensuring data consistency and accuracy.
- Configured error handling, logging, and retry mechanisms to manage failed transactions, ensuring high availability and reliability of integration processes.
- Participated in process debugging and performance tuning, identifying root causes of failures and improving process efficiency.
- Worked with data and application teams to analyze business requirements and translate them into functional integration solutions within CAI.
- Collaborated in creating documentation and process flow diagrams, and supported UAT and production deployment activities.
- Supported integration of CAI with CDI (Cloud Data Integration) for scenarios that required both API and data pipeline orchestration.
- VOLVO | MOBIL:
- Volvo is a global leader in automotive and heavy machinery manufacturing, known for its focus on safety, quality, and sustainable innovation
- Executed end-to-end migration from Informatica PowerCenter to Informatica Cloud (IICS) and database migration from Netezza to Azure Synapse Analytics, developing optimized ETL workflows and ensuring seamless data integration for reporting and analytics.
- Analyzed and assessed existing Informatica PowerCenter mappings, workflows, and sessions to design a seamless migration strategy to Informatica Cloud (IICS).
- Rebuilt and optimized complex ETL workflows in IICS using transformations such as Router, Aggregator, Joiner, Expression, Lookup, and Sequence Generator for efficient data integration.
- Migrated database objects and data from Netezza to Azure Synapse Analytics, ensuring schema alignment, data consistency, and performance optimization throughout the migration process.
- Implemented parameterization in mappings, tasks, and connections to improve reusability, scalability, and environment flexibility.
- Performed System Integration Testing (SIT) and User Acceptance Testing (UAT) to verify data accuracy and ensure consistent results between PowerCenter and IICS environments.
- Implemented Pushdown Optimization (PDO) and partitioning strategies in Informatica Cloud (IICS) to enhance ETL performance and ensure efficient data processing
- Monitored and scheduled IICS taskflows to ensure accurate and timely data loads, leveraging IICS activity logs for proactive performance tracking.
- Diagnosed and resolved session failures, dependency issues, and performance bottlenecks using advanced debugging and optimization techniques.
- Collaborated with business and data engineering teams to enhance migrated workflows and incorporate new business logic using IICS Cloud Data Integration (CDI).
- Utilized UNIX shell scripts and SQL scripts to automate validation, pre/post-load checks, and batch executions across environments.
- Documented end-to-end migration procedures, scheduling processes, and post-deployment validations to support production and future enhancements.
- Kaji info tech | TCR:
- TCR is a US-based company that provides traffic control and equipment rental services. The project focused on improving database performance and optimizing SQL queries used in daily operations and reporting.
- Have been part of the SQL development and analysis team for performance optimization.
- Worked on understanding and analyzing existing SQL code, mainly focusing on nested loop queries.
- Supported in identifying performance bottlenecks and suggesting improvements in SQL logic.
- Assisted in testing, validation, and documentation of optimized SQL scripts.
- Participated in requirement discussions and collaborated with senior developers to understand business logic and database design.
Education
B.TECH. - Electrical engineering
JNTUCEH
Hyderabad, India01-2017
Skills
LANGUAGES
Informatica Cloud
Informatica PowerCenter
ETL TOOL
SQL
Accomplishments
- Received Rising Star Award twice from Capgemini.
- Received XtraMile award from Capgemini.
Certification
IICS R-41R-32
Timeline
ETL Developer
Capgemini
06.2021 - Current
SQL DEVELOPER
KAJI INFOTECH PVT LTD
10.2019 - 03.2020
B.TECH. - Electrical engineering
JNTUCEH