• Created dataflow diagrams and cross functional charts on Visio to support a data architecture project .• Interacted with client's application owner teams to collect dataflows information and created user access management strategies for client's applications.

• Created AWS Glue ETL scripts to transform data from different data sources and load it into databasesand S3 buckets for data migration projects.• Developed and maintain ETL workflows to support data ingestion and transformation for projects in theproduction stages.• Created various complex SQL queries for ad hoc analysis and to provide data to data migration teams.• Extracted data from files, database sources and transformed it using PySpark in AWS Cloud.

• Created big data Talend jobs for transferring files between different servers and for parsing data using HDFS and Hive. Parsed XML and JSON files using regular expressions, instring and substring functions and created internal and external tables in Apache Hive. • Wrote custom Java codes in Talend for assigning different string values to context variables. • Managed Ambari GUI, Hadoop servers and the HDFS directories.• Moved files to HDFS directory from the local servers by using HDFS DFS commands and tHDFSPut component.• Used Database components like tMSSQLInput, tOracleOutput, file components and tJava component for using substring and indexOf functions.• Created Context variables for defining database connections, file dates and file paths. • Created complex mappings in Talend using components like tMap/tJava/tSCPGet/tSSH/tUnite/tStatCatcher/tFixedFlowInput/tReplace/tFlowToIterate/tPostgres/tInformixRow/tHiveRow/tHiveLoad/tHiveInput/tMySQLOutput/tHDFSOutput/tHDFSPut/tSendMail.• Conducted advanced logging and monitoring process using Talend (ETL package). Used globalmap.get function, tStatCatcher and tFixedFlowInput components to capture the number of records inserted for the ETL jobs.• Used TalendDate.formatDate function and context variables to assign the dates for the job automations.• Experience in creating Email Alerts using Talend mail components.• Automated report generation process by automating jobs in Linux using crontab. • Used Linux for reading files and directories and for changing permissions of files for cron jobs using chmod commands.• Used Navigation, filters, images and text objects for creating dashboards and created geo maps, line charts, tables, pie charts and bar charts on Tableau Desktop.• Used calculated fields, alerts and subscriptions for monitoring data loads and data changes on Tableau Online.

• Supported internal departments to analyze and track KPIs and understand the events and trends affecting performance.• Interpreted data, analyzed results and provided ongoing reports.• Performed internal/external business intelligence analysis and created visualizations.• Designed ETL processes to run database procedures, join data via tMaps, move data to HDFS directory and to parse data using Hive queries.• Used Crontab scripts to schedule the ETL jobs. • Created various analytical views on Excel for business users to get quick insights of the data.• Conducted advanced logging and monitoring processes using Talend (ETL package).• Parsed XML files using Apache Hive. Then further parsed it by creating advanced functions and stored procedures using SQL Query language.• Created complex SQL and Informix database procedures/functions for Business KPI's.• Worked with various departments and business owners in understanding the business and data requirements for internal and external use.