Usha Thavarya Naik
Bangalore
Summary
Experienced and goal-oriented ETL Developer with over 8 years of experience in designing, developing, and maintaining data integration and data warehousing solutions using IBM Infosphere DataStage. Seeking to leverage strong expertise in ETL design, performance tuning, and automation to contribute to scalable data management and business intelligence initiatives in a dynamic organization.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Eng,Mgmt and Analyst
Accenture Solutions Pvt. Ltd.
Bangalore
12.2017 - Current
- Develop, support, and enhance ETL processes using IBM DataStage for the retail data warehouse.
- Design and build parallel and sequence jobs integrating data from multiple source systems.
- Create and manage job schedules in TWS Scheduler for end-to-end batch automation.
- Monitor, troubleshoot, and resolve ETL production issues ensuring SLA adherence.
- Participate in DataStage environment upgrades and collaborate with IBM for issue resolution.
- Develop UNIX shell scripts for pre- and post-ETL activities, validations, and file handling.
- Perform data quality checks and ensure accuracy of data across systems.
- Mentor new team members and lead knowledge transfer sessions.
- Work closely with business users and clients to understand data requirements and propose solutions.
- Proven experience supporting on-call and UK shift operations, managing Incidents, Problems, and Changes, and ensuring system stability, data reliability, and seamless service delivery across enterprise environments, including pharma projects.
Education
B.E - Electronics & Communication Engineering
SJCE
MysuruSkills
- ETL development
- Data integration
- Job scheduling
- Data quality assurance
- UNIX scripting
- Data analysis
Summary
IBM InfoSphere DataStage (Designer, Director, Operations Console), ETL Design, Development & Support, Oracle SQL / PL-SQL Development, UNIX Shell Scripting, TWS Job Scheduler (Tivoli Workload Scheduler), Data Warehousing Concepts (Star Schema, SCD, Fact & Dimension Tables), ETL Performance Tuning and Optimization, Data Validation and Reconciliation, Job Automation and Scheduling, Experienced and goal-oriented ETL Developer with over 8 years of experience in designing, developing, and maintaining data integration and data warehousing solutions using IBM InfoSphere DataStage. Seeking to leverage strong expertise in ETL design, performance tuning, and automation to contribute to scalable data management and business intelligence initiatives in a dynamic organization.
Projects Summary
- Retail Data Warehouse Enhancement, New Look - UK Retail Client, Designed and optimized ETL jobs using DataStage 11.7, processing large volumes of sales and inventory data. Improved ETL performance and automated several manual processes.
- DataStage Upgrade Initiative, Key contributor in test and production upgrade, coordinating with IBM for patch management, issue resolution, and validation.
- ETL Optimization & Monitoring, Reduced job run-times by tuning SQL queries, leveraging partitioning, and optimizing transformer logic to enhance performance.
Certification
Oracle Cloud Infrastructure 2025 AI Foundation Associate
Oracle Cloud Infrastructure Foundation Associate
IBM Infosphere DataStage (Company Learning)
Specialty Retail (Company Learning)
Business Process Management
Camunda BPM
Signavio Process
Oracle Cloud Infrastructure Foundation Associate
IBM Infosphere DataStage (Company Learning)
Specialty Retail (Company Learning)
Business Process Management
Camunda BPM
Signavio Process
Timeline
Data Eng,Mgmt and Analyst
Accenture Solutions Pvt. Ltd.
12.2017 - Current
B.E - Electronics & Communication Engineering
SJCE