Data Integration Developer & ETL Specialist
Resume:
Kelly H. Trinh
**** ****** *****, ******, ** ****3
********@*****.***
Summary
Results-drivenData Integration Developer / ETL Consultantwith experience designing, developing, and supporting enterprise data integration solutions. Skilled in Informatica PowerCenter and SnapLogic with strong expertise in Oracle, SQL, and PL/SQL development. Experienced in troubleshooting complex ETL workflows, optimizing data processes, and collaborating with cross-functional Agile teams to deliver scalable, high-quality data solutions. Adept at analyzing data discrepancies, improving system performance, and ensuring data accuracy across enterprise platforms.
Education
University of Oklahoma, Bachelor of Business Administration in MIS and Accounting, May 1997. Tools & Technologies
Data Integration & ETL: Informatica PowerCenter &PowerExchange, SnapLogic Databases & Query Tools:Oracle 19c, SQL Server, DB2,Oracle PL/SQL, PostgreSQL, SQL Developer, TOAD Cloud & Security:AWS, CyberArk Cloud, Password Vault,Authenticator, SOX DevOps Tools:Jenkins, TortoiseSVN (Version Control),ESP (Scheduling), CA Workstation Operating Systems & Scripting:Windows, UNIX/Linux,Shell Scripting, PuTTY, WinSCP, HostExplorer Business Intelligence & Reporting:Oracle OBIEE, OracleBI Publisher, WebFOCUS Methodologies & Tools:Agile/Scrum, Jira Cloud
Professional Work Experience
Primetherapeutics August 2025 – March 2026
Developer - Consultant
• Implement and support enterprise data integration solutions using SnapLogic and Informatica platforms
• Troubleshoot and resolve data integration issues, including debugging and identifying root causes
• Collaborate with business analysts and development leads to design and develop new data processes aligned with business requirements
• Perform data analysis to identify gaps, inconsistencies, and improvement opportunities; design and implement effective solutions
• Support QA teams with testing, validation, and execution of data integration processes
• Document data integration workflows and technical specifications
• Actively participate in Agile sprint, including planning, stand-ups, and retrospectives Penney OpCo LLC (JCPenney) July 2000 – May 2025
Software Engineer
Results-driven IT professional with over 5 years of experience designing and implementing ETL solutions using Informatica, with a strong emphasis on data mapping, transformation, and data integrity. Proficient in SQL, PL/SQL, data warehousing, and performance tuning, with additional expertise in Oracle BI Publisher for advanced reporting and analytics. Brings 10+ years of experience working with relational databases, consistently delivering scalable, high-performance enterprise solutions that support business intelligence and operational goals.
• Designed, developed, and maintained end-to-end ETL workflows using Informatica PowerCenter, extracting, transforming, and integrating data from Oracle, SQL Server, flat files, and mainframe systems into enterprise data warehouses.
• Created and optimized complex Informatica mappings using transformations like Expression, Lookup, Joiner, Aggregator, Filter, Router, and Update Strategy, ensuring efficient, high-volume data integration with a strong focus on data quality and metadata management.
• Configured and used workflow variables, parameters, and pre/post session shell scripts to enable dynamic and conditional processing.
• Debugged and optimized ETL performance across sources, targets, mappings, and sessions to improve data throughput and reduce execution time.
• Led design/code reviews, enforced reusability through parameterized mappings and reusable mapplets.
• Migrated and deployed Informatica code across Dev/Test/Prod environments using deployment groups.
• Delivered production support by troubleshooting and analyzing failed ETL jobs, conducting root cause analysis
(RCA), and implementing timely and effective resolutions.
• Developed robust PL/SQL procedures, functions, packages, views, materialized views, and triggers to support data validation, transformation, audit logging, and business logic implementation.
• Built and optimized complex SQL queries to support dynamic reporting requirements and integrated them with front-end reporting tools.
• Created efficient data migration scripts using PL/SQL to support ETL processes to facilitate smooth transitions between legacy and new systems.
• Designed and implemented database triggers to automate processes such as audit logging/change tracking.
• Developed PL/SQL test scripts and sample data generators to support QA and regression testing activities.
• Proficient in UNIX/Linux command-line interface for system administration, including file system management, user permissions, software packages, and process control.
• Supported ongoing business needs through proactive issue resolution, system enhancements, functional testing via TCoE engagement, and effective communication with business users to maintain system stability and performance.
• Demonstrated strong analytical and problem-solving skills with the ability to understand and adapt to complex data systems with minimal supervision.
• Conducted periodic access reviews by granting and revoking user access in compliance with security policies, while collecting and maintaining audit evidence (logs, approvals, screenshots) to support audit requirements. Business Analyst
Collaborated with Application Support and IT teams to resolve system issues and minimize business disruptions. Led incident management and continuous improvement initiatives while maintaining detailed documentation. Analyzed incident trends and coordinated with business and AppDev teams to enhance communication, performance, and operational alignment.
• Incident Management & Resolution:Collaborated withASM and AppDev teams to minimize incidents, ensure efficient resolutions, and support seamless application enhancements and transitions.
• Process Improvement:Promote and enforce formal processesfor service restoration, root cause analysis
(RCA), knowledge transfer, and continuous application improvements across teams.
• Documentation & Communication:Maintained accurateand up-to-date runbook documentation to reflect evolving systems, workflows, and operational procedures.
• Stakeholder Communication:Communicated effectivelywith business stakeholders regarding system issues, outages, and maintenance activities to ensure transparency and minimize business impact.
• Operational Prioritization:Managed and prioritizedcritical maintenance, business-driven tasks, and peak readiness activities to reduce disruption during high-demand periods.
• Cross-Functional Collaboration:Fostered strong partnershipsbetween business and technology teams to align priorities, set expectations, and drive shared outcomes.
• Performance Monitoring:Tracked application availabilityand performance, collaborating with development leads to prioritize fixes and enhancements aligned with operational needs.
• Peak Readiness Planning:Planned and executed readinessstrategies with ASM, AppDev, and business teams to ensure system stability during high-traffic periods.
• Risk Mitigation:Identified and addressed risks relatedto performance, long-running processes, and transactional volumes to prevent potential system issues.
• Continuous Improvement:Drove technology modernizationand process optimization initiatives to boost operational efficiency and enhance the customer experience in alignment with business objectives.
Contact this candidate