Farooq Gill

I have actively contributed to the successful migration of a large SQL Server database, exceeding 1.5 TB in size, to PostgreSQL. Experienced in PostgreSQL query optimization, utilizing techniques like effective indexing, minimizing full table scans, and optimizing joins. Experience in migration on-prem Postgres database to AWS RDS. Proficient in using DBT to develop, test, and maintain data transformation workflows. Experience includes designing modular, scalable models, implementing CI/CD pipelines for automated testing, and optimizing data transformations for performance. Proficient in PostgreSQL schema design, administration, query optimization, and index rebuilding. I have actively participated in the planning and migration process of on-premises databases to the AWS cloud. Experience in developing data pipelines using Apache Airflow to efficiently move data from a source to a destination. Back-end Python development. I have been engaged in the design and development of Data Warehouses, Data marts, and Business Intelligence solutions, utilizing multi-dimensional models based on the Star Schema.