• Having around 11 years of relevant experience in design, development, and maintenance of Business Intelligence, reporting and data application with Health Insurance, Pharma & Energy/Power. • Expertise in programmatically processing large data sets from multiple source systems, integration, data mining, summarization, and presentation of results to exec audience. • Advanced knowledge of SQL in related technologies like Oracle, Teradata, SnowSQL performance debugging and tuning activities • Strong understanding of dev to production processes, User Acceptance and Production Validation testing, waterfall and agile development and code deployment methodologies • Have experience in Data loading (JAR, XLM, CSV & parquet) and unloading. • Have experience Snowflake utilities such as Snow SQL, Snow Pipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures. • Have knowledge on AWS Services with S3, EC2 & EMR. • Experience in core data warehousing concepts, dimensional data modeling knowledge, RDBMS, OLAP, ROLAP. • Experience with ETL tools used to automate manual processes with SQL and Informatica Power Center and IICS. • Following Data Governance for the Analytics & Regularity Compliance • Created and modified many scripts of BTEQ, FAST LOAD, MULTI LOAD according to the business demand with the given transformation or business logics. Have knowledge on Stored Procedure. • Experience in Query Analysing, performance Tuning techniques and Testing. • Good at understanding client requirements and Develop solutions and providing suggestions to the Data Architect/modular for the physical design (PDM) based on requirement. • Worked in migrating data between different layers using Teradata utilities (B-TEQ Scripts) and infromatica PowerCenter. • Experience and good knowledge of Fast Export, TPUMP, TPT (Teradata Parallel Transporter). • Experience in Development of mapping's and using needed Transformations using Informatica tool with the loader connections. • Preparing execution process for scheduling the jobs like Control M and Autosys. • Preparing the LLD, TDD and Approach documents the development projects. • And completely involved in all the SDLC activities with Service now change release activities. • Involved in Handing over the deployed project to the Support teams.