Senior ETL Developer With Pentaho

Title: Sr ETL Developer with Pentaho Location: Onsite Day One - Washington, DC (2 days a week, hybrid model), Also open for initial remote for 3 months. Long Term Contract /Full Time Senior - Data integration (ETL) Developer(Pentaho) Job Description • Contribute substantially to the business analysis, design, development, testing, and deployment of enterprise data warehouse (EDW). • Develop code to support unique business requirements and regulatory mandates. • Senior ETL Developer will configure and customize the chosen ETL tool. • Optimally leverage the ETL tool components for developing efficient solutions for data management, conversion, migration, and integration • Deploy and customize Standard Architecture components • As a Senior ETL Developer, you will mentor client personnel. Train junior staff on the Integration Methodologies and related supplemental solutions • Support development of task plans including schedule and effort estimation, under the guidance of an ETL architect • Strong individual contributor in complex Data Warehousing and Business Intelligence project implementations; Leadership experience a plus • Proven experience in working directly with business customers • Strong SQL skills including complex query building and query performance tuning • Data analysis skills - ability to dig in and understand complex models and business processes • SQL Server, PostgreSQL, My SQL, HP Vertica, or Teradata database experience Requirements • ETL development experience on Pentaho Data Integration, SSIS and Columnar databases (HP Vertica, Redshift , Teradata etc.). • Experience on OLTP and OLAP operations. • Expert level Knowledge of SQL and Pl/SQL scripting. • Excellent communication skills should be able to gather requirements and translate to the developers. • Strong understanding of Data warehousing design concepts/skills • Data profiling experience. • Defining and implementing data integration architecture. • Skilled at optimizing ETL performance, able to identify and resolve performance issues in a variety of operational settings swiftly and effectively. • Demonstrated ability to analyze data concerning production volumes and batch schedules. • Proven problem-solving/problem resolution abilities. Preferred Requirements • Dimensional data modeling skills(Logical, physical, conceptual). • Familiar with Agile Development Methodology. • Tableau or an equivalent Business Intelligence/reporting technology. • Control-m scheduling tool. • Proficiency in scripting (in order of preference): Python, Perl. Requirements: • ETL development experience on Pentaho Data Integration, SSIS and Columnar databases (HP Vertica, Redshift , Teradata etc.). • Experience on OLTP and OLAP operations. • Expert level Knowledge of SQL and Pl/SQL scripting. • Excellent communication skills should be able to gather requirements and translate to the developers. • Strong understanding of Data warehousing design concepts/skills • Data profiling experience. • Defining and implementing data integration architecture. • Skilled at optimizing ETL performance, able to identify and resolve performance issues in a variety of operational settings swiftly and effectively. • Demonstrated ability to analyze data concerning production volumes and batch schedules. • Proven problem-solving/problem resolution abilities.