Overall 12 years of experience in the IT industry as a Software Engineer, specializing in Oracle PL/SQL, SQL, and ETL development using Informatica PowerCenter (9x/10x), Informatica Cloud (IICS), and Oracle and Snowflake databases. Led and managed Data Engineering teams responsible for end-to-end data engineering processes including data modelling, ETL design, development, automation, testing, and creation of data marts. Played a key role in large-scale data warehouse projects, including successful migration from Oracle to Snowflake and automation of validation processes. Hands-on experience in handling complex data integrations, including source files with multiple delimiters, and implementing slowly changing dimensions (SCD Types I, II, and III) for maintaining historical and incremental data. Strong knowledge of USA Healthcare domain, having worked extensively in projects involving Payer, Provider, Clinical IT, Pharmacy Benefits, Membership & Eligibility, and Claims. Proficient in data warehousing concepts, PL/SQL programming, and creating DB objects such as Tables, Views, Materialized Views, Indexes, and Sequences. Experienced in using advanced Informatica transformations like Filter, Router, Aggregate, Lookup, Joiner, and Update Strategy. Actively participated in Agile methodology across projects—contributed to sprints, peer reviews, sprint demos, and ensured continuous integration testing of workflows. Developed technical design documents, source-to-target mappings (STM), and unit testing documents; conducted extensive unit testing and debugging to ensure high data quality. Provided mentorship and conducted knowledge-sharing sessions for team members and new joiners, ensuring consistent project execution and cross-training. Strong ability to learn new technologies quickly, demonstrated through ongoing training in Azure Data Factory and integration tools like Workato, and an overall focus on automation and optimization of data pipelines. Excellent communication skills, capable of clearly conveying both technical and functional concepts to stakeholders at all levels. A dependable team player and quick learner, with a proven track record of meeting tight deadlines and delivering under high-pressure environments.
Oracle 10g