jobin Andrews

• Implemented automated ETL/ELT pipelines using tools like Matillion, Snowflake, and PostgreSQL to streamline ETL from SEO, SEM, and Web Analytics platforms to meet client business KPIs, calculations, and filtering requirements. • Created dashboards and reports that provide actionable insights into SEO, SEM, and Web Analytics performance based on client specifications. • Utilized Python-based machine learning models to predict user behavior patterns and optimize digital marketing strategies

• Utilized PostgreSQL and Tableau extensively for detailed reporting and data analysis, providing critical insights that drove business strategies and operational improvements. • Developed and maintained interactive dashboards and reports in Tableau to monitor key business metrics and performance indicators. • Extracted, transformed, and loaded (ETL) data using PostgreSQL to ensure accurate and up-to-date information for analysis.

• Developed and optimized ETL processes using Azure Data Factory and Azure Blob Storage. • Migrated data from on-premise servers to Azure Blob Storage using Azure Data Factory • Configured Linked Services, Datasets, and Schedule Triggers in Azure Data Factory for efficient data flow and scheduling. • Developed ETL(Informatica) mappings for extracting data from various sources, including Oracle databases, policy management systems etc

• Provided DBA support for production, QA, and development teams. • Performed routine maintenance such as query tuning and performance analysis. • Took logical backups using export and import utilities in development and QA environments. • Managed tables, views, and materialized views. • Created users and granted specific privileges and roles. • Installed, upgraded, and managed Oracle 10g and 11g RAC databases.

• Performed routine database maintenance such as monitoring disk space alerts, tablespace, and archive destination alerts. • Handled export and import at the table and schema levels. • Transferred data and schemas from Oracle to .csv files. • Provided connectivity and troubleshooting for connectivity problems between databases and client applications. • Managed storage tasks including creation and maintenance of data files and tablespaces.

• Handled SQL development, query tuning, and comprehensive database administration. • Ensured optimal database performance through regular maintenance and troubleshooting. • Managed backup and recovery processes, implemented security measures, and supported database schema design to meet business requirements.