Data Warehouse Architect @ Target From October 2014 to November 2015 (1 year 2 months) Greater Minneapolis-St. Paul AreaEngineer @ Nordstrom From March 2014 to October 2014 (8 months) Greater Seattle AreaTech lead @ Teradata / Oklahoma Tax commission From July 2011 to March 2013 (1 year 9 months) Oklahoma City, Oklahoma AreaTeradata Consultant @ Verizon Wireless...
Data Warehouse Architect @ Target From October 2014 to November 2015 (1 year 2 months) Greater Minneapolis-St. Paul AreaEngineer @ Nordstrom From March 2014 to October 2014 (8 months) Greater Seattle AreaTech lead @ Teradata / Oklahoma Tax commission From July 2011 to March 2013 (1 year 9 months) Oklahoma City, Oklahoma AreaTeradata Consultant @ Verizon Wireless From January 2009 to July 2011 (2 years 7 months) ATLANTA GAData Engineer @ Nordstrom ● Participated in requirement gathering, business analysis, design and development, testing and implementation of business rules● Participated in data analysis and data dictionary and metadata management -Collaborating with business analysts, SME’s, ETL developers, data quality analysts and database administrators. ● Developed processes using Teradata utilities such as TPT, MultiLoad, FastLoad, FastExport and BTEQ and also build process in Redhshift to copy and unload the data.● Involved heavily in writing complex SQL queries based on the given requirements such as complex Joins, Stored Procedures, Macros etc.● Built ETL process in AWS to read the JSON files from Kafka topic and load into Database from S3 using Airflow Dags.● Build auditing frameworks to audit the ETL process in Airflow and built dashboards in Datadog and created automatic alerting based on thresholds to identify the data processing issues.● Hands experience in AWS and leveraged services like RDS, S3, EC2, SNS & etc..● Experienced in Automating and Scheduling the Teradata and Redshift SQL Scripts in UNIX using Korn Shell scripting and also build Airflow DAG's in Python. ● Developed Business and Subject Area Logical Data Models, Physical Data Models, Physical Staging area Data Models and Data Flow Diagrams.● Hands on experience creating and publishing extracts to Tableau server● Did performance tuning, including analyze table, collecting statistics, analyzing explains & determining which tables needed statistics & secondary indexes. ● Build and Schedule ETL job in Apache Airflow and Control-M and monitoring jobs in production.● Working on Hive Bigdata platform in AWS to process the data.● Provided on call support 24x7. Greater Seattle AreaData Engineer @ Men's Wearhouse From March 2013 to February 2014 (1 year) Houston, Texas Area
Data Warehouse Architect
October 2014 to November 2015
Greater Minneapolis-St. Paul Area
March 2014 to October 2014
Greater Seattle Area
Teradata / Oklahoma Tax commission
July 2011 to March 2013
Oklahoma City, Oklahoma Area
January 2009 to July 2011
Greater Seattle Area
March 2013 to February 2014
Houston, Texas Area
What company does Praveen G work for?
Praveen G works for Target
What is Praveen G's role at Target?
Praveen G is Data Warehouse Architect
What industry does Praveen G work in?
Praveen G works in the Information Technology and Services industry.
Enjoy unlimited access and discover candidates outside of LinkedIn
One billion email addresses and counting
Everything you need to engage with more prospects.
ContactOut is used by
76% of Fortune 500 companies