oasisnawer.blogg.se - Pentaho data integration redshift

Pentaho data integration redshift code#

MS SQL: Server Database Administrator/Developer, BI, ETL, Pentaho, Informatica developer IDQ 9.1/9.5.1, Informatica Power Mart 6.x/5.x, Power Exchange, SQL Server Configuration, Replication, Virtualization.Visual Studio, C#.

Developed in Pentaho, Informatica, and Talend for Dashboards, Data Visualizations, Big Data Spark projects working on Tableau Engineer / Pentaho/ BI/Reporting platform to enable data access, analytic models, and data visualization.

Worked with Hadoop, Talend to architect, design and built Big Data solutions using Hive Hadoop, created dashboards, Data Visualizations

Generated Data Quality Dashboard, KPI Reports ETL, SSRS, Dashboard Data Visualizations, SQL, Databases, Data Management, Data Warehousing, Data Governance concepts.Used MS SQL Server, Pentaho, Informatica, Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis

Pentaho data integration redshift code#

Created ETL/Pentaho, Informatica, Talend jobs both design and code to process data to target databases.Developed complex ETL jobs from various sources such as SQL server, PostgreSQL and other files and loaded into target databases using Pentaho, Informatica, Talend OS ETL tool.Worked on Pentaho, Informatica, Talend/Informatica Integration Cloud Services, IaaS, PaaS, SaaS. Performed on Pentaho, Informatica, Talend Data Fabric ETL, Data warehouse concepts, Kimball, Star & Snowflake Schema, Fact/Dimension tables.Managed Error Handling, Performance Tuning, Error Logging, clustering and High Availability.Utilized with Pentaho(PDI) Kettle, Informatica IDQ, PowerCenter, MDM, data management, data integration/quality, and data governance Developed in Pentaho, Informatica, Talend for Big Data projects, Dashboard Designs, and Data Visualizations.Fifteen (15) years of experience working in Data Architect/Engineer, AWS, S3, Data Lake, Azure, Cloud Solutions, Redshift, ETL/Pentaho, Informatica, SSIS Data Integration development in the areas of design, development, analysis, implementation and support of data warehousing tools ETL, Pentaho, Informatica, Big Data Hadoop/Spark, HIVE, MS SQL Server, Dashboard, Tableau, SQL server, Oracle, UNIX/Linux, PostgreSQL on client/server.