Gyaneshwar Bhalerao

WORK HISTORY

EDUCATION

SKILLS

ABOUT GYANESHWAR BHALERAO

More than 11+ years of experience as Data Engineer in critical and large scale DW/BI and AWS cloud data lakes, data warehouses. Extensive hands-on expertise using as Admin and Developer Role in IICS/IDMC, Informatica 8.x,9.x,10.x,Banking, Insurance, Retail,Pharmaceuticals-Healthcare domain. Hands-On experience in designing the complex mapping, Do the end to end delivery. Expertise in Informatica PC + CDC+ Unix shell script Proficiency in Database concepts and Data Warehousing Techniques. Data warehousing - ETL Project life cycle and Business Intelligence fundamentals. Data Model :Dimensional model (Snow flake, Star, Hybrid, Galaxy schema) and ER model Expertise in Error handling strategies and performance tuning in from ETL side and database side. Informatica jobs automation, Error handling, mail delivery, Feed file automation, Success/Failed, do the grantee support to Users. Extensive knowledge of BI Technologies and expertise with – Informatica Power Center, IICS, AWS,Redshift, Hive, Greenplum (An MPP Database), Oracle, Unix shell scripting, AWS Cloud, Redshift forDatawarehouse, S3, Athena, Presto, Workbench, Python, Window PowerShell. Handled databases such as Oracle, SQL Server, Greenplum, Teradata, Redshift with large volumes of dataand their effective usage within Informatica products with an emphasis on optimal performance. Job dependencies, scheduling, and data flow management using Active Batch tool, Control-M, DAC and Cron UNIX shell scripting, scheduling, Automation of project. Effective in work situations requiring an ability to manage multiple jobs on production supports take proactive decision. Database Management, Performance & Tuning experience on huge multi-terabytes data warehousesKnowledge of Teradata Appliance/Enterprise Proficiency Teradata utilities ( Bteq, Fastload, Multiload, Fast Export, Tpump,TPT).I am passionate towards about my work.