Hello, Hope you are in the best of your health and spirits.
Please find the below Job Description and let me know your interest ASAP..!! *Position: ETL/Datawarehouse Developer * *Location : Wilmington, DE* *Duration: Long term* *Send resumes to a...@clearthoughtsolutions.com <a...@clearthoughtsolutions.com>* *Need EAD OPT/GC, GC and USC Only* *Top Three Skills: * 1) MPP (Shared nothing) Database Experience 2) Unix Shell Scripting 3) SQL Programming Language 4) ETL - (not specific - informatica, ab initio etc) 5) Data Modeling - design database, tables and structures needed. Greenplum, Teradata, Hadoop a BIG plus, and the majority submitted should have that, but if candidates have Consumer Bank Marketing Analytics experience and they are sharp, we are willing to train a couple. Job Description: *TOP SKILLS: * 1) MPP (Massive Parallel Processing) database experience – Shared nothing architecture; database analytics (Teradata, vertica, greenplum, Sybase IQ) 2) Unix/Shell programming 3) SQL – programming language 4) ETL – no specific tool (ab initio, informatica etc) 5) Data modeling: design a database know the tables/structures needed (previous experience from a DW team would be great) Hadoop is the futuristic platform (currently using greenplum). With big data technologies, the individual will be able to stay on the team longer. Someone who does not have this experience is OK, but want someone that is interested in moving in this direction; reading/dabbling with it at hope – this is an opportunity to bring someone’s career to the next level. *THE PROJECT: * This team is building a next generation marketing/digital analytical platform. Every time a JPMC ad is used, a record flows into the database of this particular team; they are leading with billions of records. The goal of this is to determine which advertisements are working, demographically, geographically, page placement effectiveness etc. Internet marketing is cutting edge and very exciting. Someone who can take the data and understand it – this is a great team to be on and have exposure to this. The information captured by this group will transform into management dashboards that are very visible among executives. *DAY TO DAY/Additional notes:* • Will be working with the business- write documents, read/analyze them and design a solution à take the solution to proposal with the business and determine course of action from there • Design tables – ETL processes, load data, scripting --- will be building the solution from end to end – Ingestion to loading the data. • Will be responsible for unit testing and writing implementation plan • Most developers will take on a project and work on that through completion – they will be the POC/SME. Need someone with strong communication skills as they will be on meetings with the business. Must be OK with writing documentation • Should be able to discussed complex/details data problems • Need someone that is independent; there is not a significant amount of management oversight • Like developers that can execute across the lifecycle/delivery of project • Candidate should be well rounded – be able to program, but also speak to business with strong understanding of SDLC; ability to read documents, and come up with design. The role is heavy in software design, development, testing, implementation planning, and communication – but operating at the application level. I don’t need architects making PowerPoint slides and driving technology strategy – we have people that do that (like me). So I don’t architecture is the right word. Application design and development is more appropriate. At best this is application architecture. The Senior SQL Developer will be working on the Chase Analytics Platform (CAP) team supporting Consumer Banking’s (CCB) Marketing Analytics organization. CCB Marketing Analytics is building a state of the art analytical technology stack to help increase the efficiency and effectiveness or marketing campaigns. A key goal is execute cohesive marketing strategies across lines of business and channels at the customer level. The CAP platform is a big data platform leveraging Hadoop, Greenplum MPP relational database, Tableau for dashboards and reporting, and best of breed ETL technologies for ingesting and transforming data. The individual is going to be part of a dynamic team of highly talented individuals and will be encouraged to contribute ideas during analysis, design, build and implementation. *Responsibilities shall include but not be limited to:* • Write high performing SQL (DML, DDL), triggers, stored procedures, and packages • Write Linux/UNIX shell scripts (e.g. BASH) to execute ETL processes • Build end-to-end ETL processes that ingest, transform, and publish highly refined analytical data sets • Construct data models and tables on relational databases to ingest raw data & design and implement aggregate tables and views supporting high performance reporting • Work with other developers to facilitate creation of high performing data centric components and applications *Qualifications:* • Bachelor's degree in computer science, MIS or technical area generally required. Will accept any suitable combination of education, training and expereince • Minimum of 4-8 years of diversified experience working database management systems such as Oracle, Sybase, and Teradata. Experience with MPP databases (especially Greenplum) is a significant plus. • Strong programming experience in UNIX Shell Scripting • Experience with writing packages, stored procedures, triggers, and complex analytical queries, and experience in tuning complex queries are necessary • Experience (or familiarity & interest) working with big data technologies such as Hadoop • Experience working in an analytical domain such as data warehousing, business intelligence, or data mining • Experience or familiarity with at one common ETL platform • The individual must be self-starter, independent, motivated, detail and quality oriented, proud of the product(s) he/she develops, and an excellent team member • Excellent problem solving skills are required • Experience in the web, financial services, or marketing industries is preferred • The individual must have experience working in test-driven and highly iterative environment • Ability to analyze data and business problems to help drive solution designs *Thanks & Regards,* *Adam Brad* ERP/EAI SERVICES |Consulting – Development – Staffing Tel Direct: 919-386-2044 | Fax 347-296-3797 Email: *a...@clearthoughtsolutions.com* <s...@clearthoughtsolutions.com> | *www.clearthoughtsolutions.com* <http://www.clearthoughtsolutions.com/> IM: adam.c...@gmail.com <d.ashokre...@gmail.com> *Partners in your Thought…* *Gateway to Succes* We respect your Online Privacy. This is not an unsolicited mail. Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a remove in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses which might be diverting the e-mails to you or click on this link to be removed. Remove link: mailto: a...@clearthoughtsolutions.com?subject=Remove_me <s...@clearthoughtsolutions.com?subject=Remove_me> We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "US_IT_ Jobs" group. To unsubscribe from this group and stop receiving emails from it, send an email to chandrakants+unsubscr...@googlegroups.com. To post to this group, send email to chandrakants@googlegroups.com. Visit this group at http://groups.google.com/group/chandrakants. For more options, visit https://groups.google.com/d/optout.