Jayakumar Sundaram

- 15+ years of extensive experience in Informatica 10.x/9.x and MS SQL Server Integration Services (SSIS) with strong business understanding and knowledge of ETL of data from heterogeneous source systems like Flat files, Excel, XML, DB2, Oracle, SQL server and Teradata.- Experienced in using Informatica Data quality (IDQ 9.5.1) for address cleansing using Address Doctor and identity matching rules, standardizing data with transformations.- Good understanding of Big Data, Hadoop distributed file system (HDFS) and related data ingestion, reporting technologies.- Highly Proficient in Informatica Designer Components like Source Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.- Worked on Teradata 15.10/14.10, Oracle 11g/10g, SQL Server 2008 and had hands on experience in building advanced relational database objects which uses Teradata, Oracle 10g/11g database.- Good working knowledge on Teradata utilities like FastLoad, MultiLoad, Tpump and BTEQ.- Experience in writing SQL Queries and creating stored procedures, PL/SQL Packages, Triggers and Functions. - Strong knowledge in Data Modeling (Relational, Multi-dimensional, Star and Snowflake Schema), identifying FACT and Dimensions Tables, Physical and Logical Database design using ERWIN.- Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLAP, Surrogate keys, CDC, Normalization/De normalization.- Extensive experience in UNIX shell scripting and Job scheduling like Autosys, Tidal and Informatica Scheduler.- Created data visualization reports and dashboards as per the requirements using Tableau desktop.Specialities: Informatica 10.x/9.x, Power Center, Power Exchange, Informatica Data quality 9.5.1, MS SQL Server Integration Services (SSIS), Teradata, Oracle 11g/10g, MS SQL Server 2016/2014,Redshift, DB2, SQL*Plus, SQL Developer, Teradata SQL Assistant, DBVisualizer, TOAD, E-R Modeling, Star Schema, Snowflake Schema, Ralph-Kimball Methodology, Bill-Inmon Methodology, ERWIN, SQL, PL/SQL, Base SAS, COBOL, UNIX Shell Scripting, Tableau, Hive, Sqoop, Oozie, Autosys, Tidal, Control-M