Having Around 7 Years of experience in all stages of the software development life cycle (SDLC), including requirements gathering, design, development, testing, and deployment, utilizing a variety of development methodologies, including Agile, Scrum, and Waterfall.Skilled in leveraging AWS services such as EC2, S3, EMR, Lambda, Glue, Athena, Redshift, and DynamoDB to develop scalable, fault-tolerant, and high-performance data solutions. Experienced in using these services.Expert in writing complex SQL queries, writing stored procedures, views, indexing and many more.Solid knowledge of ETL tools such as Apache NiFi, Apache Airflow, AWS Glue, and Talend, as well as extensive experience using these tools to construct intricate ETL pipelines.Experienced in data modeling for the purpose of supporting reporting and analytics on the AWS platform, including approaches such as ER modeling and dimensional modeling.Experience in Database Design and development in conjunction with Business Intelligence utilizing SQL Server 2014/2016 Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX, OLAP Cubes, Star Schema, and Snowflake Schema. Managed CI/CD pipelines using Azure Devops and Git ActionsDeveloped Spark Applications with Scala and implemented the Apache Spark data processing project to handle data from a variety of RDBMS and Streaming sources.Performing ETL testing tasks such as performing the Jobs, extracting the data by running the relevant queries from the database, transforming the data, and uploading it into the Data warehouse servers are examples of these operations. Worked with NoSQL databases like HBase, Cassandra, and MongoDB. Data modeling and database performance tuning were also responsibilities. Participated in utilizing AWS for the scaling of the Tableau server and secured the Tableau server on AWS in order to protect the Tableau environment by utilizing Amazon VPC, security groups, AWS IAM, and AWS Direct Connect.
