Pallavi M Email & Phone Number

Macquarie Park, Nsw, Au

Sydney, New South Wales, Australia

Responsibilities • Working with the IT architect, Product Owner, Business analysts, and other Squad members in requirements gathering, analysis, and project coordination. • Experience integrating data to/from on-premises and cloud-based database solutions using Informatica Intelligent Cloud Services(IICS). • Engaged in the design, development, and implementation of cloud-based database solutions including Azure Synapse, Azure Data Lake store, AWS Redshift, and Snowflake. • Extracted data from Snowflake to push the data into Azure warehouse/Azure Blob storage instance to support reporting requirements. • Analyzed existing ETL Datawarehouse process and ERP/Non-ERP Applications interfaces and created design specification based on new target Cloud Datawarehouse and Data Lake Store. • Demonstrated expertise with industry-standard ETL tools, with a focus on IICS, facilitating seamless data integration and transformation processes. • Exposure to Snowflake database, leveraging its capabilities to manage and analyze large volumes of data efficiently.

Responsibilities: Worked closely with Business partners, and technology team members to understand business requirements, perform analysis, and design quality technical solutions that comply with the organization's architectural standards. Designed and implemented ETL pipelines to process semi-structured data by integrating data from different sources to load in Enterprise Datawarehouse. Responsible for working with Vendor & Informatica Technical Support to resolve issues and Emergency Bug Fixes by raising Support Tickets. Responsible for Designing, Coding, Testing, Implementing, Maintaining, and Supporting data pipelines that are within scope based on established high-quality Data Engineering standards. Identifying technology limitations and deficiencies in existing BI systems and associated ETL/ELT processes, procedures, and methods. Developed complex queries involving analytic functions and stored procedures to perform data aggregations and data readiness. Actively participated in the code review process to ensure development work adhered to standards and specifications (including peer review and code review external to the team). Testing, debugging, diagnosing, and correcting errors and faults in ETL applications within established testing protocols, guidelines, and quality standards to ensure programs and applications perform to specification. Created design documents (including code samples/outlines) and detailed engineering specifications based on complex business, user, and non-functional (e.g., performance, reliability, balance, and controls) requirements. Worked on workload automation & scheduling to facilitate efficient data pipeline batch processing and minimizing human intervention using tools like Control M & TWS. Well Versed with the concept of CI/CD to automate the testing, integration & deployment of data pipelines and have used tools like Bitbucket & Bamboo. Prepared & presented weekly and monthly progress reports.

Responsibilities:• Worked effectively with cross-functional teams in requirement gathering and designing efficient ETL workflows. Implemented robust error handling and monitoring mechanisms, elevating data quality and reliability.• Demonstrated expertise in applications support and management, handling minor development, bug fixes, and enhancements across the Data enterprise.• Hands-on expertise in extracting data from diverse source systems, including Mainframes such as DB2, flat files, and VSAM files, to relational database platforms like Oracle, SQL Server, and Teradata.• Actively participated in the code review process to ensure development work adheres to standards and specifications (including peer review and external code audits/ reviews).• Conducted performance tuning and debugging for sources, targets, mappings, transformations, and sessions to enhance overall system efficiency.• Experience with Domain, Folder, Alerts, Application Services, and User Accounts.• Strictly adhering to the ITIL processes, and SLAs and providing quality support to the client.• Carrying out daily health checks for all BI Servers and components.• Worked on testing the reliability and performance of data pipelines by preparing unit test plans and test cases for the developed mappings.• Utilized analytical skills to perform data analysis and generate meaningful insights for decision-making by using tools like Tableau.• Carrying out code Movement from Non-production to Production environments taking care of Version Control.• Configure and maintain multiple Business Intelligence Tools Configuration.• Incorporated ITIL framework practices for streamlined IT service management.• Proactively pursued self-learning in Azure Cloud to stay updated with the latest industry trends and technologies.• Ensured accuracy in financial documents and reports, contributing to reliable decision-making.• Preparing standard operating Procedures for related BI issues.

Master Of Technology - Mtech, Systems Engineering, 7.77 Cgpa

Bachelor Of Technology - Btech, Information Systems, 8.04 Cgpa

Diploma Of Education, Electrical, Electronics And Communications Engineering, First Division