Adept at enhancing data quality and efficiency, my tenure at TechMahindra showcased my expertise in Informatica MDM and SQL programming. Leveraging a continuous improvement mindset, I spearheaded significant ETL optimizations and fostered a culture of excellence among teams. My approach blends rigorous project management with advanced technical skills, driving impactful outcomes in data management projects.
Overview
10
10
years of professional experience
Work History
Senior ETL Consultant
TechMahindra , ScotiaBank
06.2022 - Current
Improved data quality with thorough testing and validation of Informatica jobs, ensuring accuracy and consistency.
Increased efficiency in data extraction from various sources by utilizing advanced features of Informatica PowerCenter like partitioning, dynamic caching, and pushdown optimization techniques.
Provided expert guidance on Informatica best practices during project design phases, ensuring optimal solutions were implemented from the start.
Evaluated vendor offerings for MDM software solutions, conducting thorough analysis to select optimal tools for the organization''s needs.
Ensured data quality by designing and implementing data validation rules within Informatica workflows.
Contributed to successful rollout of mobile device management (MDM) solutions, enhancing data security on company devices.
Enhanced Informatica performance by optimizing workflows, sessions, and mapping configurations.
Led training sessions for new team members on Informatica tools usage, instilling confidence in their ability to manage the platform.
Employed industry-standard security measures such as encryption algorithms within Informatica components to protect sensitive data from unauthorized access.
Identified opportunities for cost savings within the organization''s MDM strategy, leading to more efficient use of resources.
Spearheaded the migration of existing ETL processes to Informatica platform, ensuring seamless transition.
Trained junior developers in best practices for Informatica development, fostering a collaborative team environment.
Successfully migrated legacy ETL processes to Informatica PowerCenter, resulting in increased efficiency and reduced maintenance effort.
Improved data accuracy by conducting thorough testing and debugging of Informatica mappings and workflows.
Provided expert guidance on best practices for Informatica development to junior team members, fostering a culture of continuous learning.
Developed customized training materials and conducted workshops for end-users, fostering a culture of continuous learning around MDM best practices.
Championed adoption of new technologies within the MDM space by demonstrating their value to relevant stakeholders.
Troubleshot complex issues swiftly by leveraging expert knowledge in both technical aspects of Informatica tools and understanding of business requirements.
Mentored junior developers in best practices for ETL development using Informatica tools, fostering a cohesive team environment.
Enhanced data integration by developing, implementing, and maintaining complex Informatica mappings and workflows.
Collaborated with IT teams to implement new MDM software solutions, increasing overall operational efficiency.
ETL Analyst
Capita
05.2016 - 09.2021
Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
Enhanced team collaboration by providing clear communication of complex findings through visualizations and reports.
Increased efficiency by streamlining data analysis processes and implementing automation tools.
Enhanced customer satisfaction rates through detailed analysis of customer feedback data and subsequent improvements in service offerings.
ETL Tester
Tech Mahindra
05.2014 - 05.2016
Identified opportunities for process improvements by conducting regular reviews of existing procedures and protocols.
Mitigated risks associated with data migration projects through rigorous pre-implementation testing activities.
Enhanced data quality by identifying and resolving ETL-related issues in a timely manner.
Maximized system reliability through diligent verification of error handling capabilities within various modules.
Validated data accuracy through comprehensive testing of source-to-target mappings and transformations.
Optimized ETL processes for faster data extraction, transformation, and loading.
Contributed to successful project outcomes by effectively communicating test results and recommendations to stakeholders.