Delhi, India
Experienced and certified Azure Data Architect specializing in ETL processes, Business Intelligence, and Data Warehousing. Proficient in designing and implementing end-to-end data pipelines using Azure Data Factory (ADF), Informatica Power Center, and other tools. With a solid foundation in database technologies like Microsoft SQL Server, Azure SQL Database, and Oracle, I excel in creating efficient and scalable data solutions. My expertise includes: Building robust data pipelines with Linked Services, Datasets, and Extract-Transform-Load (ETL) processes in Azure Data Factory. Leveraging a combination of Azure Data Factory, T-SQL, and Databricks to perform complex data transformations and load tasks. Implementing incremental and batch data copying strategies to ensure accurate and up-to-date data synchronization. Collaborating with Databricks for advanced transformations such as aggregations and mapping of source datasets to desired target formats. Designing and deploying database objects like procedures and triggers using SQL and PL/SQL for seamless data movement across diverse environments. Proficiently utilizing Agile methodologies to drive efficient development cycles and deliver high-quality solutions. Throughout my career, I have demonstrated a strong aptitude for analyzing and designing Business Intelligence database applications. My experience encompasses various phases of BI projects, including requirement gathering, data discovery, data modeling, development, quality assurance, and user acceptance testing support. I am dedicated to optimizing data processes, enhancing reporting capabilities, and driving informed decision-making across organizations. Keywords: ETL, Business Intelligence, Data Warehouse, Data Modeling , Data Engineer ETL Tools: Azure Data Factory Informatica Power Center Database: Microsoft SQL Server Azure SQL Database Oracle Process Oriented Tools: JIRA Azure Devops I am committed to continuously expanding my skill set and staying up-to-date with the latest advancements in the data engineering and business intelligence domains. Let's connect to explore collaboration opportunities and discuss how I can contribute to your data-driven initiatives.