ETL Test Engineer

Job Title:

Location:

Experience:

Responsibilities

• Design and implement scalable ETL processes to extract, transform, and load data from diverse sources into our data warehouse.
• Collaborate with cross-functional teams to gather requirements and understand data integration needs.
• Develop and maintain ETL pipelines (using AWS Glue Jobs), ensuring optimal performance and reliability.
• Perform data profiling, cleansing, and transformation to ensure data quality and consistency.
• Design optimized ETL workflows for performance and cost-effectiveness, leveraging AWS services.
• Document ETL processes, data mappings, and workflows for knowledge sharing and future reference.
• Stay updated on industry trends and best practices in ETL, data warehousing, and cloud technologies.
• Provide technical support and guidance to team members on ETL-related matters.
• Collaborate with stakeholders to understand product-specific data requirements, particularly with Workday data.
  

Technical Skills

• Proficiency in ETL tools and techniques, with hands-on experience in designing and implementing ETL processes.
• Strong understanding of data warehousing concepts and methodologies.
• Experience working with AWS Glue Jobs, S3, Redshift, and other AWS services.
• Familiarity with building and managing ETL pipelines in a cloud environment.
• Hands on experience in SQL, Python, PySpark and scripting languages for data manipulation and automation.
• Product Knowledge:
• Exposure to Workday data and understanding of its data model and integration capabilities.
• Experience in designing ETL solutions for integrating Workday data into enterprise systems is highly desirable.