Vishwaja M

Vishwaja M

About

Detail

Azure Data Engineer II MetLife
Philadelphia, Pennsylvania, United States

Contact Vishwaja regarding: 

work
Full-time jobs
Starting at USD80/hour

Timeline


work
Job

Résumé


Jobs verified_user 0% verified
  • MetLife
    Sr. Azure Date Engineer
    MetLife
    Apr 2021 - Current (4 years 3 months)
     Involved in the full lifecycle of projects, including requirement gathering, system design, application development, enhancement, deployment, maintenance, and support.  Experience in planning and developing roadmaps and deliverables to advance the migration of existing SSIS on-premises systems/applications to Azure cloud.  Used Azure architecture decision making Architect and implemented ETL and data movement solutions using Azure Data Factory (ADF), SSIS.  Develop, and design data models, data structures, and ETL jobs for data acquisition and manipulation purposes.  Experience in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data  Experience with Informatica Performance Tuning by findin
  • BNY Mellon
    Sr. Data Engineer
    BNY Mellon
    Jan 2019 - Mar 2021 (2 years 3 months)
     Developed data pipeline using Python, and Hive to load data into data links. Perform data analysis and data mapping for several data sources.  Converted several Informatica workflows into Hadoop, Spark, and Scala.  Extensively worked on R, and Python (NumPy, SciPy, Pandas, Matplotlib, NLTK, Tensor Flow, and Scikit- learn).  Handled operations and maintenance support for AWS cloud resources, including launching, maintaining and troubleshooting EC2 instances, S3 buckets, Auto Scaling, DynamoDB, AWS IAM, and Elastic Load Balancers (ELB) and Relational Database Services (RDS). Also created snapshots for data to store in AWS S3.  Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from diff
  • P
    Data Engineer
    PepsiCo
    Nov 2017 - Dec 2018 (1 year 2 months)
     Extensive involvement in Data Analysis, Data Cleansing, Requirements gathering, Data Mapping, Functional and Technical design docs, and Process Flow diagrams.  Created Tableau Dashboard for the top key Performance Indicators for the top management by connecting various data sources like Excel, Flat files, and SQL Database.  Involved in developing Python scripts, Informatica, and other ETL tools for extraction, transformation, and loading of data 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.  Optimization of Hive queries using best practices and the right parameters and using technologies like
  • Cognizant
    Data Warehouse Developer
    Cognizant
    Jun 2015 - Oct 2017 (2 years 5 months)
    • Experienced in Designing the specifications, Design Documents, Data modeling and design of data warehouse. • Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements. • Responsible for checking data in DynamoDB tables and to check EC2 instances upon running for (DEV, QA, CERT and PROD) in AWS. • Experience working on Snowflake AWS Data Cloud to unite there siloed data, easily discover and execute diverse analytic workloads. • Experienced in creating the Logical Model using Normalization and Abstraction technique. • Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2). • Cleansed the source data, extracted and transformed data with business rules, and built reu
Awards verified_user 0% verified
  • D
    Deans list