AnkenyRecruiter Since 2001
the smart solution for Ankeny jobs

SQL/Teradata Developer

Company: Signature Consultants
Location: Ankeny
Posted on: November 22, 2021

Job Description:

Job Summary:Signature Consultants is seeking a SQL/Teradata Developer (remote until after Covid-19 - on site after covid-19 sometime in 2022) for an opportunity with a client located in Des Moines, MN or Charlotte, NC. Our client is looking for someone to work on an assignment for 12 months + (prefer candidates who are eligible to covert to permanent employee).Responsibilities:

  • Develop design documentation and implementation proposal for extraction of data from W data warehouse
  • Develop modules to extract, process & transfer the customer data using Teradata utilities
  • Create Fast Export scripts for extracting and formatting customer data from data warehouse in a mainframe file
  • Create FTP Id to set up transmission path between mainframe and UNIX machine
  • Develop an environment to receive an external source file for the data that were missing in W tables
  • Performed the value added processing (VAPS) on the Customer data generated for user
  • Modify the file transmission protocol used in Bank which in turn provided an enormous amount of savings to the bank
  • Perform discharge of stale components from mainframe in turn reduced the maintenance cost for bank
  • Provide date warehousing architecture by writing SQL query code based on detail requirements provided by marketing group
  • Proper analysis of data included identification and enforcement of standards to ensure consistent and maintainable queries and reporting SQL data through Excel
  • Perform all work within the Teradata RDBMS environment using Queryman 6.0
  • Use ERWIN for metadata and table associations and ascential data stage
  • Provide proper documentation using technical writing tools
  • Follow department SDLC methodology and development procedures Required Qualifications:
    • 10+ business systems analysis experience, business systems design experience, or a combination of both
    • 4+ years of data warehouse experience
    • 3+ years of SQL experience (EXPERT LEVEL SQL/Teradata)
    • 2+ years of banking industry experienceDesired qualifications:
      • Excellent verbal, written, and interpersonal communication skills
      • 2+ years of Teradata experience
      • Experience with Waterfall and Agile project methodologies
      • 2+ years of project management experience --- Other desired qualifications - 5+ years of experience leading the requirement design process with both technical and business partners
      • Demonstrated ability to deliver multiple concurrent projects
      • Experience with data models, data relationships and data mapping
      • 2+ years of conduct management, risk or regulatory experience
      • Exposure working on speech or text analytics projects --- data virtualization tools, Mongo DB, Hadoop.About Signature Consultants, LLCHeadquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.EEO EmployerSignature Consultants is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Signature will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or 888.838.1020.

Keywords: Signature Consultants, Ankeny , SQL/Teradata Developer, IT / Software / Systems , Ankeny, Iowa

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Iowa jobs by following @recnetIA on Twitter!

Ankeny RSS job feeds