Software Engineer
CurrentDevelop and implemented ETL processes using Ab Initio for extracting,transforming, and loading data from various sources, ensuring data integrity andaccuracy.• Design and maintained Ab Initio graphs, optimizing data flow and processingefficiency for large datasets.• Collaborate with business analysts to gather and analyze requirements, translatingthem into technical specifications and data models.• Perform performance tuning of ETL jobs, resulting in a 30% increase in dataprocessing speed and reduced resource consumption.• Conducte unit testing and supported user acceptance testing (UAT) to ensure thequality and functionality of data solutions.• Monitor and maintained existing ETL processes, troubleshooting issues andapplying necessary fixes and enhancements.• Create comprehensive documentation for ETL processes, data flows, and systemconfigurations to facilitate knowledge transfer and future maintenance.• Participat in code reviews and provided constructive feedback to improve codequality and adherence to best practices.• Work with cross-functional teams to integrate Ab Initio solutions with other datamanagement and analytics tools.• Develop and implemented complex transformations and aggregations within AbInitio to support advanced data analytics and reporting needs.• Leverage Ab Initio's metadata capabilities to create data lineage and impactanalysis documentation for regulatory compliance.• Utilize Ab Initio's parallel processing features to enhance data throughput andminimize job execution times.• Develop custom components and reusable code modules to improve developmentefficiency and promote best practices.• Conduct performance benchmarking and capacity planning to ensure optimalresource allocation and scalability of ETL jobs.• Develop automated testing scripts to validate ETL outputs, ensuring consistencyand accuracy across data process
