Subash Thilagar

About Subash Thilagar

Experience in Banking, Finance, Retail and Gaming domains.• Extensive experience in development of various business warehouse applications on databases like Oracle exadata, Teradata, HP Neoview and SQL Server, on the framework like Apache Hadoop, on cloud like Amazon Web services [AWS] using the ETL tools Informatica PowerCenter, Informatica PowerExchange, Alteryx and Informatica B2B with the reporting tools like SAP BO, Tableau, Qlik, Microstrategy and Cognos. • Proven analytic and problem-solving skills with the ability to assess end user needs• Implemented Informatica power exchange with oracle in HDFC bank.• Experience in loading data from Mainframe to Data warehouse using BTEQ, MULTILOAD, FASTLOAD, FASTEXPORT and Informatica PowerCenter • Experience in implementing schema refresh and CDC in Oracle Golden Gate.• Experience in scheduling tools like Tidal and Autosys.• Strong experience in SQL, PL/SQL, Stored procedures, Triggers, Functions, UNIX and Shell scripting • Experience in working with different data sources like Flat files, XML files, HL7 files, COBOL files, Web services, MQ, HDFS and other relational and non-relational databases • Strong development experience on Informatica PowerCenter, Informatica B2B and Informatica PowerExchange.• Experience in Informatica administration.• Strong knowledge and experience in HDFS and MapReduce custom programming to process structured, semi-structured and unstructured streaming and batch data.• Experience in exporting/importing data between RDBMS and Hadoop environment using SQOOP and loaded into Hive tables and accessed them in Hive and Impala using HiveQL.• Experience in writing Pig scripts on Pig Latin to enrich/transform data in HDFS.• Experience in Composite data virtualization tool.• Experience in BI tools like Tableau and Business objects.• Experience in programming languages like Java and Python.• Experience in versioning tools like perforce and SVN.

Experience

1. Technical Architect

   Arrow Electronics

   Mar 2017 — Present

Education

• PSG College of Technology

  BE, Electronics and communication

  2003 — 2007

• Nadar saraswathi school theni

  Higher Secondary, Maths, Botony, Zoology, Physics, Chemistry

Skills

• Teradata Data Warehouse
• Sql
• C
• Hadoop
• Sdlc
• Java Enterprise Edition
• Etl
• Informatica
• Unix Shell Scripting
• Databases
• Oracle Golden Gate
• Tidal Enterprise Scheduler
• Oracle
• Requirements Analysis
• Unix
• Perl
• Shell Scripting
• Composite
• Business Intelligence
• Microsoft Sql Server
• Extract, Transform, Load (Etl)
• Software Development Life Cycle (Sdlc)
• Data Warehousing
• Pl/Sql
• Teradata
• Data Structures