Adarsh Singh Email & Phone Number

Over a decade of professional IT experience with good exposure in Data Warehousing, Requirement Analysis, Design, Development and testing.• Strong technical and architectural knowledge of Hadoop Ecosystems to provide Big data and Data warehousing solutions.• Strong working experience in Informatica, Data Warehousing Concepts, SQL, UNIX, Relational Databases like Teradata, Oracle.• Extensively used Informatica Warehouse Designer to create and manipulate source and target definitions, mappings and transformations.• Extensively worked on Informatica Power Center transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Aggregator, Sorter and Sequence Generator. • Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica.• Have good knowledge of SQL, experience using Teradata 16.x and Oracle 12c .• Proficiency in programming in Python, SQL, shell scripting and Java.• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa• Experience working with Hive, Impala, Spark, Oozie related technologies• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Monitor.• Proficient in applying performance tuning concepts to Informatica mappings, session properties and database.• Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual. • Self-motivated individual with strong technical & analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.• Quick learner with the ability to make solutions-oriented, creative and innovative contributions in highly demanding situations.

Listed skills include Sql, Informatica, Oracle, C, and 29 others.

• 

  Srm University

  Electronics And Communications Engineering