Insight Global | Oracle Database Developer | hyderabad

6 days ago

Hyderabad, India Insight Global Full time
Required Skills and ExperienceStrong knowledge of Oracle ecosystemCreating queries, views, materialized views, functions, and stored procedures to meet business functionality requirementsCreating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectationsRunning or automating SQL based queries to load, transform and move data between database schemas and tablesCreate alarms, thresholds, budget values for effective monitoringNeed to be quick learner on how commissioning system works from business perspectiveWork with data engineers and data architect to increase productivity and achieve high quality of workStrong coding PL/SQL from scratchExperience with AWS RDS databases, and monitoringFamiliarity with queues, such as consuming data from, and publishing/pulling from. (Kafka, services, SQS, internal – and ability to read/work with Java)Experience with development and testingFamiliarity with AWS, S3, RDS, LambdaExperience with Informatica for orchestrationExperience with Qtest for testingExperience with performance tuning

Job DescriptionAn employer is looking for an Oracle Database Developer to work hybrid onsite in HITEC City, in Hyderabad, India. This team is the Commissions team, responsible for the Sales Compensation Management System that determines commissions payouts for various sales channels (such as retail/care, business, 3rd party sellers). They are moving towards a lot of self-service channels for customers, in lieu of direct engagements with their frontline retail/care sales. With the new self-service processes, they want to compensate the sales teams based on prior engagements or referrals to self-service flows. To support this, they are building out a framework from data integration to associating all the relevant data points both old and new to enable that. This is an AWS Oracle 19c RDS application and need a team that has strong database design and development experience. You will not need to build databases in AWS, but will need to understand how they work as RDS and understand monitoring such as looking at AWS monitors, and see the CPU, or needing more iops, scaling down to save costs etc. The team will be responsible for design, development, and testing. They ingest data from 40-50 upstream systems. They consume data and make sense of it, then send it to a calculation engine. They are an OLAP system not for reporting but because it’s not a front facing system. They work with large amounts of data with tables ranging from 100M to 2B records, and are at the cap of the RDS capability using close to 50 terabytes. All code is in PL/SQL, but use Informatica for orchestration and to consume data from upstream data sources/flat files. This person should have experience with queues (Kafka, SQS, etc.) and should be able to read Java code to be able to consume data, pull data, and publish data from queues.

