Work From Home Pentaho Data Integration Jobs (NOW HIRING)

Job Summary:
Nextiva is seeking a result-oriented Sr Data Warehouse Engineer to join Omega Solutions, Inc. The role involves managing multiple assignments in an agile environment, collaborating with business users and reporting analysts to develop Business Intelligence solutions, and optimizing ETL processes.
Responsibilities:
• Work closely with Business stakeholders (Finance, Sales, Marketing and Customer Relations) and reporting Analysts.
• Create/manage source to target mapping documents and validate business rules with reporting analysts to ensure mapping accuracy.
• Design, Develop, Test, Deploy and manage ELT/ETL processes using Pentaho DI(Spoon).
• Work with business users, subject matter experts, project managers, software engineers and testers to gather and clarify requirements
• Provide Database and ETL Solutions that are in alignment with Nextiva standards and best practices.
• Perform code reviews/Release management/prod deployment.
• Work with business users/analysts on ad-hoc financial audit reports requests.
• Provide operations support to data warehouse, reporting tool and Callidus commissions tool.
• Document steps needed to migrate database and ETL objects between various environments including Dev, QA, and Prod.
• Validate accuracy of data between multiple systems and document data gaps.
• Communicate issues, risks, and concerns proactively to project management.
• Document ETL process thoroughly to allow peers to assist with support as needed.
• Self-sufficient and strong communication skills (must be able to work with external groups/departments).
• Investigate data issues, identify root problems and fix data in the production environment.
• Manage/Improve Pentaho Data Integration framework.
Qualifications:
Required:
• 10+ years of proven experience in multiple database platforms, including Oracle, SQL Server, Teradata and Postgres.
• 10+ years of experience in design, development, deployment and support activities using ETL tools Informatica, Pentaho, Talend or SSIS.
• 5+ years of experience in DW production support, troubleshooting and resolving data load errors.
• Minimum 2 years of experience in consuming data from REST API's and Kafka events.
• Minimum 2 years of experience with JSON, XML and CSV sources.
• Strong Analytical and dimensional modeling background is required.
• Demonstrated ability to take initiative, solve complex data problems and make sound decisions.
• Advanced experience with Data visualization tools (Tableau, Power BI).
• Experience in designing highly available Data Warehouse architecture, including identifying and deploying appropriate replication and monitoring capabilities for operational effectiveness.
• Demonstrated experience in all phases of software development including requirements analysis, design, coding, testing, debugging, implementation, and support.
• Demonstrated expertise in designing and implementing ETL/ELT processes using established industry best practices.
• Strong experience in Relational Data Modelling and Dimensional Data modeling (starschema) and slowly changing dimensions.
• Advanced experience in writing ad-hoc complex SQL Queries (Oracle and Postgres). Query optimizations and performance improvements.
• Minimum 5 years of experience with Database procedural languages(PL/SQL, PG/SQL).
• 5+ years' experience with the analysis of business processes, workflow, data mapping and cross-data integration in a complex data warehouse environment.
• In depth understanding of data cleansing, data auditing, data profiling, data modeling, entity-relationship modeling and dimensions modeling.
• Experience in Java, python programming.
Preferred:
• Informatica Power Center, Informatica iics,Talend, Data Stage, Microsoft SSIS or similar ETL tool.
• Pentaho experience is a big plus.
• Oracle 12c, Postgres, AWS RDS.
• Dimensional Data Modelling.
• Microsoft Power BI.
• Advanced SQL, PL/SQL, Procedures and Functions.
• Oracle BICC, Salesforce(Nice to have).
• Postman, Rest API, JSON, XML.
• Java or Python is a plus.
• Confluence,Sharepoint, Git and Jira.
• Excellent written and oral communication.
Company:
Omega was incorporated in 2007 in the State of California to offer high end IT Solutions ranging from IT Software and product development to technology deployment and specialize in providing software solutions to diverse business sectors in USA and World-wide. Founded in 2007, the company is headquartered in Santa Clara, USA, with a team of 11-50 employees. The company is currently Early Stage.