Kumar N Email & Phone Number

Atlanta, Georgia, United States

|Created robust and scalable ETL solutions by integrating extensive and diverse datasets from multiple platforms||AWS, comprising EC2, S3, CloudFront, DynamoDB, Lambda, Elastic File System, RDS, VPC, Direct Connect, Route53, CloudWatch, CloudTrail, CloudFormation, and IAM, facilitated the automation of operations||Experience on Migrating legacy data warehouse and other databases (SQL Server OracleDatabase10g/11g,Teradata 15.0, DB2) to Snowflake||Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators both old and newer operators|

Chicago, Illinois, United States

|Executed ETL processes using Azure Data Factory, T-SQL, Spark SQL, U-SQL Azure Data Lake Analytics, and Azure Databricks for seamless data ingestion, transformation, and analysis across Azure services||Propose a dataset creation protocol for data mining and modeling, and suggest ways to enhance data quality,effectiveness, and reliability|| Stage the API or Kafka Data(in JSON file format) into Snowflake DB by Flattening the same for different functional services||Executed Azure Data Bricks POC and utilized Azure services including HDInsight Clusters, BLOB, ADLS, Data Factory, and Logic Apps||Designed, developed, and implemented data integration workflows using Azure Logic Apps to automate ETL processes|

Littleton, Colorado, United States

|Developed Python scripts to parse XML and JSON files and load the data into the AWS Snowflake DataWarehouse||Built ETL pipelines to extract data from HDFS and load it into AWS Data Warehouse, leveraging technologies such as Apache Spark and Scala||Designed and architected multiple data pipelines for end-to-end ETL and ELT processes, including data ingestion and transformation||Strong background in data warehousing, business intelligence, and ETL processes using tools such as Informatica and AWS Glue. Experienced in working with large datasets and performing analysis||Developed a configurable Scala and Spark-based framework to connect common data sources (MySQL, Oracle, Postgres, SQL Server, Salesforce||Collaborated with marketing teams, integrating and processing data from diverse marketing tools such as CRM, automation platforms, and web analytics, enabling actionable insights and optimized campaigns through efficient data pipelines|

Minneapolis, Mn Hq. United States

| Implemented solutions for ingesting data from different sources and processing the stored data using Big Data technologies like Hadoop, MapReduce frameworks, HBase, and Hive||Utilized Sqoop to efficiently transfer data between databases and HDFS, employed Flume to stream log data from servers|| Imported millions of structured data records from relational databases using Sqoop import, processed them using Spark, and stored the data in CSV format on HDFS.||Took charge of designing and formulating the architecture, development, and engineering of Big Data solutions for the company.|| Installed and deployed the Hadoop clusters, managing node additions and removals, monitoring tasks, configuring the name-node, and performing backups.|

Hyderabad, Telangana, India

|Created SQL procedures, functions, triggers, and views to support OLTP and ETL applications||Utilized various SSIS control flow tasks and data transformations, such as data conversion, derived column, lookup, fuzzy lookup, conditional split, and aggregate transformations, as part of ETL processes.||Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse databases||Worked on the development, enhancement, and maintenance of internal and external reports/applications supporting various processes||Developed SSRS reports on SQL Server and had a good understanding of SSAS (SQL Server Analysis Services) and OLAP cube architecture|