PSG Global Solutions Careers
Oracle Developer
PSG Global Solutions Careers, Boston, Massachusetts, us, 02298
Apply now and our proprietary system will quickly have you in front of a live recruiter.The OpportunityDescriptionWe're looking for an
Oracle Developer , working in
Financial Services
industry in
Boston, Massachusetts, United States .
Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked.Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.Analyze, design, develop, troubleshoot, and implement, standard and custom processes in ODI.Develop data warehouse solutions per the given business requirements.Develop and/or enhance database schemas to fulfill the business requirements.Develop Extract Transform and Load (ETL) processes for ingesting data to the Data Warehouse.Research, test, build, and coordinate the conversion and/or integration of new products based on requirements.Work with other Tableau team and develop necessary mappings to bring the data into data warehouse based on the need.Write SQL, PL/SQL programs and ongoing performance tuning.Ensure issues are addressed and resolved in a timely manner.Monitor outstanding service requests, patch applications and associated testing.Provide support to the enterprise solutions.
Our Client
Our client provides agile consulting and staffing. Helping organizations fulfill their most important initiatives and opportunities. For 30 years. From coast-to-coast.
Developing long-term relationships. Successfully retaining clients and placing consultants through multiple engagements.
Providing you with the support, care, and attention you deserve. With advocates available 24x7 to help you with questions and concerns. This personal care together with great work has resulted in a 4.4 Glassdoor rating.
Join the most talented professionals in the industry working on strategic and world-class programs.
Experience Required for Your Success
Bachelor's or Master's Degree in any related field5+ years of hands-on experience in designing, developing and ongoing maintenance of Data Warehouse on Oracle platformExperience reverse engineering and documenting the requirements from existing code (Oracle stored procedures, functions, SQL and other ETL code)Experience in coding complex SQL queries for OLAP, Decision Support, Analytical use casesKnowledge of Oracle Autonomous warehouse, Oracle data integrator and business intelligence tools and best practicesExperience with dimensional modeling, star schemas, and RDBMSExperience in dimensional data modelingExpert in writing SQL, PL/SQL programsAny experience with data visualization tools like Tableau is a big plusComprehensive knowledge, skills, and abilities to perform requirements analysisExpertise and skills with technical and functional problems identification, resolving, and trackingAbility to communicate at all level business, colleagues, and management
What Do You Think?Does your experience reflect what it takes to be successful in this role? Do the work and challenges get you excited about what's possible?
Oracle Developer , working in
Financial Services
industry in
Boston, Massachusetts, United States .
Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked.Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.Analyze, design, develop, troubleshoot, and implement, standard and custom processes in ODI.Develop data warehouse solutions per the given business requirements.Develop and/or enhance database schemas to fulfill the business requirements.Develop Extract Transform and Load (ETL) processes for ingesting data to the Data Warehouse.Research, test, build, and coordinate the conversion and/or integration of new products based on requirements.Work with other Tableau team and develop necessary mappings to bring the data into data warehouse based on the need.Write SQL, PL/SQL programs and ongoing performance tuning.Ensure issues are addressed and resolved in a timely manner.Monitor outstanding service requests, patch applications and associated testing.Provide support to the enterprise solutions.
Our Client
Our client provides agile consulting and staffing. Helping organizations fulfill their most important initiatives and opportunities. For 30 years. From coast-to-coast.
Developing long-term relationships. Successfully retaining clients and placing consultants through multiple engagements.
Providing you with the support, care, and attention you deserve. With advocates available 24x7 to help you with questions and concerns. This personal care together with great work has resulted in a 4.4 Glassdoor rating.
Join the most talented professionals in the industry working on strategic and world-class programs.
Experience Required for Your Success
Bachelor's or Master's Degree in any related field5+ years of hands-on experience in designing, developing and ongoing maintenance of Data Warehouse on Oracle platformExperience reverse engineering and documenting the requirements from existing code (Oracle stored procedures, functions, SQL and other ETL code)Experience in coding complex SQL queries for OLAP, Decision Support, Analytical use casesKnowledge of Oracle Autonomous warehouse, Oracle data integrator and business intelligence tools and best practicesExperience with dimensional modeling, star schemas, and RDBMSExperience in dimensional data modelingExpert in writing SQL, PL/SQL programsAny experience with data visualization tools like Tableau is a big plusComprehensive knowledge, skills, and abilities to perform requirements analysisExpertise and skills with technical and functional problems identification, resolving, and trackingAbility to communicate at all level business, colleagues, and management
What Do You Think?Does your experience reflect what it takes to be successful in this role? Do the work and challenges get you excited about what's possible?