Pooja R
Bengaluru
Summary
ETL / SQL Developer with over 5+ years of experience, including 3 years in Informatica and 3 years in SAP BODS. Strong background in data integration, ETL development, and SQL-based data processing across enterprise data warehouse environments. Experienced in designing, developing, and optimizing end-to-end ETL pipelines, data mappings, workflows, and schedules to ensure high data quality and performance. Proficient in SQL, performance tuning, data validation, and troubleshooting complex data issues.Proven ability to collaborate with business and technical teams to deliver reliable, scalable data solutions, within tight deadlines..
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Software Engineer
6D Technologies
07.2024 - 11.2025
- Developed ETL processes using Informatica for efficient data extraction, transformation, and loading.
- Collaborated with business users to define requirements for data integration initiatives.
- Designed data mapping specifications to ensure accuracy and consistency of data.
- Created mappings, sessions, and workflows for data movement from source to target systems using Informatica PowerCenter.
- Provided production support for all ETL-related issues associated with Informatica PowerCenter.
- Migrated codebase from lower version of Informatica to higher version, improving performance.
- Engaged with Business Analysts and End Users to gather requirements and deliver technical solutions during design phase.
- Mentored junior engineers on best coding practices and methodologies.
ETL/SQL Developer / Consultant
Capgemini Technology Services India Ltd
06.2021 - 07.2024
- Proficient in ETL (Extract, Transform, Load) processes and tools, such as Informatica,SAP BODS and Talend.
- Proficient in SQL programming and database management - Skilled in writing complex SQL queries, stored procedures, and functions.
- Collaborated with cross-functional teams to gather requirements, design data models, and implement data warehouse solutions.
- Designed, built, tested, and maintained data integration / ETL processes. Spearheaded cross-functional efforts to improve data accessibility and quality, resulting in a 30% and 20% enhancement respectively.
- Excellent communication and collaboration skills for working in cross-functional teams and interacting with stakeholders.
- Familiarity with data modelling and data warehousing principles.
Data Analyst
News Technology Services
02.2019 - 06.2020
- Managed ETL workflows and data migration using Informatica Designer and SQL Server.
- Improved process performance by 60% through optimized data models and workflows.
- Supported real-time analytics for 4+ business units.
- Delivered reengineered processes for better data consistency and reporting accuracy.
Education
Bachelor of Engineering - Information Science
Cambridge Institute of Technology
Bengaluru08-2018
Skills
- Expertise in ETL tools: Informatica PowerCenter, SAP BODS
- Database - Oracle, SAP HANA, MySQL
- Cognos and Power BI visualization
- Proficiency in data integration
- Data structure modeling
- ETL solution development
- Data element mapping
- Performance enhancement
- Data integration
- Workflows and queries
- Data warehousing
- SQL programming
Certification
- - Microsoft Azure SQL – Coursera
- - Advanced MySQL – Coursera
- - Data Engineering Basics – Coursera
- - Power BI Dashboards – IBM
- - Data Science Program – ExcelR Solutions
Awards & Recognition
- “Rising Star” award at Capgemini for outstanding performance within 3 months
- Client Appreciation Awards for exceptional delivery and issue resolution
- Onsite Experience for QA and Testing (2023)
- Spot Awards for proactive problem-solving from project managers
Projects
Data integration and migration
- Migrated customer and subscriber data from legacy systems to a centralized SQL platform.
- Built data mapping documents, and performed ETL using custom SQL scripts
- Optimized bulk insert operations for millions of records with minimal downtime.
- ETL Workflow Automation (Talend + SAP BODS).
- Designed end-to-end ETL pipelines for staged-to-warehouse transitions.
- Ensured accurate extraction from source systems using Informatica.
- Created reusable components for data transformation and quality checks.
Timeline
Senior Software Engineer
6D Technologies
07.2024 - 11.2025
ETL/SQL Developer / Consultant
Capgemini Technology Services India Ltd
06.2021 - 07.2024
Data Analyst
News Technology Services
02.2019 - 06.2020
Bachelor of Engineering - Information Science
Cambridge Institute of Technology