*Send available consultants profile at....... **[email protected] <[email protected]>*
*Role:* Ab Initio Developer for either development or production support *Travel Expenses:* None (prefer local or willing to relocate to the work site for the duration of the project) *Start Date:* As soon as resource is identified/pass through background check whichever is earlier *Duration: *To be determined but minimal of 6 months (depending on the role) *Location: *downtown San Francisco, CA *On site schedule:* 9-5 pm, Monday - Friday *Interview: *Yes Technical skills : Minimum of 2 to 3 years of Ab Initio, Unix, Teradata experience preferred Non-Technical skills: Good Communication, Professionalism Responsibilities: • Work with engineers from disparate source systems for data acquisition, transformation and data quality. • Understand the structure and meaning of data coming in the source systems through data profiling and applying business content to the data. • Define business rules and transformations for data coming from source systems into the data warehouse to match the business application of the data. • Design and develop production level data loads into the data warehouse that are optimized for fast performance and minimal maintenance. • Design dimensional data models that work well with the other components of the BI stack, like the database and reporting tools. • Identify data quality issues and their root causes. Implement fixes and design data audits to capture the issues in the future. • Implement indexing and partitioning strategies that maximize query performance based on how users access the data. Skills, Experience & Requirements: • Minimum of 2-3 years of Ab Initio experience (GDE and EME) and Unix experience • Minimum of 3-5+ years data warehouse and ETL processing experience • Teradata experience preferred; Excellent SQL skills required • Ability to explain technical concepts to non-technical associates and vice-versa a must • Experience with ETL design and code development in Ab Initio • Experience analyzing customer behavior data in a web-based environment or operations-based data preferred. • Interaction with computer systems and analytical tools supporting data analysis (MicroStrategy preferred). • Experience using rapid prototypes to develop information requirements. • Excellent communication skills and professionalism are must *Anuj Rai* *Sr. Recruitment Manager* *Zenith tech Solutions* *Desk: 518-621-0048Fax: 518-244-49773 park Hill* *Albany, NY 12204* *Email Id:- [email protected] <[email protected]>* *Gmail:- [email protected] <[email protected]>* *Website:- www.zenithtechsolutions.com <http://www.zenithtechsolutions.com/>*
