Data Engineer + Python + SQL

Job Description

W issen Technology is Hiring for Data Engineer + Python + SQL About Wissen Technology: At Wissen Technology, we deliver niche, custom-built products that solve complex business challenges across industries worldwide. Founded in 2015, our core philosophy is built around a strong product engineering mindset?ensuring every solution is architected and delivered right the first time. Today, Wissen Technology has a global footprint with 2000+ employees across offices in the US, UK, UAE, India, and Australia. Our commitment to excellence translates into delivering 2X impact compared to traditional service providers. How do we achieve this? Through a combination of deep domain knowledge, cutting-edge technology expertise, and a relentless focus on quality. We don?t just meet expectations?we exceed them by ensuring faster time-to-market, reduced rework, and greater alignment with client objectives. We have a proven track record of building mission-critical systems across industries, including financial services, healthcare, retail, manufacturing, and more. Wissen stands apart through its unique delivery models. Our outcome-based projects ensure predictable costs and timelines, while our agile pods provide clients with the flexibility to adapt to their evolving business needs. Wissen leverages its thought leadership and technology prowess to drive superior business outcomes. Our success is powered by top-tier talent. Our mission is clear: to be the partner of choice for building world-class custom products that deliver exceptional impact?the first time, every time. Job Summary : Wissen Technology is hiring a Data Engineer with strong expertise in Python and SQL to design, develop, and optimize data pipelines and database processes for large-scale, performance-intensive applications. Experience: 8-16 Years Location: Mumbai / Pune Mode of Work : Full time Key Responsibilities: Develop, optimize, and maintain complex SQL queries, stored procedures, triggers, and packages (Oracle / SQL Server). Write high-quality PL/SQL code for performance-intensive applications. Perform query tuning using execution plan analysis, statistics review, and optimizer hints. Apply strong understanding of database internals ? indexing strategies, caching, buffer pools, memory management. Implement partitioning, sharding, and parallel query execution techniques for large datasets. Build and optimize ETL/ELT pipelines for large-scale batch and streaming data processing. Improve data ingestion, transformation, and consumption efficiency across systems. Collaborate with trading, finance, risk, and operations teams to ensure data quality and usability. Conduct detailed performance profiling using AWR, ASH, OEM, Query Store, and EXPLAIN PLAN. Identify system bottlenecks and implement tuning strategies across applications, databases, and pipelines. Execute load testing and benchmarking using Python, JMeter, or similar tools. Develop Python scripts and utilities for automation, performance testing, data validation, and pipeline orchestration. Integrate Python applications with databases, APIs, and internal systems. Requirements: Strong proficiency in SQL (Oracle / SQL Server). Advanced experience in PL/SQL for stored procedures, triggers, and packages. Solid Python programming experience. Hands-on experience with query tuning, execution plan analysis, and optimizer hints. Strong understanding of database internals (indexes, caching, buffer pools, memory management). Experience in performance profiling tools (AWR, ASH, OEM, EXPLAIN PLAN, Query Store). Familiarity with ETL/ELT pipeline optimization (batch vs. stream processing). Knowledge of partitioning, sharding, and parallel query execution strategies. Good To Have Sk ills: Experience with cloud platforms (AWS, Azure, GCP). Familiarity with containerization tools like Docker and orchestration using Kubernetes. Exposure to big data technologies and distribution systems. Wissen Sites: Website: www.wissen.com LinkedIn: https://www.linkedin.com/company/wissen-technology Wissen Leadership: https://www.wissen.com/company/leadership-team/ Wissen Live: https://www.linkedin.com/company/wissen-technology/posts/feedView=All Wissen Thought Leadership: https://www.wissen.com/articles/