This position pays between $12-15/hr USD

  • Insight Global | Oracle Database Developer | hyderabad

    7 days ago

    hyderabad, India Insight Global Full time

    Required Skills and ExperienceStrong knowledge of Oracle ecosystemCreating queries, views, materialized views, functions, and stored procedures to meet business functionality requirementsCreating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectationsRunning or...

  • Insight Global | Oracle Database Developer | hyderabad

    7 days ago

    hyderabad, India Insight Global Full time

    Required Skills and Experience Strong knowledge of Oracle ecosystemCreating queries, views, materialized views, functions, and stored procedures to meet business functionality requirementsCreating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectationsRunning or...

  • Insight Global | Oracle Database Developer | hyderabad

    7 days ago

    hyderabad, India Insight Global Full time

    Required Skills and Experience Strong knowledge of Oracle ecosystem Creating queries, views, materialized views, functions, and stored procedures to meet business functionality requirements Creating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectations Running or...

  • Insight Global | Javascript Developer | hyderabad

    4 weeks ago

    hyderabad, India Insight Global Full time

    ONLY APPLY IF YOU CAN take an IKM test covering JavaScript, React.js, and Node.js WITHIN 24 HOURS - NOT ACCEPTING CANDIDATES WHO WILL NOT TAKE THE TEST - YOU WILL BE REJECTED IMMEDIATELY Location : Onsite 2 days per week Insight Global Technology Delivery Center 7th Floor, Orwell Tower 1 Sattva Knowledge City Plot No.2, Inorbit Mall Road HITEC City,...

  • Insight Global | Javascript Developer | hyderabad

    4 weeks ago

    hyderabad, India Insight Global Full time

    ONLY APPLY IF YOU CAN take an IKM test covering JavaScript, React.js, and Node.js WITHIN 24 HOURS - NOT ACCEPTING CANDIDATES WHO WILL NOT TAKE THE TEST - YOU WILL BE REJECTED IMMEDIATELYLocation: Onsite 2 days per weekInsight Global Technology Delivery Center7th Floor, Orwell Tower 1Sattva Knowledge CityPlot No.2, Inorbit Mall RoadHITEC City, Hyderabad,...

  • Oracle Database Developer

    4 days ago

    Hyderabad, India Insight Global Full time

    Required Skills and Experience Strong knowledge of Oracle ecosystemCreating queries, views, materialized views, functions, and stored procedures to meet business functionality requirementsCreating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectationsRunning or...

  • Oracle Database Developer

    7 days ago

    Hyderabad, India Insight Global Full time

    Required Skills and Experience Strong knowledge of Oracle ecosystemCreating queries, views, materialized views, functions, and stored procedures to meet business functionality requirementsCreating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectationsRunning or...

  • Oracle Database Developer

    6 days ago

    Hyderabad, India Insight Global Full time

    Required Skills and Experience Strong knowledge of Oracle ecosystem Creating queries, views, materialized views, functions, and stored procedures to meet business functionality requirements Creating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectations Running or...

  • Oracle Database Developer

    7 days ago

    Hyderabad, India Insight Global Full time

    Required Skills and Experience Strong knowledge of Oracle ecosystemCreating queries, views, materialized views, functions, and stored procedures to meet business functionality requirementsCreating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectationsRunning or...

  • Oracle database developer

    5 days ago

    Hyderabad, India Insight Global Full time

    Required Skills and Experience Strong knowledge of Oracle ecosystemCreating queries, views, materialized views, functions, and stored procedures to meet business functionality requirementsCreating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectationsRunning or...

  • Senior Oracle Database Architect

    2 days ago

    Hyderabad, Telangana, India Insight Global Full time

    About the Role:We are seeking a highly skilled Senior Oracle Database Architect to join our team at Insight Global. This is an excellent opportunity for a talented individual to work on a challenging project that involves designing and developing a robust Sales Compensation Management System.Job Overview:The ideal candidate will have strong experience in...

  • Insight Global | Data Modeler | hyderabad

    4 weeks ago

    hyderabad, India Insight Global Full time

    Prefer a 30 day notice period or less Ideally hybrid in Hyderabad but can be remote Required Skills:6-9 years’ experience in performing data modeling/data design, hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols)Experience with data warehouse, data...

  • Insight Global | Data Modeler | hyderabad

    4 weeks ago

    hyderabad, India Insight Global Full time

    Prefer a 30 day notice period or less Ideally hybrid in Hyderabad but can be remote Required Skills: 6-9 years’ experience in performing data modeling/data design, hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols) Experience with data...

  • [Only 24h Left] Oracle Database Developer

    4 days ago

    Hyderabad, India Insight Global Full time

    Required Skills and Experience- Strong knowledge of Oracle ecosystem- Creating queries, views, materialized views, functions, and stored procedures to meet business functionality requirements- Creating tables, schemas, (optionally) databases and other database objects like constraints, primary and foreign keys etc. to meet business expectations- Running or...

  • Insight Global | Technical Support Engineer | hyderabad

    3 weeks ago

    hyderabad, India Insight Global Full time

    JOB DESCRIPTIONInsight Global is looking for a Sr. Tech Support Engineer local to Hyderabad, India for one of our fastest growing tech clients. This person will be responsible for the following: • Analyze the technical issues submitted by customers and identify how to proceed • Escalate the issues that have been identified as product malfunctions to our...

  • Insight Global | Technical Support Engineer | hyderabad

    3 weeks ago

    hyderabad, India Insight Global Full time

    JOB DESCRIPTION Insight Global is looking for a Sr. Tech Support Engineer local to Hyderabad, India for one of our fastest growing tech clients. This person will be responsible for the following: • Analyze the technical issues submitted by customers and identify how to proceed • Escalate the issues that have been identified as product malfunctions to...

  • Insight Global | Technical Support Engineer | hyderabad

    3 weeks ago

    hyderabad, India Insight Global Full time

    JOB DESCRIPTION Insight Global is looking for a Sr. Tech Support Engineer local to Hyderabad, India for one of our fastest growing tech clients. This person will be responsible for the following: • Analyze the technical issues submitted by customers and identify how to proceed • Escalate the issues that have been identified as product malfunctions to...

  • Oracle Cloud Database Engineer

    1 month ago

    Hyderabad, Telangana, India Oracle Full time

    Job Title: Oracle Cloud Database EngineerWe are seeking a skilled Oracle Cloud Database Engineer to join our team. As a key member of our team, you will be responsible for designing, implementing, and maintaining large-scale Oracle database systems on the cloud.Responsibilities:Develop and implement critical test cases with a focus on security, resiliency,...

  • Insight Global | Data Engineer | hyderabad

    5 days ago

    Hyderabad, India Insight Global Full time

    JOB DESCRIPTIONOur Tech clients within the Data & Analytics (DNA) Organization is seeking two experienced Senior Data Engineers to join our team in India. These individuals will play a crucial role in building analytical data assets and leveraging the modern data stack to support a new program, the modernization of internal data estate and analytics. The...

  • Insight Global | Data Engineer | hyderabad

    6 days ago

    hyderabad, India Insight Global Full time

    JOB DESCRIPTIONOur Tech clients within the Data & Analytics (DNA) Organization is seeking two experienced Senior Data Engineers to join our team in India. These individuals will play a crucial role in building analytical data assets and leveraging the modern data stack to support a new program, the modernization of internal data estate and analytics. The...