11+ Oracle Data Integrator Jobs in India

Looking Data Enginner for our Own organization-

Notice Period- 15-30 days
CTC- upto 15 lpa

 

Preferred Technical Expertise 

1. Expertise in Python programming.
2. Proficient in Pandas/Numpy Libraries. 
3. Experience with Django framework and API Development.
4. Proficient in writing complex queries using SQL
5. Hands on experience with Apache Airflow.
6. Experience with source code versioning tools such as GIT, Bitbucket etc.

 Good to have Skills:

1. Create and maintain Optimal Data Pipeline Architecture
2. Experienced in handling large structured data.
3. Demonstrated ability in solutions covering data ingestion, data cleansing, ETL, Data mart creation and exposing data for consumers.
4. Experience with any cloud platform (GCP is a plus)
5. Experience with JQuery, HTML, Javascript, CSS is a plus.

If Intersted , Kindly share Your CV

What you will do

• Bring in industry best practices around creating and maintaining robust data pipelines for complex data projects with/without AI component
  • programmatically ingesting data from several static and real-time sources (incl. web scraping)
  • rendering results through dynamic interfaces incl. web / mobile / dashboard with the ability to log usage and granular user feedbacks
  • performance tuning and optimal implementation of complex Python scripts (using SPARK), SQL (using stored procedures, HIVE), and NoSQL queries in a production environment

• Industrialize ML / DL solutions and deploy and manage production services; proactively handle data issues arising on live apps
• Perform ETL on large and complex datasets for AI applications - work closely with data scientists on performance optimization of large-scale ML/DL model training
• Build data tools to facilitate fast data cleaning and statistical analysis
• Ensure data architecture is secure and compliant
• Resolve issues escalated from Business and Functional areas on data quality, accuracy, and availability
• Work closely with APAC CDO and coordinate with a fully decentralized team across different locations in APAC and global HQ (Paris).

You should be

•  Expert in structured and unstructured data in traditional and Big data environments – Oracle / SQLserver, MongoDB, Hive / Pig, BigQuery, and Spark
• Have excellent knowledge of Python programming both in traditional and distributed models (PySpark)
• Expert in shell scripting and writing schedulers
• Hands-on experience with Cloud - deploying complex data solutions in hybrid cloud / on-premise environment both for data extraction/storage and computation
• Hands-on experience in deploying production apps using large volumes of data with state-of-the-art technologies like Dockers, Kubernetes, and Kafka
• Strong knowledge of data security best practices
• 5+ years experience in a data engineering role
• Science / Engineering graduate from a Tier-1 university in the country
• And most importantly, you must be a passionate coder who really cares about building apps that can help people do things better, smarter, and faster even when they sleep

Job Description

Job Responsibilities

• Design and implement robust database solutions including

  • Security, backup and recovery

  • Performance, scalability, monitoring and tuning,

  • Data management and capacity planning,

  • Planning, and implementing failover between database instances.

• Create data architecture strategies for each subject area of the enterprise data model.

• Communicate plans, status and issues to higher management levels.

• Collaborate with the business, architects and other IT organizations to plan a data strategy, sharing important information related to database concerns and constrains

• Produce all project data architecture deliverables..

• Create and maintain a corporate repository of all data architecture artifacts.

 

Skills Required:

• Understanding of data analysis, business principles, and operations

• Software architecture and design Network design and implementation

• Data visualization, data migration and data modelling

• Relational database management systems

• DBMS software, including SQL Server  

• Database and cloud computing design, architectures and data lakes

• Information management and data processing on multiple platforms 

• Agile methodologies and enterprise resource planning implementation

• Demonstrate database technical functionality, such as performance tuning, backup and recovery, monitoring.

• Excellent skills with advanced features such as database encryption, replication, partitioning, etc.

• Strong problem solving, organizational and communication skill.

Torrent Power is an Indian energy and power company, having interests in power generation, transmission, distribution and manufacturing and supply of power cables.

           Executive - SAP BASIS

• Required Skill - Operating systems & Tools (SUSE Linux 1 IBM AIX 1 IBM Spectrum i.e. IBM Tivoli)
  • Should be experienced in administration of SUSE Linux, IBM AIX operating systems Have hands-on experience in managing & troubleshooting IBM Tivoli (Spectrum Protect) backup utility with SAP HANA & Sybase DB environment.
  • Monitor status of BACKUPs, perform need based restore when require.
  • Report & coordinate with team lead for incident management process. Take corrective actions for incidents related to OS & backup related issues.
• Desirable Skills - SAP NetWeaver BASIS Administration
• SAP user management for ABAP & Java stacks, Business Objects, Central User Management, etc.
• Maintain Roles and Authorization using PFCG
• SAP Transport Management using ST MS and ChaRMs
• Knowhow of using SAP Solution Manager for MoPZ, ITSM, CHARMS, CUA, EWA, System Monitoring and Technical Administration
• BASIS administration (monitoring & maintenance) of SAP systems at Primary & DR-sitesMonitor & Troubleshoot the performance of SAP systems, Troubleshoot issues and follow-up with End Users and Development team to resolve the issues.
• Data Volume Management activities like index quality analysis and rebuilding.
• Monitoring & control database growth and perform DBA operations as required. Monitor status of database archive logs for smooth operation of SAP systems.

Desirable Skills - Database Administration (HANA I Sybase I Oracle) Manage and maintain database for SAP and Non-SAP applications/systems Monitor, administer the database and troubleshoot database related issues.

