Highly accomplished and results-oriented IT professional with over 11 years of experience and a proven track record of delivering innovative solutions. Possesses extensive expertise in various technologies and troubleshooting, consistently ensuring exceptional customer satisfaction and surpassing expectations. Currently serving as Tech Lead at ETech IT Solution LLP, driving forward projects with precision and efficiency. A dedicated and diligent individual with comprehensive knowledge and technical proficiency in Informatica PowerCenter. Skillfully communicates with clients, delivering comprehensive reports and updates on project progress. Demonstrates exceptional leadership capabilities, successfully leading a team of developers to execute a complex project requirement within strict timelines and budgetary constraints. This achievement resulted in heightened client satisfaction and significant repeat business opportunities. Provides valuable feedback to developers, elevating overall team performance and optimizing project outcomes.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Tech Lead
ETech IT Solutions LLP
Hyderabad (Remote)
11.2021 - Current
An effective Team Lead with proven abilities in taking up the bottom line and building skill sets.
Developed a large-scale ETL pipeline to migrate data from multiple sources into a single data warehouse for the retail business.
Designed and optimized SQL queries as well as optimized the Informatica codes to improve data retrieval performance in existing codes.
Worked in Informatica PowerCenter 10.4 as well as Data Transformation & B2B Data Exchange to deliver the file to downstream teams.
Successfully completed a comprehensive SQL training program, demonstrating proficiency in writing complex queries and manipulating large datasets.
Knowledge management activities including project documentation, Technical design documents,High Level Design documents, Detailed Level Design Documents & other technical documentation.
Senior Associate
Cognizant
Kolkata
09.2018 - 11.2021
Coordinated and managed multiple ETL projects simultaneously, ensuring all deadlines were met and deliverables were of high quality.
Managed team resources, including assigning tasks, monitoring progress, and ensuring deadlines were met.
Collaborated with cross-functional teams to develop Informatica ETL codes and implement project plans, resulting in increased efficiency and improved outcomes.
Conducted thorough research and analysis to identify potential risks and issues in existing Informatica Codes , SQL queries for implementing proactive measures to mitigate them and minimize project disruptions.
Assisted in the development and monitoring of project budgets, tracking expenses and providing regular updates to stakeholders, ensuring projects stayed within allocated funds.
IT Analyst
Tata Consultancy Services
Bengaluru
09.2012 - 09.2018
Developed and implemented data integration solutions using Informatica PowerCenter 10.2 to streamline data flow and enhance operational efficiency.
Collaborated with cross-functional teams to gather and analyze business requirements, ensuring accurate translation into effective ETL processes.
Enhanced existing SQL queries and optimized database performance, resulting in a significant reduction in query execution time by 30%.
Thorough exposure to Product Life Cycle Management including Business process mapping whereby Identify business core / critical system / processes.
Successfully completed SQL training program & Internal Life science TCS Domain Certification.
Utilized tools like JIRA and Confluence for tracking project progress.