appian and sql developer .

job summary: Summary We are seeking to fill a senior level software developer position who will be working on database development for a business facing web application. Senior database developer will write, review and design complex SQL queries. The person will also design Oracle tables and schemas, review developer's designs, suggest to development team on using Oracle database features, and liaison with DBAs. Required Skills Oracle 19 gSQL skills.Experience in data modeling and database design.Optimize SQL queries, views, functions and stored procedures.Materialized viewsPerformance tuningERD diagramsClear communication skills.Able to work with cross application teams on multiple initiatives and provide technical leadership on code quality, design & implementation. Desired Skills Familiarity and understanding of Java/J2EE,Knowledge of Java integration with Oracle DBOracle application DBA skills   location: CHARLOTTE, North Carolina job type: Contract salary: $55 - 65 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: We are seeking to fill a senior level software developer position who will be working on database development for a business facing web application. Senior database developer will write, review and design complex SQL queries. The person will also design Oracle tables and schemas, review developer's designs, suggest to development team on using Oracle database features, and liaison with DBAs.   qualifications: Experience level: ExperiencedMinimum 10 years of experienceEducation: Bachelors  skills: OracleJava Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

job summary: Position Summary The candidate for the Backend/ETL developer position will be responsible for designing and developing batch/ETL interfaces using the proprietary meta data driven approach as part of the LIBRA Interface Team.The candidate will be responsible for maintenance and support of the existing interface processes including investigation of issues and production troubleshooting.Candidate will be responsible for maintaining the data lineage to facilitate the end to end traceability as and when changes to the ETL.In addition candidate will responsible for Liquidity report specific derivations. Primary Skill: Agile tools (Jira) Required Skills Extensive experience with Oracle/Exadata SQL, PL/SQL and perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports. Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) & SGA (System Global Areas) to optimize memory usage.Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handlingExperience in Unix/Linux shell scripting and/or Perl Scripting. Knowledge of python is desirable.Implementation experience with monitoring and measurement of data quality using business rules. Hands on experience hands with data quality assessment and resolution desirable.Maintain metadata, data glossary and data catalog processes. Ensure adherence to data security by using data encryption procedures and protocols.Ability to work in fast paced environmentExperience in Financial Industry with some risk background.Knowledge of Agile methodology is desirableKnowledge of Liquidity Reports like Fed5g, LCR, NSFR, CRD IV etc is a plusKnowledge of Tableau is desirable   location: Charlotte, North Carolina job type: Contract salary: $60 - 70 per hour work hours: 9am to 5pm education: Bachelors   responsibilities: The candidate for the Backend/ETL developer position will be responsible for designing and developing batch/ETL interfaces using the proprietary meta data driven approach as part of the LIBRA Interface Team.The candidate will be responsible for maintenance and support of the existing interface processes including investigation of issues and production troubleshooting.Candidate will be responsible for maintaining the data lineage to facilitate the end to end traceability as and when changes to the ETL.   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: ETL Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

job summary: Summary: The selected candidate will be an individual contributor responsible for development of the Activity Based Costing Datamart. This is an exciting project which will make GT&O costs more transparent to our clients and executive leadership. You may have taken the Activity Based Costing Surveys. This development team takes that data, combines with other data, and will create new cost reporting for all of GT&O.We continually look for innovative ways to make this process better and you can bring your ingenuity to this effort. Candidate will be a member of a small team of developers and data analysts who support development of the Tech ADS. Candidate will be responsible for a wide range of programming tasks and technologies including Exadata, Python, etc. Candidate will be involved in design, code, test and level 2/3 support of the data warehouse.In addition to development, the candidate will be responsible for partnering with the business to ensure requirements are met and with other functional areas of technology (QA, Production Support) to ensure effective implementation.Team uses an Agile development process. Required Skills Requires 4+ years of development experienceSQL, OracleLinuxJava, Python, Perl, Shell scriptingExperience working as part of an Agile team and using Agile SDLC tools (Jira, etc.) Desired Skills: Data WarehousingBS/MS in Computer Science, Engineering or other quantitative disciplineExperience with BI Platforms such as MicroStrategy or TableauWorking experience with Git, Jira, Confluence.   location: CHARLOTTE, North Carolina job type: Contract salary: $55 - 65 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: We continually look for innovative ways to make this process better and you can bring your ingenuity to this effort. Candidate will be a member of a small team of developers and data analysts who support development of the Tech ADS. Candidate will be responsible for a wide range of programming tasks and technologies including Exadata, Python, etc. Candidate will be involved in design, code, test and level 2/3 support of the data warehouse.In addition to development, the candidate will be responsible for partnering with the business to ensure requirements are met and with other functional areas of technology (QA, Production Support) to ensure effective implementation.Team uses an Agile development process.   qualifications: Experience level: ExperiencedMinimum 10 years of experienceEducation: Bachelors  skills: OraclePL/SQL Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.