Oracle App DBA
Published date: 2024/01/10
- Location: Gurugram, Haryana, India
Roles and Responsibilities:-
1.Must have 2+ years of working experience in designing ETL flows with Pentaho Data Integration.
-Develop ETL jobs based on Requirements given.
-Self-Efficient to understand the existing ETL Jobs / Reports.
-Analyses data from various sources, including databases and flat files.
-Discuss with the customers/end users and gather requirements. Build - Customize ETL/BI reports.
-Identify the Problematic Areas in ETL /Loads and need to fix by Performance Improvement.
2. Must have 2+ years of experience in developing and tuning complex SQL queries using Oracle, PostgreSQL or other leading DBMS.
-Need to Write the SQL Scripts to validate the data.
3.Experience with Apache Kafka development
- Knowledge of Kafka components and dependencies
- Experience in designing event driven patterns using Kafka
- Able to create publisher and subscriber modules in Java/Springboot, Microservices
- Knowledge of Kafka administration, tuning
4.Need to Support Daily Loads able to fix the issues within SLA.
5.Hands on Java development experience with Java 8 and later.
6.Hands on data migration
7.Able to setup reporting for a new client
8.Able to write Linux script
9.Provide production support
10.Create Source to Target (Mapping) Documents
Required Technical and Professional Expertise: -
-Hands on experience on ETL Tools Like Pentaho.
-Hands on experience on any one Reporting tools like Pentaho BI, Microsoft Power BI, Oracle BI, Tableau etc.
-Apache Kafka development
-Experience in a data warehousing role with a solid understanding of data warehousing approaches and best practices.
-Strong Hands-on Experience writing SQL Scripts to analyse and validate the Data.
-Should have expert knowledge in writing SQL commands, queries, and stored procedures
-Strong knowledge of DB and DW concepts.
-Functional Knowledge/understanding on Finance, reconciliation, Customer service, Pricing modules etc.
-Excellent SQL, PL/SQL, XML, JSON and Database Skills
-Good to have some experience with Python or Javascript
-Good to have some knowledge on Kubernetes, Ansible
-Good to have some knowledge on Linux script
•
1.Must have 2+ years of working experience in designing ETL flows with Pentaho Data Integration.
-Develop ETL jobs based on Requirements given.
-Self-Efficient to understand the existing ETL Jobs / Reports.
-Analyses data from various sources, including databases and flat files.
-Discuss with the customers/end users and gather requirements. Build - Customize ETL/BI reports.
-Identify the Problematic Areas in ETL /Loads and need to fix by Performance Improvement.
2. Must have 2+ years of experience in developing and tuning complex SQL queries using Oracle, PostgreSQL or other leading DBMS.
-Need to Write the SQL Scripts to validate the data.
3.Experience with Apache Kafka development
- Knowledge of Kafka components and dependencies
- Experience in designing event driven patterns using Kafka
- Able to create publisher and subscriber modules in Java/Springboot, Microservices
- Knowledge of Kafka administration, tuning
4.Need to Support Daily Loads able to fix the issues within SLA.
5.Hands on Java development experience with Java 8 and later.
6.Hands on data migration
7.Able to setup reporting for a new client
8.Able to write Linux script
9.Provide production support
10.Create Source to Target (Mapping) Documents
Required Technical and Professional Expertise: -
-Hands on experience on ETL Tools Like Pentaho.
-Hands on experience on any one Reporting tools like Pentaho BI, Microsoft Power BI, Oracle BI, Tableau etc.
-Apache Kafka development
-Experience in a data warehousing role with a solid understanding of data warehousing approaches and best practices.
-Strong Hands-on Experience writing SQL Scripts to analyse and validate the Data.
-Should have expert knowledge in writing SQL commands, queries, and stored procedures
-Strong knowledge of DB and DW concepts.
-Functional Knowledge/understanding on Finance, reconciliation, Customer service, Pricing modules etc.
-Excellent SQL, PL/SQL, XML, JSON and Database Skills
-Good to have some experience with Python or Javascript
-Good to have some knowledge on Kubernetes, Ansible
-Good to have some knowledge on Linux script
•
0 page views
Related listings
-
Senior Manager - AnalyticsDatabase AdministratorAbout ClicFlyer Job Description : ClicFlyer provides custom analytics and consulting services which enable retailers to transform their business from product sales to customer-centric sales and also is a leading utility App in the Middle East region ...2026/11/08
-
ASSOCIATE RESEARCH CHEFDatabase AdministratorIt's an exciting time to be in APZ - McCormick's growth region. Our business here is transforming in remarkable ways. From the rice and spice fields of India and South East Asia to Australia's herb farms, our mosaic of rich distinct cultures inspires...2026/11/08
-
Database AdministratorDatabase AdministratorPosition Title : Database Architect Position Summary : NEC Corporation India Pvt Ltd is looking for an energetic and highly skilled Database expert to design, build, deliver and support various data management related (SQL and No-SQL) solution which ...2026/11/08