Senior Technical Consultant / Data Engineer
CurrentOur Project is to build an Analytics solution for Medicaid and Medicare programs under the Government Program. this project collects data from various source systems like QNXT, Leon, and EZCAP using Informatica tools to build Cognos reports and dashboards to help customers for better reporting and improve their customer experience.- Collaborate with business and technical stakeholders to translate internal customer requirements into engaging visualization solutions and work to deliver- Prepare detailed source-to-target mappings and conduct meetings with stakeholders to ensure a thorough understanding of data and transformation logic- Create Mapping Parameters, Session Parameters, Mapping Variables, and Session Variables to enhance flexibility and control in ETL processes.- Implement business rules into the target tables using mappings.- Participating in end-to-end system testing, performance testing, regression testing, and data validations.- Performance tuning of the process at the mapping level, session level, source level, and target level.- Successfully managing the ETL Code Migration Process from Dev to QA and UAT environments, leveraging Bitbucket through the CI/CD pipeline.