Senior Pentaho Data Integration (ETL) DeveloperLocation: Washington DC (100% onsite – no flexibility)Duration: Contract/FulltimeJob DescriptionContribute 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 integrationDeploy and customize Standard Architecture componentsAs a Senior ETL Developer, you will mentor client personnel. Train junior staff on the Integration Methodologies and related supplemental solutionsSupport development of task plans including schedule and effort estimation, under the guidance of an ETL architectStrong individual contributor in complex Data Warehousing and Business Intelligence project implementations; Leadership experience a plusProven experience in working directly with business customersStrong SQL skills including complex query building and query performance tuningData analysis skills - ability to dig in and understand complex models and business processesSQL Server, PostgreSQL, My SQL, HP Vertica, or Teradata database experienceRequirementsETL 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/skillsData 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 RequirementsDimensional 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.