• Worked extensively with AWS services like EC2, S3, VPC, ELB, Auto Scaling Groups, Route 53, IAM, CloudTrail, CloudWatch, CloudFormation, CloudFront, SNS, and RDS. • Developed Python scripts to parse XML, JSON files and load the data in AWS Snowflake Data warehouse. • Design and Develop ETL Processes in AWS Glue to migrate Campaign data from external sources like S3, and Parquet/Text Files into AWS Redshift. • Performed several Banking Centre level performance analyses aimed at… Show more • Worked extensively with AWS services like EC2, S3, VPC, ELB, Auto Scaling Groups, Route 53, IAM, CloudTrail, CloudWatch, CloudFormation, CloudFront, SNS, and RDS. • Developed Python scripts to parse XML, JSON files and load the data in AWS Snowflake Data warehouse. • Design and Develop ETL Processes in AWS Glue to migrate Campaign data from external sources like S3, and Parquet/Text Files into AWS Redshift. • Performed several Banking Centre level performance analyses aimed at streamlining and optimizing the sales process and monitoring sales of certain high-value checking products. • Build a program with Python and Apache beam and execute it in cloud Dataflow to run Data validation between raw source files and big query tables. • Building a Scala and spark-based configurable framework to connect common Data sources like MYSQL, Oracle, Postgres, SQL Server, Salesforce, and Big query and load it in big query. Show less

• 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 Centre 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 from different… Show more • 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 Centre 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 from different sources like SQL Server tables, XML files, and Flat files then transformed according to business rules using Informatica and loaded the data into 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 Show less

• Involved in gathering business requirements, logical modelling, 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… Show more • Involved in gathering business requirements, logical modelling, 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 and managed policies for S3 buckets and used S3 bucket and Glacier for storage and backup on AWS. Show less

• 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 the Talend ETL tool into the 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… Show more • 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 the Talend ETL tool into the 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 the Business. • Implemented FTP operations using Talend Studio to transfer files between network folders as well as to FTP server using components like TFileCopy, TFileAcrchive,TFileDelete, TCreateTemporaryFile, TFTPDelete, TFTPCopy, TFTPRename, TFTPut,TFTPGet, etc. Show less

• Worked on analyzing Hadoop cluster and different big data analytic tools including, HBase database and Sqoop.• Responsible for building scalable distributed data solutions using Hadoop.• Implemented nine nodes CDH3 Hadoop cluster on red hat LINUX. Involved in loading data from LINUX file system to HDFS.• Worked on installing cluster, commissioning & decommissioning of data node, name node recovery, capacity planning, and slots configuration. Created HBase tables to store variable… Show more • Worked on analyzing Hadoop cluster and different big data analytic tools including, HBase database and Sqoop.• Responsible for building scalable distributed data solutions using Hadoop.• Implemented nine nodes CDH3 Hadoop cluster on red hat LINUX. Involved in loading data from LINUX file system to HDFS.• Worked on installing cluster, commissioning & decommissioning of data node, name node recovery, capacity planning, and slots configuration. Created HBase tables to store variable data formats of PII data coming from different portfolios.• Worked in GCP-based Big Data deployments (Batch/Real-Time) leveraging Big Query, BigTable, Cloud Storage, PubSub, Data Fusion, Dataflow, Dataproc, etc. Show less