Vertica and Extract Transform Load Engineer

Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

• Design, Develop, Test and deliver projects with Data Warehousing concepts & tool 
• Experienced with dimensional database concepts, relational database concepts, data integration initiatives, data movement initiatives · 
• Define technical requirements, technical and data architecture for big data processing and building highly available and scalable services · 
• Implement/Develop methods and technology for keeping data secure and private · Work with noisy, dirty and unstructured data. 
• Data cleansing, scraping unstructured data and converting into structured data · Implement data processing using map reduce, pig, hive scripts, Hadoop streaming, kafka, scala, spark and scheduling jobs 
• Effectively creates clear and concise documentation, produces source to target maps, understands and validates metrics · 
• Performance tuning of a columnar database /NoSQL database like Vertica

Additional Information

GOOD COMMUNICATION SKILLS

DURATION: 6+ Months Contract

INTERVIEW: Telephone / Skype