Insight Global
INTL - Oracle Database Engineer - INDIA
Insight Global, Bellevue, Washington, us, 98009
Job Description
An 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 its 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.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
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 automating SQL based queries to load, transform and move data between database schemas and tables
Create alarms, thresholds, budget values for effective monitoring
Need to be quick learner on how commissioning system works from business perspective
Work with data engineers and data architect to increase productivity and achieve high quality of work
Strong coding PL/SQL from scratch
Experience with AWS RDS databases, and monitoring
Familiarity 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 testing
Familiarity with AWS, S3, RDS, Lambda
Experience with Informatica for orchestration
Experience with Qtest for testing
Experience with performance tuning null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.
An 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 its 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.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
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 automating SQL based queries to load, transform and move data between database schemas and tables
Create alarms, thresholds, budget values for effective monitoring
Need to be quick learner on how commissioning system works from business perspective
Work with data engineers and data architect to increase productivity and achieve high quality of work
Strong coding PL/SQL from scratch
Experience with AWS RDS databases, and monitoring
Familiarity 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 testing
Familiarity with AWS, S3, RDS, Lambda
Experience with Informatica for orchestration
Experience with Qtest for testing
Experience with performance tuning null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.