Experience8+ years Data Engineering experience.3+ years experience of cloud platform services (preferably GCP)2+ years hands-on experience on Pentaho. Hands-on experience in building and optimizing data pipelines and data sets.Hands-on experience with data extraction and transformation tasks while taking care of data security, error handling and pipeline performance.Hands-on experience with relational SQL (Oracle, SQL Server or MySQL) and NoSQL databases .Advance SQL experience - creating, debugging Stored Procedures, Functions, Triggers and Object Types in PL/SQL Statements.Hands-on experience with programming languages - Java (mandatory), Go, Python.Hands-on experience in unit testing data pipelines.Experience in using Pentaho Data Integration (Kettle/Spoon) and debugging issues.Experience supporting and working with cross-functional teams in a dynamic environment.Technical SkillsProgramming & Languages: JAVADatabase Tech: Oracle, Spanner, BigQuery, Cloud StorageOperating Systems: Linux Good knowledge and understanding of cloud based ETL framework and tools.Good understanding and working knowledge of batch and streaming data processing.Good understanding of the Data Warehousing architecture.Knowledge of open table and file formats (e.g. delta, hudi, iceberg, avro, parquet, json, csv)Strong analytic skills related to working with unstructured datasets.Excellent numerical and analytical skills. ResponsibilitiesDesign and develop various standard/reusable to ETL Jobs and pipelines.Work with the team in extracting the data from different data sources like Oracle, cloud storage and flat files.Work with database objects including tables, views, indexes, schemas, stored procedures, functions, and triggers.Work with team to troubleshoot and resolve issues in job logic as well as performance.Write ETL validations based on design specifications for unit testingWork with the BAs and the DBAs for requirements gathering, analysis, testing, metrics and project coordination.
Skill: ETL
Role / Tier:-ETL Developer- Tier 2
Job Description:
·Good knowledge and understanding of cloud based ETL framework and tools.
·Hands-on experience with programming languages - Java
AboutVirtusa
Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 21,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.
Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.
Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.
