Python & Oracle Developer

Role: Python & Oracle DeveloperLocation: Charlotte, NC- OnsiteDuration: Full TimeJD:Roles & Responsibilities· Design, develop, and maintain Oracle PL/SQL programs · Develop and optimize complex SQL queries · Build and maintain Python-based data processing pipelines · Work on data modeling and schema design · Troubleshoot and resolve: Job failures Data discrepancies Database performance issues · Implement performance tuning techniques Query optimization Indexing strategies · Develop ETL workflows and automation scripts · Ensure data integrity, consistency, and validation · Collaborate with Business analysts, Data architects, Upstream/downstream teams Technical/Functional Skills· Strong expertise in Oracle SQL & PL/SQL· Complex queries, joins, subqueries, Stored procedures, functions, packages· ER modeling, normalization/denormalization· Star/snowflake schema design· Data processing (Pandas, NumPy)· Database connectivity (cx_Oracle / SQLAlchemy)· ETL processes and data pipelines· Query optimization and performance tuning· Indexing, partitioning, and execution plans· Experience in data warehousing / BFSI domain (preferred)· Ability to translate business requirements into technical design· Strong analytical and problem-solving skills· Understanding of data validation and quality frameworks· Experience working in Agile / Scrum environments