Python & Oracle Developer
BC Forward
Jersey City, United States of America
2 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 189KJob location
Jersey City, United States of America
Tech stack
Agile Methodologies
Data analysis
JIRA
Unit Testing
CA Workload Automation Ae
Unix
Data Integration
ETL
DevOps
Github
Python
Oracle SQL Developer
Performance Tuning
Query Optimization
Software Engineering
SQL Stored Procedures
SQL Databases
Test Case Design
Freeform SQL
Star Schema
Bitbucket
Database Rules and Triggers
Jenkins
Artifactory
Job description
- Design, develop, and modify Oracle PL/SQL objects, SQL queries, and views.
- Create new database tables and modify existing schemas based on business requirements.
- Perform performance tuning and analyze execution plans for query optimization.
- Apply normalization, denormalization, and star schema design as appropriate.
- Develop stored procedures, database triggers, and reusable SQL components.
- Implement Python services and integrations, including OCR/NLP where applicable.
- Develop test cases and perform unit testing to ensure quality and compliance.
- Coordinate with onsite leadership, developers, and a distributed team.
- Provide regular status updates and documentation to stakeholders and management.
- Guide and support DEV team members on best practices and delivery goals.
Requirements
We are seeking an experienced Application Programmer to join our agile team. The ideal candidate will have strong experience in Python, Oracle PL/SQL, SQL Views, and data modeling, and a proven ability to deliver high-quality, defect-free solutions on schedule while collaborating with distributed teams and business partners., * 5+ years of software development experience with a strong background in Oracle PL/SQL and SQL Views.
- 3+ years of Python development, including building services and data integrations.
- Data modeling skills including normalization, denormalization, and star schema design.
- Performance tuning expertise and ability to interpret explain plans.
- Experience developing stored procedures, triggers, and complex SQL queries.
- Experience with data analysis and integrating data from multiple source systems (2+ years).
- Familiarity with DevOps tools such as Jenkins, Artifactory, GitHub, Bitbucket, and Datical.
- Agile development experience with Jira and Agile best practices.
- Strong analytical, troubleshooting, and problem-solving skills with clear communication.
Preferred Skills:
- Experience with OCR and NLP tools and technologies.
- Knowledge of Informatica and Autosys for ETL and scheduling.
- Understanding of Unix concepts and shell utilities.
- Experience with Compliance or Operational Risk domains.
- Exposure to SDM Adoption or Horizon onboarding tools.
Benefits & conditions
- Competitive compensation and benefits
- Opportunities for growth with global clients
- A supportive, inclusive culture that values innovation and people
- Exposure to cutting-edge technologies and projects
About the company
BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.