• Having 10+ Years of Extensive and Varied Experience in the design and development of IT related business applications• Involved in analysis, design, development and implementation of Business Intelligence Applications using IBM Infosphere Data Stage, Informatica, Talend• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which includes loading nested JSON formatted data into snowflake table.• Participates in the development improvement and maintenance of snowflake database applications• Experience with Snowflake cloud data platform including Snowflake utilities like Snow SQL, Snow Pipe• Experience on Migrating the legacy data warehouse and other databases (Sql Server/ Oracle 12c, Teradata 15.0 , DB2 and Netezza) to Snowflake.• Expertise with DBT (Data build tool) transformation logics and• Written multiple DBT models (Source, Staging, Integration and Load Models) and macros.• Expertise Talon batch jobs creation and to run the DBT Models through Control M• Hands on experience in GIT/Git hub (CI/CD Pipeline & Tags) to move the code to development and QA and Prod.• Good experience with automation of DevOps build using Bitbucket/Jenkins• Experience on UNIX Scripting and Python coding.• Strong Development Experience in building Data pipelines for batch environment using various tools like Hadoop Ecosystem, AWS, Snowflake, DBT, Python, Shell scripting, and other ETL tools.• Good Knowledge on AWS (EC2, EMR, S3, IAM, DAG, Redshift, Redshift Spectrum, Glue, CLI, Athena, Lambda).• Good Exposure in performing Exploratory Data Analysis (Data Profiling), Root Cause Analysis, Impact Analysis on large volume of datasets using SQL, Hive, Snowflake, Teradata, Redshift, Redshift spectrum, AWS Athena.• Worked on core Hadoop and Hadoop technology stack which includes HDFS, Hive, HBase.• Experience in Hive optimization techniques like static and dynamic partitioning and bucketing on different formats of data using internal and external tables.• Hands on experience in creating data pipelines using AWS glue to extract the data and load into S3, Redshift and analyze the data using AWS Athena• Strong experience in using various ETL/ELT tools like DataStage 11.7,11.5, Informatica, Snowflake and DBT• Worked on tools like DB2 Control center, Oracle Toad, Teradata SQL Assistant• Having good knowledge on Scheduling Tool Control-M, Autosys, Talon batch scheduling, Tivoli, Airflow•Expertise in handling multiple projects to meet business needs and provide 24/7 production support.