The role and responsibilities of Oracle or PL/SQL Developer and Database Administrator:
• Working Knowledge of XML, JSON, Shell and other DBMS scripts
• Hands on Experience on Oracle 11G,12c. Working knowledge of Oracle 18 and 19c
• Analysis, design, coding, testing, debugging and documentation. Complete knowledge of
Software Development Life Cycle (SDLC).
• Writing Complex Queries, stored procedures, functions and packages
• Knowledge of REST Services, UTL functions, DBMS functions and data integration is required
• Good knowledge on table level partitions, row locks and experience in OLTP.
• Should be aware about ETL tools, Data Migration, Data Mapping functionalities
• Understand the business requirement, transform/design the same into business solutions.
Perform data modelling and implement the business rules using Oracle database objects.
• Define source to target data mapping and data transformation logic as per the business
need.
• Should have worked on Materialised views creation and maintenance. Experience in
Performance tuning, impact analysis required
• Monitoring and optimizing the performance of the database. Planning for backup and
recovery of database information. Maintaining archived data. Backing up and restoring
databases.
• Hands on Experience on SQL Developer

Knowledge & Experience:

• 4-7 years of Industry experience in IT or consulting organizations
• 3+ years of experience defining and delivering Informatica Cloud Data Integration & Application Integration enterprise applications in lead developer role
• Must have working knowledge on integrating with Salesforce, Oracle DB, JIRA Cloud  
• Must have working scripting knowledge (windows or Nodejs) 

Soft Skills 

• Superb interpersonal skills, both written and verbal, in order to effectively develop materials that are appropriate for variety of audience in business & technical teams
• Strong presentation skills, successfully present and defend point of view to Business & IT audiences
• Excellent analysis skills and ability to rapidly learn and take advantage of new concepts, business models, and technologies

High Level Scope of Work :

 

• Work with AI / Analytics team to priorities MACHINE LEARNING Identified USE CASES for Development and Rollout
• Meet and understand current retail / Marketing Requirements and how AI/ML solution will address and automate the decision process.
• Develop AI/ML Programs using DATAIKU Solution & Python or open source tech with focus to deliver high Quality and accurate ML prediction Model
• Gather additional and external data sources to support the AI/ML Model as desired .
• Support the ML Model and FINE TUNEit to ensure high accuracy all the time.
• Example of use cases (Customer Segmentation , Product Recommendation, Price Optimization, Retail Customer Personalization Offers, Next Best Location for Business Est, CCTV Computer Vision, NLP and Voice Recognition Solutions)

Required technology expertise :

• Deep Knowledge & Understanding on MACHINE LEARNING ALGORITHMS (Supervised / Unsupervised Learning / Deep Learning Models)
• Hands on EXP for at least 5+ years with PYTHON and R STATISTICS PROGRAMMING Languages
• Strong Database Development knowledge using SQL and PL/SQL
• Must have EXP using Commercial Data Science Solution particularly DATAIKU and (Altryx, SAS, Azure ML, Google ML, Oracle ML is a plus)
• Strong hands on EXP with BIG DATA Solution Architecture and Optimization for AI/ML Workload.
• Data Analytics and BI Tools Hand on EXP particularly (Oracle OBIEE and Power BI)
• Have implemented and Developed at least 3 successful AI/ML Projects with tangible Business Outcomes In retail Focused Industry
• Have at least 5+ Years EXP in Retail Industry and Customer Focus Business.
• Ability to communicate with Business Owner & stakeholders to understand their current issues and provide MACHINE LEARNING Solution accordingly.

Qualifications

• Bachelor Degree or Master Degree in Data Science, Artificial Intelligent, Computer Science
• Certified as DATA SCIENTIST or MACHINE LEARNING Expert.

We are looking for a Senior Database Developer to provide a senior-level contribution to design, develop and implement critical business enterprise applications for marketing systems 

 

1. Play a lead role in developing, deploying and managing our databases (Oracle, My SQL and Mongo) on Public Clouds.
2. Design and develop PL/SQL processes to perform complex ETL processes. 
3. Develop UNIX and Perl scripts for data auditing and automation. 
4. Responsible for database builds and change requests.
5. Holistically define the overall reference architecture and manage its overall implementation in the production systems.
6. Identify architecture gaps that can improve availability, performance and security for both productions systems and database systems and works towards resolving those issues.
7. Work closely with Engineering, Architecture, Business and Operations teams to provide necessary and continuous feedback.

1. Automate all the manual steps for the database platform.
2. Deliver solutions for access management, availability, security, replication and patching.
3. Troubleshoot application database performance issues.
4. Participate in daily huddles (30 min.) to collaborate with onshore and offshore teams.

 

Qualifications: 

 

1. 5+ years of experience in database development.
2. Bachelor’s degree in Computer Science, Computer Engineering, Math, or similar.
3. Experience using ETL tools (Talend or Ab Initio a plus).
4. Experience with relational database programming, processing and tuning (Oracle, PL/SQL, My SQL, MS SQL Server, SQL, TSQL).
5. Familiarity with BI tools (Cognos, Tableau, etc.).
6. Experience with Cloud technology (AWS, etc.).
7. Agile or Waterfall methodology experience preferred.
8. Experience with API integration.
9. Advanced software development and scripting skills for use in automation and interfacing with databases.
10. Knowledge of software development lifecycles and methodologies.
11. Knowledge of developing procedures, packages and functions in a DW environment.
12. Knowledge of UNIX, Linux and Service Oriented Architecture (SOA).
13. Ability to multi-task, to work under pressure, and think analytically.
14. Ability to work with minimal supervision and meet deadlines.
15. Ability to write technical specifications and documents.
16. Ability to communicate effectively with individuals at all levels in the company and with various business contacts outside of the company in an articulate, professional manner.
17. Knowledge of CDP, CRM, MDM and Business Intelligence is a plus.
18. Flexible work hours.

 

This position description is intended to describe the duties most frequently performed by an individual in this position. It is not intended to be a complete list of assigned duties but to describe a position level.