We are looking for a Data Integration Lead for a leading client in New York. Must possess strong knowledge in metadata and data integration processes and methodologies 8+ years of data warehouse and data integration (including ETL patterns) design experience 5+ years in a direct role as a designer / lead for data integration and/or EDW systems 5+ years data warehousing and methodology experience 5+ years of data modeling ERD - Dimensional 4+ years ETL architecture including Ab Initio, IIS (Datastage) 4+ years of Agile development experience Must have advanced technical expertise with Oracle, complex PL*SQL, UNIX/LINUX in a large data environment. Understand SQL execution plan and how to tune a query. Advanced SQL and Advanced Analytical Functions such as windowing, partition by, ranking, pivoting etc. Technical expertise in distributed system architecture, design, and development Please email your profile to maria@coesyssolutions.com or call (347) 491-7977. Coesys Solutions will sponosor H1B for qualified candidates