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
Bachelor's Degree and 5 years experience developing Data Warehouses. Additional experience in lieu of a degree will be considered
All your information will be kept confidential according to EEO guidelines.
Skills Required
- Bachelor's degree or equivalent experience with 5 years developing Data Warehouses
- Strong SQL and Teradata (v14+) knowledge
- Experience with Teradata utilities: MLOAD, FastLoad, TPUMP
- ETL detail design and Data Warehouse modeling and development
- Strong UNIX experience
- Knowledge of Windows and Linux operating systems
- Experience with performance tuning and space reclamation
- Production support experience and willingness to participate in on-call pager rotation
- Excellent communication, research, troubleshooting and problem-solving skills
- Ability to obtain Position of Public Trust clearance
- Experience or knowledge of AGILE methodology
- Teradata Certification
- Knowledge of Ab Initio
- UNIX Shell Scripting
- Test script creation and documentation
- Local to the Raleigh, NC area
What We Do
ComTec has the experience of working with customers in multiple engagement models – Onsite, Offshore and Hybrid. We operate as a fully responsible IT partner to businesses, offering a consulting based technology solution suite that helps customers achieve their IT and business objectives. Our engagement model is customer-centric thereby giving you access to our talented pool of experts who design and develop tailor-made solutions for enterprises. Our offerings include Digital Services • Robotic Process Automation • Big Data and Analytics • Cloud Computing • Mobile Solutions • DevOps Application Services • Business Applications • QA and Testing • Microsoft Solutions • Oracle Solutions • PeopleSoft Solutions • SAP Solutions • Integration Services • Salesforce Practice • eCommerce Services Infrastructure Services • Data Center Operations • Desktop Management • Network and Telecom • Cyber Security • Service Desk • Splunk ComTec designed and developed ESF8 portal that is a one stop solution for all the hospitals, nursing homes, adult care facilities and the executive team. Functionality of ESF8 includes: Keep the status and census information of all facilities accurate at all times through Resource Management Provide messaging platform for phone, email and text communication that is available to all users through Messaging Create, deploy and analyze professional surveys to facilities or individuals through Survey Create, store, and share documents securely or anonymously to all partners through Document Portal Ease the burden of grant management accountability, spending agreements and inventory through Grant Management We have built strategic partnerships with several technology leaders Microsoft Gold Partner Oracle Gold Partner Redhat Solutions Partner UIPath Partner
