Rithika K Email & Phone Number

Maryland, United States

• 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. • 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. • Worked on documentation of all worked Extract. Transform and Load, Designed, developed and validated, and deployed the Talend ETL processes for the Data Warehouse team using PIG, Hive. • Applied required transformation using AWS Glue and loaded data back to Redshift and S3. • Experience in analyzing and writing SQL queries to extract the data in JSON format through Rest API calls with API Keys, ADMIN Keys, and Query Keys and load the data into the Data warehouse. • Designed and implemented ETL pipelines between from various Relational Data Bases to the Data Warehouse using Apache Airflow. • Worked on Data Extraction, aggregations, and consolidation of Adobe data within AWS Glue using PySpark. • Developed SSIS packages to Extract, Transform and Load ETL data into the SQL Server database from the legacy mainframe data sources. • Worked on Building data pipelines in airflow in GCP for ETL-related jobs using different airflow operators. • Worked on Postman using HTTP requests to GET the data from RESTful API and validate the API calls. • Created custom T-SQL procedures to read data from flat files to dump to SQL Server database using SQL Server import and export data wizard.

New York, United States

• 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. • Data Extraction, aggregations, and consolidation of Adobe data within AWS Glue using PySpark. • Developed data engineering and ETL python scripts for ingestion pipelines that 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 into Redshift - BI Development for multiple technical projects in parallel. • Using g-cloud function with Python to load Data into Big query for on-arrival CSV files in GCS bucket. • Worked with EMR, S3, and EC2 services in the AWS cloud and migrated servers, databases, and applications from on-premise to AWS. • Tuning SQL queries using Explain analyzing the data distribution among AMPs and index usage, collecting statistics, the definition of indexes, revision of correlated subqueries, usage of Hash functions, etc…. • Creating, maintaining, supporting, repairing, and customizing System & Splunk applications, search queries, and dashboards.

Indianapolis, Indiana, United States

• 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. • Developed Spark scripts using Python on AWS EMR for Data Aggregation, Validation, and Adhoc querying. • Performed data analytics on Data Lake using py-spark on the Data bricks 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, and SSRS. • Design and develop new Power BI solutions and migrate reports from SSRS. • Developed and executed a migration strategy to move Data Warehouse from Greenplum to Oracle.

Hyderabad, Telangana, India

• 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. • 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 of Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, and embedding views by integrating with other platforms. • Experience in data profiling & various data quality rules development using Informatica Data Quality (IDQ).• Create new UNIX scripts to automate and handle different file processing, editing, and execution sequences with shell scripting by using basic UNIX commands and ‘awk’, and ‘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. • Write Scala program for spark transformation in Dataproc, Impala, Spark, Unix Shell Scripting

Hyderabad, Telangana, India

• 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.• Worked on building dashboards in Tableau with ODBC connections from different sources like Big Query/ presto SQL engine.• Implemented a script to transmit suspiring information from Oracle to HBase using Sqoop.• Implemented best income logic using scripts and UDFs.• Implemented test scripts to support test driven development and continuous integration.• Worked on tuning the performance queries.• Worked with application teams to install operating system, Hadoop updates, patches, version upgrades as required.• Responsible to manage data coming from different sources. Involved in loading data from UNIX file system to HDFS.• Load and transform large sets of structured, semi structured, and unstructured data• Cluster coordination services through Zookeeper. Experience in managing and reviewing Hadoop log files.• Installed Oozie workflow engine to run multiple Hive and jobs.