Expert knowledge of data warehouse architecture
Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.
Analyze, Design, Develop and enhance ETL solutions/ data integration projects/ enhancements as assigned
Troubleshoot, debug and diagnose ETL/ BI data issues
Have the ability to work with users, BI and ERP teams to get ETL solutions debugged, developed and implemented
Performance tuning and enhancement of data loads, SQL and ETL processes and prepare related technical documentation
Maintain quality control, document technical specs and unit testing to ensure accuracy and quality of BI data
Provide support / triage prod issues within stipulated time frame/ SLAs
Provide production support related to ETL schedules, tasks and work with other BI/ IT team members and service desk to resolve data refresh issues
Robust Experience writing / tuning SQL statements




Robust experience with Oracle PL/ SQL Stored procedures
Strong experience with ADF and Devops / CI/ CD processes, preferably using Github
Well versed with database administration tasks and working with DBAs to monitor and resolve SQL / ETL issues and performance tuning
Robust experience developing software applications as part of a team, employing practical and effective software design concepts.
Experience in trouble shooting data warehouse refresh issues and BI reports data validation with source systems.
Preferred with experience working in the Oracle EBS ERP
Preferred experience in Cognos/ Power BI
Independent problems solving skills.
Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams and management.
Open to learn and acquire new skills.

📌 Senior Etl Developer Pune (India)
🏢 HITACHI SOLUTIONS
📍 India