Systems Software Analyst / Engineer (ETL/Teradata)

comtecinfo

$90K — $120K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's Degree and 5 years of experience in Data Warehouse development.
  • Strong knowledge of database analysis and SQL for Teradata 14 and above.
  • Familiarity with Teradata utilities like MLOAD, Fastload, and TPUMP.
  • Extensive Data Warehouse modeling and development expertise.
  • Proficient in UNIX, with knowledge of Windows and Linux operating systems.
  • Strong communication skills for interacting with customers and team members.
  • Ability to obtain a Position of Public Trust clearance.

Responsibilities

  • Gather and analyze requirements for data warehouse projects.
  • Design systems and process workflows.
  • Develop and maintain ETL processes in a Teradata environment.
  • Optimize performance and processes through tuning.
  • Document project lifecycles for compliance and audits.
  • Support production applications and resolve issues as they arise.
  • Engage with end users for effective requirement extraction.

Benefits

  • First shift hours, Monday to Friday, with occasional on-call rotation.
  • Opportunity to work in a collaborative AGILE environment.
  • Exposure to advanced databases and latest Teradata features.
  • Support in obtaining professional certifications such as Teradata Certification.
  • Engagement with customers directly, enhancing communication skills.
Full Job Description
This position will support the data warehouse from end to end including requirements and design, specification review, development, deployment and documentation. Candidate will provide analysis, guidelines and assistance during requirements gathering, review final code before transitioning into production. The ideal candidate will have strong analysis and documentation skills as well as ability to interact with customers and other team members using AGILE methodology. This is a first shift M-F job with occasional on-call pager rotation. Roles and Responsibilities: Requirements gathering Systems Analyst and Design Strong analytical and problem solving skills Data warehouse modeling and development experience Create ETL Detail Design in Teradata environment Perform process and performance tuning Document project lifecycles and ensure SOX compliance Provide production support for applications. Basic Qualifications: To be considered for this position, you must minimally meet the knowledge, skills, and abilities listed below: Bachelor's Degree and 5 years experience developing Data Warehouses. Additional experience in lieu of a degree will be considered Strong knowledge of database analysis and SQL design for Teradata version 14 and above. Strong knowledge of Teradata utilities including MLOAD, Fastload and TPUMP and new features. Strong Data Warehouse and Data Modeling experience Strong UNIX experience Knowledge of Windows, and Linux operating systems Excellent communication skills as position require interaction with customer. Research, troubleshooting and problem solving skills Experience with performance tuning and space reclamation Must be able to obtain Position of Public Trust clearance Preferred Qualifications: Candidates with these desired skills will be given preferential consideration: Teradata Certification Knowledge of Ab Initio UNIX Shell Scripting Test script creation and documentation Experience or knowledge of AGILE methodology Local to the Raleigh, NC area Qualifications Bachelor's Degree and 5 years experience developing Data Warehouses. Additional experience in lieu of a degree will be considered Additional Information

Similar Jobs

More Jobs at comtecinfo

More Information Technology Jobs

Find similar Systems Software Analyst / Engineer (ETL/Teradata) jobs: