ETL Developer w/ Netezza

Employer
PeopleCom
Location
Washington, DC
Posted
Jul 17, 2017
Closes
Jul 20, 2017
Hours
Full Time
Job Description Title: Netezza DBA / ETL Developer Location: Washington, DC Terms: Full Time Regular Hire Visa status: US Citizen w/ ability to obtain Public Trust Clearance College Degree Overview: This is a great little company with great benefits. Management has a strong appreciation for technical people. Requirements · Design, develop, deliver, and implement database architectures/solutions specifically incorporating the Netezza and Oracle frameworks, Regular hands-on development required · Perform architecture design, prototyping of concepts to proof concept, development of standards, design and development of code and module design, development of testing, data solution debugging, design and implementation of a data solution · Convert design and user specification into database solutions. Ensure quality, functionality, reliability and usability of Netezza and Oracle database solutions · Develop database architectural strategies in Netezza and Oracle environments · Analyze business requirements/needs and design more efficient database solutions, tables, code and procedures to improve system performance · Work closely with Development, QA, Architects, Business Analysts and other IT staff to implement Netezza and/or Oracle Database Administration standards, policies, methods and procedures building consensus with all parties · Review project requests describing database user needs to estimate time and cost required to accomplish project · Analyze software requirements to determine feasibility of design within time and cost constraints. Provide guidance in best architectural practices in maximizing the database performance · Develop and deliver solid, scalable, robust solutions · Participate within the DBA team to troubleshoot any issues on the Netezza appliance and Oracle · Perform data analysis as required to scope projects, find bugs, and offer inferences into the product for the users · Perform Data Migration from SQL Server to Netezza and Oracle · Plans, coordinates and implements database change migration · Design Best Practices and efficient techniques to transfer data from various RDBMS databases to Netezza and Oracle · Design logical and physical data models using Embarcadero written in Netezza and Oracle SQL and SQL Server Procedures · Work both data modeler and DBA to implement physical model on an ongoing bases · Build and support required Netezza and Oracle database development and test environments · Troubleshoot difficult database problems, including slow running queries · Perform necessary maintenance activities for database infrastructure · Demonstrate database technical functionality, such as performance, security and reliability · Perform database Security design and implementation · Participate in recruiting related tasks based upon need · Other duties as assigned Qualifications: · 8 plus years of working with Netezza and Oracle · 7 years of experience in data analytics and reporting · 5 years ETL experience with SSIS or DataStage · 4 years of data modeling skills, especially for parallel databases · Mastery on Linux/shell script skills · Mastery of structured query language · Proficient at optimizing queries and tables in Netezza and Oracle · Proficient in multi-tasking and managing multiple projects, able to meet target completion dates · Proficient with Microsoft Office applications · Goal driven and highly motivated · Proven analytical and problem solving skills · Strong customer service skills and passion to work through obstacles to produce results · Demonstrable technical thought leadership and influencing skills · Strong oral and written communication skills · Strong organization and time management skills · Able to be flexible and adapt to change · Tableau experience highly desired Company Description PeopleCom provides professional recruiting services for employers seeking workforce solutions in the areas of: Government Contract Staffing Technology Staffing Staff Augmentation Marketing and Sales Experts Business Development Executives Senior Level Management Data Center Staffing Help Desk Staffing Call Center Staffing Temporary, temp-to-perm, and permanent placement services are available along with the new; proprietary PeopleNow contract for government contractors seeking to fulfill Federal Staffing requirements. Whether it is recruiting for organizations or finding the right organization for a job seeker, nobody does it faster, better and more cost effectively than PeopleCom