Gowtham S Email and Phone Number

Involved in full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, Teradata, and Sybase into the final target database. Analyzed source data coming different sources like SQL Server tables, XML files and Flat files then transformed according to business rules using Informatica and loaded the data in to target tables.Involved in creating the Tables in Greenplum and loading the data through Alteryx for Global Audit Tracker.Analyzed large and critical datasets using HDFS, HBase, Hive, HQL, PIG, Sqoop and Zookeeper.Data Extraction, aggregations, and consolidation of Adobe data within AWS Glue using PySpark.Developed data engineering and ETL python scripts for ingestion pipelines which run on AWS infrastructure setup of EMR, S3, Glue and Lambda.Changing the existing Data Models using Erwin for Enhancements to the existing Datawarehouse projects.Used Talend connectors integrated to Redshift - BI Development for multiple technical projects running in parallel.Using g-cloud function with Python to load Data in to Big query for on arrival csv files in GCS bucket. Created iterative macro in Alteryx to send Json request, download Json response from webservice, and analyze the response data.Migrated data from Transactional source systems to Redshift data warehouse using spark and AWS EMR.Supported various business teams with Data Mining and Reporting by writing complex SQLs using Basic and Advanced SQL including OLAP functions like Ranking, partitioning and windowing functions, Etc.

Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, and performance tuning. Used SSIS to populate data from various sources, creating packages for different application data loading operations. Created various types of reports such as complex drill-down reports, drill through reports, parameterized reports, matrix reports, Sub reports, non-parameterized reports and charts using reporting services based on relational and OLAP databases. Developed and executed a migration strategy to move Data Warehouse from an Oracle platform to AWS Redshift. Built S3 buckets, managed policies for S3 buckets, and used S3 bucket and Glacier for storage and backup on AWS. Developed Spark scripts using Python on AWS EMR for Data Aggregation, Validation and Adhoc querying. Performed data analytics on DataLake using pyspark on databricks platform Designed and documented the entire Architecture of Power BI POC. Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server using SSIS,SSRS. Design and develop new Power BI solutions and migrating reports from SSRS.

Performed Data Analysis, Data Migration, Data Cleansing, Transformation, Data Import, and Data Export. Worked on Design, Development and Documentation of the ETL strategy to populate the data from the various source systems using Talend ETL tool into Data Warehouse. Devised PL/SQL Stored Procedures, Functions, Triggers, Views and packages. Made use of Indexing, Aggregation and Materialized views to optimize query performance. Created Tableau dashboards/reports for data visualization, Reporting and Analysis and presented it to Business. Implemented FTP operations using Talend Studio to transfer files in between network folders as well as to FTP server using components like tFileCopy,TFileAcrchive, tFileDelete, tCreateTemporaryFile, tFTPDelete, tFTPCopy, tFTPRename, tFTPut, tFTPGet etc. Design and develop spark job with Scala to implement end to end data pipeline for batch processing Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards. Knowledge in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms. Experience on data profiling & various data quality rules development using Informatica Data Quality (IDQ). Create new UNIX scripts to automate and to handle different file processing, editing and execution sequences with shell scripting by using basic Unix commands and ‘awk’, ‘sed’ editing languages. Integrate Collibra with Data Lake using Collibra connect API. Design and Develop ETL Processes in AWS Glue to migrate Campaign data from external sources like S3, ORC/Parquet/Text Files into AWS Redshift. Create firewall rules to access Google Data proc from other machines.