Insight Global
Oracle Database Developer
Insight Global, Bellevue, Washington, us, 98009
Job Description
An employer is looking for an Oracle Database Developer to work remotely in the United States. 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 RDS application (Oracle 19c) and need a team that has strong database design and development experience. The team is looking for Database Developers, Data Engineers, and Data Analysts to support this initiative. They need functional analysts for design and testing, supported by database developers to implement the new.
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
· Coding PL/SQL from scratch
· Experience with AWS, S3, RDS, Lambda 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 remotely in the United States. 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 RDS application (Oracle 19c) and need a team that has strong database design and development experience. The team is looking for Database Developers, Data Engineers, and Data Analysts to support this initiative. They need functional analysts for design and testing, supported by database developers to implement the new.
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
· Coding PL/SQL from scratch
· Experience with AWS, S3, RDS, Lambda 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.