As an Azure Data Engineer, I have extensive experience in designing, implementing and managing cloud data solutions using Microsoft Azure. I am proficient in creating end-to-end data pipelines using Azure Data Factory and Azure Synapse Analytics by integrating data from various cloud and on-premises sources.Experience in processing and analyzing large-scale data using Azure Synapse Analytics, combining data warehousing and big data analytics capabilities. Proficient in writing complex SQL and T-SQL queries to extract insights from data stored in Synapse.

Orchestrated data integration processes across heterogeneous data sources, including Oracle databases, to efficiently transform and load data into target databases.Designed and maintained robust data models to support the organization's data warehousing and reporting requirements, ensuring data accuracy and integrity.Collaborated closely with business stakeholders to gather and analyze data requirements, translating business needs into technical specifications for ETL processes.Produced comprehensive Technical Design documents based on Functional requirements, guiding the development and implementation of ETL solutions.Defined validation rules and enforced data quality standards by configuring rules against specific data columns, ensuring consistency and reliability of data.Played an active role in technical discussions, providing valuable insights and expertise to support team members and drive successful project outcomes.Leveraged Data Integrator tools to create mappings for loading data into data warehouses, utilizing a variety of transformations such as Key Generator, Table Comparison, Case, Validation, Merge, and Lookup.Managed job scheduling and user access permissions, as well as repository administration tasks, using Management Console tools for efficient data pipeline management.Demonstrated exceptional stakeholder management skills, fostering collaborative relationships and effective communication across diverse teams to achieve project objectives.

Utilized Talend to develop robust ETL jobs for loading data into MYSQL tables, ensuring efficient and reliable data transfer.Implemented and managed Implicit, local, and global Context variables within Talend jobs to dynamically handle configurations and environment-specific parameters. Engineered complex Talend ETL workflows to seamlessly migrate data from flat files to MYSQL databases, incorporating advanced transformations and data processing logic. Adhered to organization-defined Naming conventions for structuring flat file formats, Talend Jobs, and batch execution schedules, ensuring consistency and standardization across projects.Crafted intricate MYSQL queries to extract and integrate data from diverse sources, seamlessly integrating them into Talend workflows for efficient data processing.Leveraged Context variables to streamline environment configurations, including database connections and file paths, facilitating smooth migration across different deployment environments.Implemented comprehensive error handling mechanisms within Talend to validate data integrity and completeness, ensuring high data quality and reliability.Monitored and troubleshooted batches and jobs for weekly and monthly data extracts from various sources, ensuring smooth execution and timely delivery to the target database.Provided proactive production support by executing and maintaining Talend jobs, as well as addressing and resolving any bugs or issues encountered during job execution.Developed mapping documents outlining the data flow from source systems to target databases, providing clear documentation for data integration processes and ensuring alignment with project requirements.

As a Software Developer:Collaborated with the onsite team to comprehensively understand business requirements documents, ensuring alignment with project objectives.Participated in the complete Software Development Lifecycle (SDLC), from initial analysis and development to testing, deployment, and documentation, ensuring the delivery of high-quality software solutions.Contributed to support activities by addressing and resolving bugs, ensuring the smooth functioning of deployed applications.Engaged in regular touch base calls and performed User Acceptance Testing (UAT) to validate software functionality and gather feedback from stakeholders.Analyzed HTML prototypes prepared by the prototype team to identify the pages involved in each use case, facilitating the development process.Utilized JavaServer Faces (JSF) to develop code and create dynamic pages as per project requirements.As an HTML Developer:Developed HTML prototypes for the HIP Application based on the specifications provided by the BMS Application, ensuring accurate representation of user interface elements and functionalities.Implemented JavaScript code within JavaScript files to add dynamic behavior to components in the HTML prototypes, enhancing user interactivity and functionality.Created wireframes using Microsoft Visio for the BMS application, providing visual representations of application screens and layouts to facilitate design and development processes.