Job Title: Senior Software Engineer
Position: Data Engineer
Experience: 6-8 Years
Category: Software Development/ Engineering
Main location: India Telangana Hyderabad
Employment Type: Full Time
Data Engineer:
Data Engineer is responsible for the helping map and model data from various source systems into the DSP platform. Specifically understanding how to model all data structures according to BIAN framework which is an industry standard data model.
- Design develop and optimize Oracle relational databases tables ensuring high availability scalability and performance.
- Optimize SQL queries indexes and execution plans for efficient data processing.
- Develop ETL pipelines and PL/SQL to transform and integrate data from multiple sources.
- Implement job scheduling store procedure data validation and monitoring solutions.
- Work closely with data architecture DA teams and application developers to enable data-driven decision-making.
- Strong in creating logical and physical data model for RDBMS and NoSQL technologies.
- Strong expertise in PL/SQL SQL tuning stored procedures and triggers.
- Knowledge of data modeling data lakes and warehousing.
- Familiarity with Python shell scripting for transformation and automation.
- Experience with Big Data & NoSQL technologies (e.g: MongoDB Kafka Hadoop).
- Nice to have: Experience with BIAN (Banking Industry Architecture Network)