What are the responsibilities and job description for the Oracle Database Developer(Heavy PL/SQL ) position at Compunnel Inc.?
Job: Database Developer (Heavy PL/SQL)
Location: Westlake TX 2 weeks onsite in a month
Long term contract
MUST HAVE: PL/SQL, Co-Pilot, AWS and python are nice to have.
The Skills and Expertise You Bring
- Bachelor’s degree in computer science engineering or equivalent
- 8 years of relevant experience in database development
- 8 years hands-on RDBMS expertise (Oracle, Exadata, PostgreSQL).
- Extensive hands-on experience with ETL/ELT tools (Informatica, SnapLogic).
- Expertise in Data Analysis, Data Profiling and Data Modeling skills.
- Knowledge of Data Warehousing methodologies and concepts.
- Build and maintain robust ETL pipelines to integrate data from multiple sources into OLAP data stores, ensuring data integrity and consistency.
- Bring an innovative spirit in search of efficiencies, process improvement opportunities, technical improvements, and other ways to add value to the organization with focus on operations improvement.
- Extensive experience with PL/SQL, database stored procedures, and performance tuning.
- Proficiency in Python
- Proficiency with python for data movement/transformation including development of classes and object-oriented code.
- Complex batch cycle orchestration (tools like Control-M, Autosys or Crontab).
- Implement best practices in data security, role-based access control, and data masking to maintain compliance and data governance standards.
- Knowledge of Cloud platforms and Services (AWS – IAM, EC2, S3, Lambda, RDS).
- Knowledge of data streaming tools like Kafka, Kinesis.
- Design experience of scalable data models, optimized for data ingestion and analytics requirements including SCD.
- Developing and automating deployment with GIT, Jenkins, and CICD Processes.