POOJA NIKAM
Pune
Summary
Data professional with extensive experience in developing, testing, and maintaining ETL processes. Proficient in ETL tools such as Informatica PowerCenter and Ab Initio, with a strong background in retail, automotive, and financial services. Demonstrated success in delivering complex projects on time and optimizing ETL workflows to enhance data integrity and actionable insights. Expertise in SQL, data warehousing, and building data pipelines using Scala and Spark, fostering collaboration in dynamic environments.
Overview
12
12
years of professional experience
Work History
Team Lead
Accenture
Deutsche Boerse
12.2023 - Current
- Delivered robust Spark Scala data solutions to support Dodd-Frank 45 OTC clearing regulatory compliance, enabling accurate and timely reporting.
- Worked with business stakeholders to understand OTC clearing requirements, and translate them into scalable, high-performance data pipelines.
- Integrated sophisticated business logic for financial regulations and reporting, ensuring alignment with evolving compliance standards.
- Automated ETL and reporting workflows using Control-M, Docker, and Jenkins on Cloudera Hadoop, driving operational efficiency, and reliability.
- Maintained high data quality and regulatory adherence for OTC derivatives through advanced Spark SQL and HDFS solutions.
- Led end-to-end project delivery, from requirements analysis to production deployment, ensuring seamless implementation of business objectives.
- Fostered collaboration across agile teams using GitHub for version control and CI/CD, accelerating development cycles, and enhancing code quality.
- Enhanced performance and reliability of batch jobs, supporting both daily and historical data reporting for critical business processes.
Team lead and scrum master
Accenture
BWM
07.2021 - 11.2023
- Developed and implemented ETL processes to extract, transform, and load data from legacy databases to AWS Redshift using Informatica PowerCenter.
- Implemented Slowly Changing Dimensions (SCD Type-2), late-arriving data handling, and data harmonization using Informatica PowerCenter, SQL, and Unix.
- Provided product support during various testing cycles, including SIT and UAT, ensuring smooth deployment and issue resolution.
- Participated in design and planning exercises for future software rollouts.
- Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality.
- Worked as a Scrum Master handling a team of 10 people.
- Identified and optimized inefficient PostgreSQL queries, resulting in faster, and more responsive Tableau dashboards.
ETL Developer
BITWISE SOLUTIONS PVT. LTD.
04.2014 - 06.2021
- Worked on the migration of existing Ab Initio code (graphs) to Informatica PowerCenter (mappings/workflows) to enhance performance and maintainability.
- Designed and implemented end-to-end ETL processes using Informatica PowerCenter, including job scheduling and workflow automation.
- Provided production support for ongoing ETL workflows, ensuring stability and performance.
- Automated support processes using Unix scripting improve operational efficiency and reduce manual intervention.
- Worked closely with clients to establish specifications and system designs.
- Tested and deployed scalable, highly available products. Identified opportunities for process improvement within the development team, implementing changes that led to increased efficiency and collaboration among members.
- Contributed to successful project completion with effective time management and prioritization skills, consistently meeting tight deadlines.
- Communicated complex technical concepts clearly to non-technical stakeholders during project discussions and progress updates.
Education
B.E -
Cummins College of Engineering
Pune07-2013
Skills
- Informatica PowerCenter
- Ab Initio
- UNIX
- Data Warehousing
- DB2
- SQL
- AWS Redshift
- Control M
- TWS
- JIRA
- Confluence
- Git
- Scala
Timeline
Team Lead
Accenture
12.2023 - Current
Team lead and scrum master
Accenture
07.2021 - 11.2023
ETL Developer
BITWISE SOLUTIONS PVT. LTD.
04.2014 - 06.2021
B.E -
Cummins College of Engineering