Lead Software Engineer

Virtusa Corporation

Westlake Village (CA)

On-site

USD 120,000 - 165,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Virtusa Corporation is seeking a Data Engineer in California to independently contribute across data engineering initiatives. You will write complex Oracle SQL/PL-SQL queries, design ETL pipelines with Informatica PowerCenter, and implement data warehousing patterns using Oracle.

You will also automate workflows with Unix/Python, handle cloud and on-prem data integration, and collaborate on batch scheduling with Control-M/Autosys while leveraging OBIEE/OAS for analytics and maintaining GitHub

Qualifications

  • 6+ years of experience in data engineering with Oracle SQL.
  • Expert-level SQL queries using Oracle.
  • PL/SQL stored procedures, functions, packages, triggers.
  • ETL experience with Informatica PowerCenter.
  • Scripting and automation with Unix and Python.
  • Experience with Oracle relational databases and performance tuning.
  • Data warehousing patterns and dimensional modelling using Oracle.
  • Cloud and on-prem data integration patterns.
  • Batch scheduling with Control-M or Autosys.
  • BI/analytics with OBIEE/OAS.
  • Source control with GitHub in data engineering.

Responsibilities

  • Act as an independent contributor on data engineering initiatives.
  • Develop and optimize complex SQL/PL-SQL queries for Oracle databases.
  • Design and implement ETL pipelines using Informatica PowerCenter.
  • Automate data workflows using Unix shell scripts and Python.
  • Implement data warehousing patterns and dimensional modelling.
  • Support cloud and on-prem data integration patterns.
  • Coordinate with teams on batch schedules using Control-M/Autosys.
  • Leverage BI tools (OBIEE/OAS) for analytics.
  • Maintain source code in GitHub and manage SCM processes.

Skills

SQL
PL/SQL
ETL development
Unix scripting
Python
Data warehousing
Dimensional modelling
Performance tuning
Batch scheduling
BI tools
GitHub SCM

Tools

Informatica PowerCenter
Oracle Database
Control-M
Autosys
OBIEE
GitHub

Job description

Data Engineer who has the ability to be an independent contributor with strong communication skills

  • Minimum 6+ years of experience Expert-level knowledge of writing complex SQL queries using Oracle.
  • Expert-level knowledge of Oracle PL/SQL (Stored Procedures, Functions, packages, triggers)
  • Strong working experience in ETL tools like Informatica (Power Center)
  • Working experience in scripting and automation using Unix, Python in a Data Engineering environment.
  • Extensive experience with Relational Databases like Oracle including being able to implement performance tuning techniques
  • Strong working knowledge of Datawarehousing patterns and Dimensional Modelling techniques using Oracle.
  • Experience building scalable patterns for data integration in a cloud-based as well as on-prem environments
  • Working knowledge of Batch scheduling tools like Control-M, Autosys.
  • Experience with business intelligence and analytics tools such as OBIEE/OAS
  • Working experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice.

Agile

Complex problem solving skills

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Software Engineer
Lead Software Engineer

Virtusa Corporation • Westlake (TX)

On-site
USD 120,000 - 160,000
Data Architect
Data Architect

Virtusa Corporation • Texarkana (TX)

On-site
USD 120,000 - 180,000
Senior Oracle PL/SQL & Data Engineer
Senior Oracle PL/SQL & Data Engineer

Compunnel Inc. • Smithfield (RI)

On-site
USD 100,000 - 130,000
Lead Software Engineer
Lead Software Engineer

Virtusa Corporation • Florida

On-site
USD 120,000 - 180,000
Data Engineer (Oracle)
Data Engineer (Oracle)

Rapinno Tech • Comunidad Los Cajones (PR)

Hybrid
USD 90,000 - 120,000
Senior Data Engineer - Oracle SQL & ETL Expert
Senior Data Engineer - Oracle SQL & ETL Expert

Virtusa Corporation • Texarkana (TX)

On-site
USD 120,000 - 180,000
Oracle Data Engineer
Oracle Data Engineer

TechDigital Group • Philadelphia

On-site
USD 100,000 - 130,000
Senior Database Developer
Senior Database Developer

Compunnel Inc. • Smithfield (RI)

On-site
USD 100,000 - 130,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

Jobsbridge • Fairfield (CA)

On-site
USD 90,000 - 120,000
Senior Data Engineer
Senior Data Engineer

Compunnel Inc. • Durham (NC)

On-site
USD 100,000 - 130,000