Priyanka Vijay

Experience

• 

  Tech Mahindra

  Apr 2011 - Aug 2013

  ETL developer

  Worked as an ETL Developer for 2.5 years. As an ETL developer, below were my roles and responsibilities:• Engaged in Data Profiling and Data Analysis.• Prepared Data Models using ER Studio Data Architect.• Prepared ETL specifications after complete analysis of the detailed data.• Developed business intelligence and ETL solutions that help end users access and analyses data in the data warehouse, data mart, or operational systems.• Responsible for handling client calls and understanding the requirements and the existing business models.• Involved in major enhancements on the developed projects.• Involved in developing the ETL strategy to populate the Data Warehouse from various source systems feeds using Informatica Power center.• Designed ETL code for extracting data from various sources involving flat files, Mainframes and relational tables.• Responsible for preparing test cases for unit testing and regression testing.• Involved in the preparation of documents: SRS, SDS, Impact Analysis, Test Plan and ETL specs.• Responsible for effectively troubleshoot data errors and issues in QA and production. Show less

• 

  Deloitte

  Aug 2013 - Feb 2015

  Business Technology Analyst

  Worked as a Business Technology Analyst for 1.7 years. Below were my roles and responsibilities:• Responsible for the generation of various ETL extracts which includes Member Eligibility, Medical and Pharmacy Claims, and Provider along with Data Quality and Error Log Reports and sending to the client server using ftp transfer. • Responsible for understanding existing business model and customer requirements. • Designed ETL code for extracting data from various sources involving flat files and relational tables. • Responsible for resolving issues during loads or in applications. Show less

• 

  Accenture

  Mar 2015 - Aug 2017

  Working as a Hadoop developer in Accenture since March 2016. Below are my current responsibilities:• Involved in analysis, design, development and consulting, production release and migration with exposure to Agile Scrum Methodology.• Using Big Data technologies – Hadoop HDFS, Hive, Spark- Scala, HBase, Sqoop to develop the code.• Reading data from salesforce and oracle using Talend and Informatica.• Using Spark for performing transformation logic.• Automation of code for reading the source data from SOAP Web Services and placing in HDFS using shell scripting which used to be done before using manual inserts, deletes and updates.• Worked on a generic job control mechanism (can run hive, spark, UNIX shell scripts and informatica jobs) that can be used in other Hadoop projects.• Expertise in working with Informatica Power Center (Informatica 9.x) and Teradata for designing, developing and maintaining various ETL applications.• Good understanding of the SDLC process and agile methodology.• Involved in coordinating the efforts of design, development, test, code migration, change management and support services to client end users.• Experience in doing R&D/debugging and learning new technologies and tools. Show less Worked as a Senior Software Developer in Accenture since March 2015. Below were my responsibilities:• Responsible for analysis, planning, designing ETL solutions and performing all jobs in an efficient manner.• Responsible for grooming team members to learn and understand the business models and helping in performing all the jobs effectively.• Assigned Offshore Point of contact for all the issues and information related to the project within few months of joining.• Involved in clients calls on various functional and technical design requirements.• Involved in implementing the functional requirements in terms of ETL code that helps the clients and reporting team to generate reports effectively.• Responsible for Optimizing SQL Queries and performance tuning of Informatica code.• Involved in technical design discussions for offloading ETL code from Informatica to Hive.• Worked on Proof of concept for offloading the ETL code in Informatica to Hive.• Responsible for creating shell scripts for hive jobs. Show less

  • Hadoop Developer

    Mar 2016 - Aug 2017

  • Application Development Senior Analyst

    Mar 2015 - Mar 2016
• 

  JPMorganChase

  Aug 2017 - Oct 2022

  Big Data Developer
• 

  Wells Fargo

  Nov 2022 - now

  Lead Data Engineer