Nagarjun S. Email and Phone Number

•Determining Data storage needs and designing developing, automating, & supporting complex applications to extract, transform as well as load data using IICS Data integration for Teradata DWH for Bank of Ireland.•Using data Warehousing techniques & concepts like: Star Schema, Snowflake, Dimensions and Fact tables to build a data warehouse for internal departments. •Leading the design of the logical data model and implementing the physical database structure and constructing and implementing operational data stores and data marts.•Spearheading different non-relational Databases such as Flat files, XML files & JSON files.•Preparing Primary index, Secondary index, Partition Primary index, join indexes as well as collecting the statistics for the right columns and indexes.•Administering development, Unit Testing, SIT and UAT phases of project along with Informatica Cloud Mappings, Mapping task, Dynamic mapping task, Synchronization task, Data replication and Taskflow creation.

•Administered data extraction, Transformation and loading data from OLTP sources to Hive Greenplum, Postgres & Teradata.•Extracted data from HDFS using Apache SQOOP.•Facilitated all activities like development, enhancement, implementation, and support of ETL processes.•Fostered actionable output with extensive code development in Informatica and oracle, Hive, Greenplum and Postgres using both delta load and full load.•Created jobs and corresponding job setups for scheduling of various workflows in dev environment through Control-M as part of development.•Prepared various dependent views, tables as part of setting up a new environment.

•Administered data extraction, Transformation and loading data from OLTP sources to Hive Greenplum, Postgres & Teradata.•Extracted data from HDFS using Apache SQOOP.•Facilitated all activities like development, enhancement, implementation, and support of ETL processes.•Fostered actionable output with extensive code development in Informatica and oracle, Hive, Greenplum and Postgres using both delta load and full load.•Created jobs and corresponding job setups for scheduling of various workflows in dev environment through Control-M as part of development.•Prepared various dependent views, tables as part of setting up a new environment.