Logo of Huzzle

Abinitio

image

Virtusa

5d ago

  • Job
    Full-time
    Senior Level
  • Data
    IT & Cybersecurity
  • Chennai

AI generated summary

  • You need 8+ years with Ab Initio ETL, strong ETL design, data analysis, SQL proficiency, Unix/Linux scripting, and knowledge of data governance, troubleshooting, and ITIL processes.
  • You will design and optimize ETL workflows, collaborate on data solutions, monitor production pipelines, troubleshoot issues, conduct code reviews, and document procedures for support.

Requirements

  • 8+ years of hands-on experience with Ab Initio ETL tools in both development and production environments.
  • Strong knowledge of ETL design principles, data integration, and data warehousing concepts.
  • Proven experience in data analysis, including querying large data sets, generating reports, and providing actionable insights.
  • Proficiency in SQL and working with databases such as Oracle, Teradata, SQL Server, or similar.
  • Experience with Unix/Linux scripting
  • Strong understanding of data governance, data quality management, and metadata management.
  • Expertise in troubleshooting and root cause analysis for production support issues.
  • Familiarity with ITIL processes (Incident, Problem, and Change Management).

Responsibilities

  • Lead the design, development, and optimization of ETL workflows using Ab Initio to support data integration and business intelligence needs.
  • Collaborate with data architects and business analysts to translate complex business requirements into efficient data solutions.
  • Ensure the scalability, performance, and reusability of ETL processes.
  • Conduct code reviews and ensure adherence to coding standards and best practices within the team.
  • Monitor the ETL environment, ensuring the availability, stability, and performance of data pipelines in production.
  • Lead efforts to diagnose and troubleshoot production issues, including incident management, root cause analysis, and implementing solutions.
  • Maintain service level agreements (SLAs) for production support and ensure timely resolution of data and system issues.
  • Coordinate on-call production support to address critical incidents and outages.
  • Document production support procedures, issue logs, and troubleshooting steps for future reference.

FAQs

What is the minimum experience required for the Ab Initio ETL Lead position?

The minimum experience required is 6-8 years in Ab Initio ETL tools.

What are the primary responsibilities of the Ab Initio ETL Lead?

The primary responsibilities include designing and implementing ETL solutions, performing data analysis, providing production support, monitoring the ETL environment, troubleshooting issues, and maintaining the stability and performance of data pipelines.

What skills are essential for this position?

Essential skills include hands-on experience with Ab Initio ETL tools, strong knowledge of ETL design principles and data warehousing concepts, proficiency in SQL and database management, Unix/Linux scripting, and expertise in troubleshooting production support issues.

Is experience with data visualization tools necessary for this role?

While not required, experience with Tableau or any data visualization tool is preferred.

What types of databases should candidates be familiar with?

Candidates should have experience with databases such as Oracle, Teradata, SQL Server, or similar.

What methodologies does Virtusa value for development?

Virtusa values agile development methodologies and experience working in agile teams.

Does this position involve leadership responsibilities?

Yes, the role involves providing leadership on data analysis tasks and conducting code reviews to ensure adherence to coding standards.

Are there any specific production support tasks expected from the candidate?

Yes, the candidate is expected to monitor the ETL environment, diagnose production issues, coordinate on-call support, and maintain service level agreements (SLAs).

What is Virtusa's approach to diversity and equal opportunity in hiring?

Virtusa is committed to equal opportunity and does not discriminate based on race, religion, color, sex, gender identity, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by law.

What type of work environment does Virtusa promote?

Virtusa promotes a collaborative team environment that focuses on professional and personal development, as well as providing opportunities to work on exciting projects with state-of-the-art technologies.

Business transformation that lasts starts with Engineering First.

Technology
Industry
10,001+
Employees
1996
Founded Year

Mission & Purpose

Virtusa Corporation provides digital engineering and technology services to Forbes Global 2000 companies worldwide. Our Engineering First approach ensures we can execute all ideas and creatively solve pressing business challenges. With industry expertise and empowered agile teams, we prioritize execution early in the process for impactful results. We combine logic, creativity and curiosity to build, solve, and create. Every day, we help clients engage with new technology paradigms, creatively building solutions that solve their most pressing business challenges and move them to the forefront of their industry.