Job Title: Software Developer ETL/ Teradata Location: Pleasanton, CA Role/Responsibilities Key Responsibilities • Design and develop complex SQL queries, stored procedures, and macros in Teradata.
• Implement ETL workflows using tools like Informatica, BTEQ, or Teradata utilities (FastLoad, MultiLoad, TPT). • Optimize queries and manage performance tuning for large-scale data environments.
• Collaborate with data architects and business analysts to translate requirements into technical solutions.
• Perform data validation, troubleshooting, and issue resolution.
• Ensure compliance with data governance and security standards.
Required Skills & Qualifications • Strong experience in Teradata SQL, joins, indexes, and explain plans.
• Hands-on experience with Teradata utilities (FastLoad, MultiLoad, TPT, BTEQ). • Knowledge of ETL tools (Informatica, DataStage, or similar). • Familiarity with data warehousing concepts and BI tools.
• Proficiency in performance tuning and query optimization.
• Good understanding of Unix/Linux scripting.
• Excellent problem-solving and communication skills.
• CAWA Scheduler