Note: The job is a remote job and is open to candidates in USA. Mastech Digital is seeking an Oracle Data Engineer to develop Oracle-heavy data engineering solutions. The role involves ETL processing, data modeling, and performance tuning, along with supporting QA tasks and managing large data sets.
Responsibilities
- Create Oracle procedures, functions, triggers, packages, materialized views, and views using advanced features of Oracle 11g and Oracle 12
- ETL processing with Python, Oracle, and Unix across batch ETL and real-time stream processing
- Ability to do QA for some tasks, including validation, issue investigation, and support for delivery signoff where needed
- Load huge data sets from multiple vendors and perform data cleansing, data transformations, and data loading involving data modeling and data analytics
- Work on performance tuning for existing SQL and PL/SQL objects and build optimized objects
- Create complex Unix shell scripts to automate batch job processing and create reports on real-time, daily, and weekly basis
- Perform logical and physical design of databases, data modeling, and design specifications to analyze dependencies and perform risk analysis
- Develop and maintain technical specifications, data mappings, program logic, and flowcharts for all change requests that are performed
- Write complex queries to identify potential issues when interfaces fail and remediate them
- Automate flat file loading to Oracle using SQL Loader and create control files for that activity
- Able to understand the flow end to end from UI to DB
Skills
- Create Oracle procedures, functions, triggers, packages, materialized views, and views using advanced features of Oracle 11g and Oracle 12
- ETL processing with Python, Oracle, and Unix across batch ETL and real-time stream processing
- Ability to do QA for some tasks, including validation, issue investigation, and support for delivery signoff where needed
- Load huge data sets from multiple vendors and perform data cleansing, data transformations, and data loading involving data modeling and data analytics
- Work on performance tuning for existing SQL and PL/SQL objects and build optimized objects
- Create complex Unix shell scripts to automate batch job processing and create reports on real-time, daily, and weekly basis
- Perform logical and physical design of databases, data modeling, and design specifications to analyze dependencies and perform risk analysis
- Develop and maintain technical specifications, data mappings, program logic, and flowcharts for all change requests that are performed
- Write complex queries to identify potential issues when interfaces fail and remediate them
- Automate flat file loading to Oracle using SQL Loader and create control files for that activity
- Able to understand the flow end to end from UI to DB
- Oracle 11g and Oracle 12 advanced database capabilities
- Oracle PL/SQL objects, materialized views, functions, triggers, packages, and views
- Python, Oracle, and Unix for ETL processing
- Unix shell scripting for batch automation and reporting
- SQL Loader and control files for automated flat-file ingestion
- GitHub Copilot or other Dev Assist tools and capabilities
- Batch ETL and real-time stream processing
- Data cleansing, transformation, loading, modeling, analytics, and dependency / risk analysis
- Change request documentation, data mapping, program logic, and technical specification discipline
- QA support orientation for tasks requiring validation and handoff confidence
- Hands-on delivery orientation with strong analytical skills for interface issue diagnosis and remediation
- Ability to collaborate with architects, developers, QA, and business-facing teams across change requests and delivery cycles
- End-to-end thinking from UI to database, with practical comfort working across data, integration, and validation needs
Company Overview
Company H1B Sponsorship