Job Description :
Hi Folks, Good Morning! Hope you're doing great !!! I am a Staffing Specialist at Avtech Solutions . I am reaching out to you on an exciting job opportunity with one of our direct clients. Please find the JD below: Role: TeraData Developer Location : Austin, TX or Sunnyvale, CA. Duration: Contract (long term) Client: CTS Role: Sr. Developer (SA Level) 5 8 Years Position Responsibilities (Day to Day what Associate will do) Experience in data integration activities including: designing, coding, testing, deploying and supporting of applications Should possess strong Teradata ETL design and implementation skills and strong in writing Advanced SQLs to perform the desired activities Strong ETL Background ( Data Extraction , Transformation and loading in target from heterogeneous Sources ) Strong Understanding On Teradata Architecture Debug the complex SQLs and provide solution to fine tune the queries to minimize the load on the system Experienced in Data Warehousing design and architecture and Data Integration Solutions using Teradata Expertise in Query optimization and Performance tuning techniques Expertise in Data Analysis, troubleshooting of issues and providing solution to complex applications Strong in Teradata Stored Procedures, BTEQ, Utilities Python / UNIX Shell scripting Knowledge Engage with onsite-offshore team for daily activities Qualifications (Includes Primary Skill, Secondary Skill and other qualifications) 5-8 Years of work experience Minimum 6+ years of development experience using Teradata Stored procedures, BTEQ, FastExport, MultiLoad etc., to perform ETL activities. Ability to understand the complex requirements from customers and convert them to technical design document Possess experience in creating test cases and writing SQLs to perform unit testing and integration testing activities. 5+ years of experience in data warehousing projects implementing data models using Teradata database Demonstrated ability to complete multiple tasks under pressure with a high degree of flexibility Must be able to understand data models and business logic in a short span of time Person must have good analytical skills Hands on in writing SQL. Minimum 3+ years of Experience in UNIX / python programming Should be good at communicating with Biz Teams/Clients Is self-motivated to take initiatives and thrive in an ambiguous work environment Should be able to guide the team members in completing the developments and testing activities