/> 
IdentityETL Tools - Informatica Power Center (v 9.6.1), Talend Data Fabric / Cloud, SSIS ➢ Worked on multiple source & target systems such as Mainframe files, Delimited and Fixed width files, and Oracle and SQL databases to extract and load data. ➢ Worked with Sources like SAP S4/HANA, ODP in Talend to extract Full and Incremental loads using tSAP components. ➢ Worked with Talend in creation of using ELT components to better use Snowflake Computing capabilities. ➢ Good experience in using tMap/tELTMap components in Talend to transform data using various available pre-built functions. ➢ Designed components in Talend to control Snowflake virtual warehouses. ➢ Experienced in using Talend Data Fabric tools (Talend DI, Talend MDM, Talend DQ, Talend Data Preparation, ESB, TAC). ➢ Good experience working with MSSQL, Oracle, Snowflake, SAP, Azure and XML based Talend components. ➢ Experienced in Data Ingestion projects to inject data into Data lake using multiple sources systems using Talend Bigdata. ➢ Experienced in scheduling Talend jobs using Talend Management Console (TMC) - Talend Cloud 7.2. ➢ Experience in better utilization of Talend Orchestration Components. ➢ Transformations – Source Qualifier, Expression, Connected and Unconnected lookup’s, Joiner, Router, Update Strategy, Aggregator, Normalizer, Stored Procedure and others along with its configurable properties. ➢ Implemented Solutions that use SCD types, stored procedures and Source Qualifiers. ➢ Good Knowledge on Workflow, Session, Mapplet and Worklet configurations and integrations. ➢ Vast experience in understanding Informatica metadata tables that store detailed level of configurations, schedules, workflows and transformations. ➢ Experienced in ETL Talend Data Fabric components and used features of Context Variables, MySQL, Oracle, Hive Database components. ➢ Vast experience in automating jobs during critical data migration activities from On Prem to Cloud. ➢ Knowledge on extracting data from direct file locations through FTP mechanisms, Databases & Indirect file loads. ➢ Developed a Utility to extract and parse multiple parameter files in minutes, integrate with metadata and give key information to back track dependencies. ➢ Pre , Post Success , Failure commands , Parameterization , Partitions etc.,
Information classification: Internal
Databases – Oracle, MS SQL, Snowflake ➢ Good understanding on Snowflake Architecture. ➢ Vast experience in better utilizing Snowflake Components – Tables, Stage (Internal & External), Creating Views and Secure views, Functions and Procedures. ➢ Good experience in administering Snowflake account to use RBAC for respective users. Good understanding on creating Virtual Warehouses and Administer to perform better using available Scaling policies. ➢ Experience in designing framework on better utilization of Snowflake capabilities like Result cache, Zero Copy Clone and Time Travel. ➢ Developed various frameworks to understand internal working functionality of Snowflake (How Internal Stages, and Temporary tables are used) ➢ Query Knowledge - DDL & DML Statements, Joins, Union & Intersect, Distinct, Rank, Row number (), ORDER BY, PIVOT, TRANSLATE etc., ➢ Good knowledge on implementing PL/SQL blocks – Loops, Cursor, Functions, Procedures, and Packages & Triggers. ➢ Good experience in designing optimal queries to give faster results. Reporting & Visualizations – Power BI ➢ Data Import using Excel , Oracle , SQL Server , Azure Data Lake Store , Azure Databases etc., ➢ Knowledge on transformations based on business layer terminology, Developing business model etc., ➢ Implemented custom logics to navigate from one report to other using Dynamic links. ➢ Good understanding on DAX expressions, calculated columns, tables and measures. ➢ Implemented Parameterization concepts to filter datasets and select data source inputs on adhoc basis. ➢ Knowledge on publishing reports to cloud – Individual Workspace and App Workspace , Creation of Dashboard tiles etc., ➢ Good knowledge on Roles and report security. Data Migration ➢ Part of Migration Design architecture to move On Prem Data on MS SQL to Snowflake Cloud Data Warehouse. Other Knowledge Areas ➢ Basics of Cloud concepts – IAAS , PAAS , SAAS ➢ Microsoft Azure – Compute , Network , Datab
