Pentaho Developer
Pentaho Developer
Location: Washington, DC 20005 (Hybrid 2 days/week onsite)
Duration: 12+ Months contract
Overall 12+ years of experience in IT.Must be hybrid no negotiations on this part.
Job Description:
- Contribute substantially to the business analysis, design, development, testing, and deployment of the 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 in OLTP and OLAP operations.
- Expert level Knowledge of SQL and Pl/SQL scripting.
- Excellent communication skills should be able to gather requirements and translate them 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.