Cogent People ir IT un biznesa konsultāciju uzņēmums, kas atbalsta federālās un štatu valdības iestādes datu, programmatūras, sistēmu un organizatorisko pārmaiņu jomā. Kopš 2009. gada Kolumbijā, Merilendas štatā, bāzētais uzņēmums strādā ar datu stratēģiju, arhitektūru un integrāciju, analītiku un pārskatu sagatavošanu, programmatūras izstrādi, sistēmu darbību, programmu un projektu vadību, kā arī biznesa procesu pārveidi. Kā sertificēts 8(a) uzņēmums un mazs, mazākumtautībai piederošs un nelabvēlīgā situācijā esošs uzņēmums Cogent People darbojas valsts līgumu nozarē, koncentrējoties uz uzticamu izpildi, praktiskām inovācijām un ilgtermiņa vērtību klientiem. Uzņēmuma daudznozaru darbs var interesēt profesionāļus, kurus saista tehnoloģiju un konsultāciju lomas, kas saistītas ar publiskā sektora programmām.
Senior SQL Developer, Oracle PL/SQL
Develop and tune Oracle data systems supporting federal healthcare finance. Manage recurring reports, EDI processing, and modernization of reporting workloads for cloud platforms.
Apraksts
- Build and operate database processing for a critical federal healthcare finance system.
- Run scheduled data validation and reporting, delivering accurate results on time.
- Develop and maintain Oracle PL/SQL packages and procedures.
- Ingest and validate large XML and EDI files.
- Load staging and fact tables.
- Create outbound data files and reconcile results across connected systems.
- Convert ad hoc client requests into accurate, documented query results and extracts.
- Explain data findings and discrepancies to stakeholders.
- Optimize queries on large partitioned tables.
- Troubleshoot and recover failed batch jobs.
- Automate repeatable processes that currently rely on spreadsheets.
- Move changes through formal releases, including testing, security reviews, and approvals.
- Support production changes.
- Document processes and systems.
- Coach junior developers.
- Help modernize reporting workloads on cloud data platforms.
Prasības
- Bachelor’s degree in computer science, information systems, or a related field, or equivalent experience.
- At least six years developing and supporting production Oracle database applications.
- At least three years in data warehousing, financial transaction processing, or regulatory reporting.
- Advanced Oracle SQL and PL/SQL, including packages, procedures, cursors, collections, bulk operations, dynamic SQL, exception handling, and job and error instrumentation.
- Query tuning skills, including execution plans, indexing, and large partitioned tables.
- Experience working with datasets containing hundreds of millions of rows.
- XML parsing and loading with XMLTYPE and XMLTABLE.
- Experience with delimited and fixed-width files, SQL*Loader, and external tables.
- Working knowledge of healthcare or financial EDI, such as X12 834, 810, 820, 835, or 824, or comparable formats.
- Enterprise batch scheduling with IBM Workload Scheduler/TWS, Control-M, Autosys, or a similar tool.
- Linux shell scripting.
- Python for data automation and report generation.
- Git-based version control.
- Familiarity with AWS, particularly Oracle RDS and S3.
- Experience with agile methods, including SAFe and Scrum.
- Working knowledge of DevSecOps, CI/CD, formal release management, and change control with documented test evidence.
- Ability to handle sensitive healthcare and financial data under federal security controls.
- Strong written and verbal communication.
- Ability to explain data discrepancies to nontechnical business leads and government stakeholders.
- Must have lived in the United States for at least three of the past five years.
- Must be authorized to work in the United States as a citizen, permanent resident, or EAD holder.
- Public Trust clearance or ability to obtain it.
Priekšrocības
- Health, dental, and vision insurance.
- 401(k) plan with matching contributions.
- Company-paid life insurance and short- and long-term disability coverage.
- Three weeks of annual paid time off plus 10 holidays.
- Career development opportunities.
- Supportive, inclusive culture.
- Competitive salaries.