Teradata Developer

About Client:

The client is a global consulting, technology, and digital firm specializing in the financial services industry. Established in 2001, the company provides innovative solutions to help clients navigate digital transformation, enhance operational efficiency, and achieve strategic objectives. With a focus on banking, capital markets, and insurance, it leverages cutting-edge technologies such as blockchain, artificial intelligence, and data science to deliver customized IT solutions and business consulting services.

The company's commitment to innovation, combined with its industry expertise, positions it as a leader in driving technological advancements and helping financial institutions stay competitive in a rapidly evolving market.

Salary Range: $95K-$100K/Annum

Job Description:

We are looking for an experienced Teradata Developer to join our data engineering and analytics team.

The ideal candidate will be responsible for developing, optimizing, and maintaining complex SQL queries, ETL processes, and data integration workflows using Teradata.

This role involves working closely with business analysts, data architects, and other stakeholders to deliver high-quality data solutions. Key Responsibilities:

Design, develop, and maintain efficient and scalable Teradata SQL queries, stored procedures, and macros.

Work with ETL tools to extract, transform, and load large volumes of data into Teradata data warehouses.

Optimize performance of complex queries and troubleshoot slow-running SQL scripts.

Collaborate with business analysts and stakeholders to gather and understand data requirements.

Develop and maintain data integration workflows and jobs using tools like Informatica, DataStage, Talend, or Teradata BTEQ.

Implement data quality and validation checks to ensure data accuracy and integrity.

Participate in code reviews and contribute to improving development standards and practices.

Monitor data loads and ensure timely availability of data for reporting and analytics. Required Skills & Qualifications:

Strong hands-on experience with Teradata SQL, BTEQ scripts, and utilities like FastLoad, MultiLoad, TPump, and FastExport.

Proficiency in writing complex SQL queries, tuning performance, and analyzing explain plans.

Experience with ETL tools such as Informatica, DataStage, Ab Initio, or similar.

Good understanding of data warehousing concepts, star/snowflake schemas, and dimensional modeling.

Familiarity with Unix/Linux for scripting and automation.

Experience working in large-scale enterprise data environments.

Strong analytical and problem-solving skills.

About ApTask:

ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Candidate Data Collection Disclaimer:

At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.

If you have any concerns or queries about your personal information, please feel free to contact our compliance team at .

Applicant Consent:

By submitting your application, you agree to ApTask's Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at or . Message frequency may vary. Msg & data rates may apply.