| :Hybrid in NC::USC or GC only ::LinkedIn is must at Remote, Remote, USA |
| Email: [email protected] |
|
From: sonali gupta, kpg99 [email protected] Reply to: [email protected] Title:Database Developer Location:Raleigh, NC HYBRID Visa:USC/GC only Type:6 + months Roles and Responsibilities: Experience with relational database design, implementation and/or data load experience on large database implementations Design, develop, test, performance tune, deploy and support Teradata database components. Develop complex database processes with BTEQ containing batch or ETL functionality Responsible for performing performance tuning Teradata, SQL, Unix Scripting Loading data from various data sources and legacy systems into Teradata production anddevelopmentwarehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance. Requirements gathering, design, development, testing and documentation Design logical and physical ERD diagrams, process flow diagrams, or related data processing documentation Debug, troubleshoot, root cause analysis and resolve issues within SLA Assist Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements Participate in project work groups with Subject Matter Experts and stakeholders to understand data specific needs Participate in performance tuning activities and unit testing Provide production deployment and production support as needed Analyzing and converting business requirements to technical requirements, followed by designing and implementing the solutions Involved in all aspects of the software development life cycle; - and demonstrate abilities to learn both the business processes as well as new and existing technologies Required Skills/Abilities: Bachelors degree plus at least 7 years of professional experience 3+ years of experience in designing, creating and developing with Teradata Experience in developing logical and physical data models using data modeling tools such as Rational Data Architect, Erwin, Oracle Developer, other tools Strong programming/development skills using BTEQ and SQL (Procedures, functions, Macros) and batch coding skills, and parallel processing Experience designing OLAP systems Strong SQL development, SQL analytics and tuning skills Excellent analytic, troubleshooting and performance tuning skills Detail oriented with strong problem solving skills Ability to analyze complex and large amounts of data Strong communications skills (both verbal & written) Other Please note this is not a database administration position Security Requirements Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information Must be able to obtain and keep a Sensitive Clearance Must be a U.S. Citizen or Green Card holder and have been livingin the U.S. for at least the last five years Must not have traveled outside of the United States for more than 180 days in the last fiveyears All candidates will be subject to a pre-employment background investigation and drug screening per our client's requirements. |
| [email protected] View All |
| 11:36 PM 19-Oct-22 |