Data Engineer

You will be responsible for: - Designing, developing, and optimizing complex SQL queries, stored procedures, and data models for Oracle-based systems - Creating and maintaining efficient data pipelines for extract, transform, and load (ETL) processes - Designing and implementing data quality controls and validation processes to ensure data integrity - Collaborating with cross-functional teams to understand business requirements and translate them into technical specifications - Establishing documentation standards and ensuring comprehensive system documentation - Leading troubleshooting efforts and resolving complex database performance issues - Designing and implementing integrations between Oracle systems and cloud services, particularly AWS S3 - Leading code reviews and establishing best practices for database development - Designing and implementing data migration strategies from legacy systems to modern cloud-based solutions - Working within an Agile framework, taking a leadership role in sprint planning and technical discussions Required Qualifications: - 4-12 years of experience with Oracle databases, including advanced SQL and PL/SQL development - Strong knowledge of data modeling principles and database design patterns - Proficiency with Python for data processing and automation - Extensive experience implementing and maintaining data quality controls - Proven ability to reverse engineer existing database schemas and understand complex data relationships - Strong experience with version control systems, preferably Git/GitHub - Excellent written communication skills for technical documentation - Demonstrated ability to work within and help guide Agile development methodologies Please note that the position requires you to be currently located in Bangalore and have experience in the Asset Management domain.,