Data Engineer

Priyanka Nalawade

(M): +1-425-***-****,

E-mail: ******************@*****.***

Kirkland, Washington

SUMMARY

•IT professional with 5 years of expertise in Data, Analytics & Data Warehousing

•Strong experience in BI solutions including ETLs, Reporting, Dashboards.

•Solid experience in EAP, Hive, Hadoop.

•Strong exposure in Data Mart implementation and JSON code review.

•Deeply involved in requirement gathering, source system analysis, ETL Design in multiple projects.

•Extensively worked on ETL tool Ab Initio, Hive, Spark, SQL and Rules Harmony.

•Working knowledge in Shell scripting, SQL queries and UNIX commands.

•Experienced in Performance tuning, complex query optimizations and troubleshooting.

•Strong knowledge and experience working on Data Warehousing with Oracle, Teradata and Amazon Redshift.

•Solid skills in mappings, development and integration of a software product.

•Experience in requirement analysis, client interaction, development, testing and security.

•Excellent analytical and communication skills, Ability to work independently and a good team player.

•Strong experience working with client teams and on-call support 24/7.

•Experience working on Data Validation in Oracle and Report generation.

PROFFESSIONAL EXPERIENCE

Software Engineer - WIPRO TECHNOLOGIES, 2014 – 2018

Account Name: CITI BANK Dec 2018 to Mar 2019

•Mostly worked within various Ab Initio components such as Join, Rollup, Scan, Reformat, Partition by Key, round robin, gather, merge, Dedup sorted etc.

•Well versed with various Ab Initio concepts like parallelism techniques and implemented Ab Initio Graphs using Data parallelism and Multi File System (MFS) techniques.

•Hands on experience in end-to-end of Data warehousing ETL routines, which includes developing Ab Initio graphs.

•Designed and deployed well-tuned Generic Ab Initio graphs.

•Worked on multiple environments like production, development, SIT and UAT for project deployment.

Account Name: CITI BANK July 2017 to Nov 2018

•Developed daily, monthly and quarterly spark job using java.

•Worked on EAP 2.0 framework to perform ETL functions as per the Business

•Reading data from different sources systems.

•Convert data into Data set and utilize sprinter to ingest the data into Hive tables.

•Converted the Unix command into spark-sql as per the requirement of Job.

•Setting spark configuration pro-grammatically according business requirement.

•Using those ingested data from hive/hdfs we did develop some transformation to process the data as per the business.

•Experience of working on RLM for code deployment.

•Used format like parquet for performance tuning.

•Since we have BAU activities we used to discuss with clients based on our daily requirements and progress.

Account Name: CITI BANK Jan 2016 to June 2017

•Prepared high level MDD from the provided BRD based on the understandings.

•Created the overall structure of the solution for several business requirements.

•Prepared rules that acts as the key for solution.

•Created dataset based upon various entities and uploaded test files against the same.

•Created valid data guidelines for Data quality and validations.

•Prepared rules of various types that supports the overall criteria for end user satisfaction.

•Optimized the number of rules that results into faster execution.

•Tested the rules against all possible scenarios.

•Taken care of export and import of rules that helps in interoperability.

•Handled certification of rules and data quality validations that adhere to the specific parameters.

•Created package of rules to be deployed on destination environment.

Account Name: CITI BANK Jan-2015 to Dec 2015

•Worked as Data Bridge Consultant/Lead provided solutions to the development team

•Took the responsibilities starting from the requirement gathering, Implementation the details/ business requirements.

•Worked as a technical support for the subscriptions that are at development phase for better agility.

•Handled Onsite client and offshore team.

•Development activities as POC for business enhancement.

•Handled the team of 10 members in the initial stage of development and guided them through the hurdles that team is facing.

•Delivered successfully without missing the business dates.

Account Name: CITI BANK Mar-2014 to Dec -2014

•Created test cases for the jobs created in Ab initio.

•Created valid data guidelines for Data quality and validations.

•Prepared test cases of various types that supports the overall criteria for end user satisfaction.

•Tested the jobs against all possible scenarios.

•Completed the testing within the ETA given.

Skills:

Data: AB INITIO, HIVE, HADOOP, SPARK, SQL, BIGDATA, DATAWARE HOUSING, AUTOSYS SCHEDULER, CONTROL CENTER,TABLEAU

Scripting:JSON, PYTHON,SQL

Cloud Platform: AWS

Project: JIRA, SVN

Methodology: Agile

EDUCTIONAL DETAILS:

Master of Science 2016

BITS Pilani, India

Bachelor of Computer Applications 2013

Karnataka University, India

Contact this candidate