Teradata Developer | Charlotte, NC | Hybrid | Contract
An opportunity has come through our network for a Teradata Developer at a prominent firm in the banking industry. This pivotal contract position is situated in Charlotte, North Carolina, and operates on a hybrid schedule, blending the benefits of collaborative in-office work with the flexibility of remote contributions. The firm is seeking a highly skilled and dedicated professional to join its Financial Crimes technology group, a division that stands at the forefront of the institution’s defense mechanisms against illicit financial activities. This role is far more than a standard programming position; it is an integral part of a mission-critical team, focused on leveraging robust data solutions to enhance, modify, and maintain applications that protect the bank and its customers from fraud and other financial misdeeds.
The individual who fills this role will be a central figure in the application development lifecycle, tasked with translating complex business requirements into high-performing, reliable, and secure software solutions. They will be responsible for the full spectrum of development activities, from the initial design and coding to the rigorous testing, debugging, and comprehensive documentation of programs. This work is not done in isolation; it requires a deep understanding of the bank’s data architecture and a proactive approach to providing insights and direction. The developer will be expected to assess the impact of proposed changes on existing technology systems, ensuring that all modifications are seamless, efficient, and do not introduce vulnerabilities or performance bottlenecks. Participation in the complete development lifecycle is a core expectation, meaning this person will contribute from the initial conceptualization and requirement-gathering stages all the way through to deployment and ongoing maintenance.
This role places a strong emphasis on collaboration and communication. A key part of the job involves contributing to “story refinement,” a process integral to agile methodologies. This means working closely with business stakeholders and product owners to break down high-level business needs into detailed, actionable technical requirements. The ability to effectively communicate complex technical concepts to a non-technical audience is paramount, as is the skill to listen and understand the true intent behind a business request. Beyond the development work, this position is also critical for modernizing the development process itself. The developer will be tasked with setting up and automating a continuous integration/continuous delivery (CI/CD) pipeline, a vital practice that ensures a streamlined, rapid, and reliable path from code changes to deployment. This commitment to automation is a key part of the team’s move towards a more efficient and robust development environment. Furthermore, the role involves day-to-day responsibilities such as change management, routine application maintenance, and supporting platform upgrades, all of which are essential for maintaining the health, security, and scalability of the applications.
The successful candidate will bring a robust and well-rounded technical skill set to the table, with a strong foundation in modern data engineering practices. A deep and proven expertise in Teradata 16.x is the non-negotiable core of this position. This isn’t just about knowing the syntax; it’s about understanding how to build and optimize data warehouse solutions within the Teradata environment. This includes advanced proficiency in SQL and BTEQ scripting, enabling the development of complex queries, stored procedures, and data manipulation scripts that are both performant and maintainable. Experience with TPT (Teradata Parallel Transporter) is also essential, as this tool is a critical component for high-speed, high-volume data loading and extraction, which is a frequent requirement in a large-scale banking environment. The ideal candidate will be adept at not only writing these scripts but also at tuning them to ensure maximum efficiency.
Complementing the Teradata skills, a strong background in Informatica 10.x is required. This is the firm’s primary ETL (Extract, Transform, Load) tool, and the Teradata Developer will be expected to design, build, and maintain Informatica mappings and workflows that orchestrate the movement of data from various source systems into the Teradata data warehouse. This requires an understanding of data quality, data lineage, and the ability to create robust, fault-tolerant ETL processes. The role also demands proficiency in UNIX Shell scripting, which is used for a variety of purposes, including automating data loading processes, scheduling tasks, and managing files and directories. This is closely tied to the use of Autosys, a workload automation tool that the bank uses to schedule and monitor jobs. The ability to set up and manage jobs within Autosys is a key skill for ensuring that data processing tasks run on time and in the correct sequence.
In addition to these relational database and ETL skills, the position requires experience with the modern big data ecosystem. Familiarity with Cloudera CDP (Cloudera Data Platform) is necessary, as this platform serves as a critical component of the bank’s data architecture. The candidate should also have hands-on experience with Hadoop and its associated technologies, including Hive, Impala, PySpark, and Scala. This is particularly important for handling large, unstructured, or semi-structured datasets and for performing advanced data processing and analytics. The ability to write Hive queries, use Impala for fast, interactive queries, and develop data processing applications using PySpark or Scala is a significant advantage. This blend of traditional data warehousing expertise with modern big data technologies is what will enable the developer to build truly robust and scalable solutions for the Financial Crimes technology group. Finally, strong data analysis experience is a fundamental requirement. This involves more than just pulling data; it means having the critical thinking skills to analyze data for inconsistencies, validate its integrity, and provide actionable insights that inform development decisions and business strategies.
This is a 12-month contract opportunity offering a competitive pay range. The firm is looking for a professional who is not only technically proficient but also a collaborative team player who can thrive in a fast-paced, high-stakes environment. Due to contractual requirements and the nature of the role within a highly regulated industry, candidates must be available to work as a direct employee of the contracting firm.
Job Features
| Job Category | Finance, Banking, & Accounting |