Key Facts

Remote From:

Full time

English

Hard Skills

Oracle CRM PL/SQL SQL (Programming Language) Apache Spark Indexing Data Warehouse Architectures ETL (Extract Transform Load) Data Architecture Data Security Data Integration +13 more

Other Skills

•
Problem Reporting
•
Teamwork
•
Communication
•
Problem Solving
•
Analytical Skills

Roles & Responsibilities

Proven experience with Oracle databases and PySpark.
Strong proficiency in SQL, PL/SQL, Python, and PySpark.
Familiarity with Oracle database administration, data warehousing, and ETL concepts.
Understanding of big data technologies and distributed computing principles.

Requirements:

Data Integration: Integrate data from various sources into Oracle databases and design PySpark data pipelines to enable data transformation and analytics.
Data Transformation: Develop and maintain data transformation workflows using PySpark to clean, enrich, and structure data for analytical purposes.
Data Modeling and Query Optimization: Create and maintain data models within Oracle databases, ensuring data is structured and indexed for optimal query performance; write complex SQL queries and PySpark transformations for efficient data retrieval and processing.
Data Quality & Performance: Implement data quality checks, error handling, and validation processes to ensure data accuracy and reliability; optimize Oracle databases and PySpark jobs to improve performance.

PradeepIT Consulting Services Pvt Ltd

About PradeepIT Consulting Services Pvt Ltd

Join PradeepIT: Innovating Information Technology and Solutions We pride ourselves on delivering exceptional results in the digital era of Information and Technology. With a track record of successful projects across offshore, nearshore, and onshore locations, we've built a clientele spanning 3 continents and 100+ companies. Our 380+ successful projects reflect our commitment to excellence. At PradeepIT, we prioritize the satisfaction of our resources, followed closely by meeting the needs of our clients and partner companies. Our service offerings include Outsourcing, Managed Services, Recruitment Process Outsourcing, Customer Relationship Management, Web Designing & Development, Content Development, and E-commerce Management. We specialize in SAP S/4 HANA, SAP Customer Data Cloud (Gigya), SAP CPQ (Calliduscloud), SAP Customer Experience, Mobility, Android, iOS & Hybrid development for native application developments. Our core value of "Join As Employee With Us And Grow Up As Entrepreneur" drives our mission. We proudly introduce our venture companies: 1. HG Infotech Pvt Ltd 2. Beli Brother Consulting Pvt Ltd 3. Involvemind 4. Stackglobe 5. Prastuti Consulting 6. Khahara Consulting 7. Thinkhigh And many more to come in the near future. We invite you to be part of our clients' success stories by adopting the latest technology and continually improving processes. If you'd like to learn more about us or have specific questions, visit www.pradeepit.com, call us at 08047363377, or email info@in.pradeepit.com. Let's work together on your next project!

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

Job Description:

Experiance:5 to 7 Years

We are seeking a highly skilled and motivated Oracle + PySpark Data Engineer/Analyst to join our team. The ideal candidate will be responsible for leveraging the Oracle database and PySpark to manage, transform, and analyze data to support our business's decision-making processes. This role will play a crucial part in maintaining data integrity, optimizing data processes, and enabling data-driven insights.

Key Responsibilities:

1. Data Integration: Integrate data from various sources into Oracle databases and design PySpark data pipelines to enable data transformation and analytics.
2. Data Transformation: Develop and maintain data transformation workflows
using PySpark to clean, enrich, and structure data for analytical purposes.
3. Data Modeling: Create and maintain data models within Oracle databases,
ensuring data is structured and indexed for optimal query performance.
4. Query Optimization: Write complex SQL queries and PySpark transformations for efficient data retrieval and processing.
5. Data Analysis: Collaborate with data analysts and business teams to provide insights through data analysis and reporting.
6. Data Quality: Implement data quality checks, error handling, and validation
processes to ensure data accuracy and reliability.
7. Performance Tuning: Optimize Oracle database and PySpark jobs to improve

Known Tools

Proven experience in working with Oracle databases and PySpark.
Strong proficiency in SQL, PL/SQL, Python, and PySpark.
Familiarity with Oracle database administration, data warehousing, and ETL concepts.
Understanding of big data technologies and distributed computing principles.
Strong analytical and problem-solving skills.
Excellent communication and teamwork abilities.
Knowledge of data security and compliance standardsand overall data processing and analysis performance.
Documentation: Create and maintain comprehensive documentation for data
models, ETL processes, and codebase