A detail oriented ETL Informatica Developer with focused experience in Data warehousing and ETL Analysis, Design, Development, Testing, and Implementation of business application systems using Informatica Power Center, Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications. Maintain documentation of team’s technical processes.
Extensive experience in gathering and analyzing requirements, Gap Analysis, Scope Definition, and Business Process Improvements.
Self - improvement
Informatica Power Center
Cisco VPN Client
JP Morgan Payment Net
Informatica ETL Developer
Plans, conducts Informatica ETL, translates data access, transformation, movement requirements into functional requirements, development tests, monitoring result and providing corrective action.
Design, develop, test ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter overseeing transformation activities such as normalization, cleansing, aggregation, summarization, and integration.
Understands existing Informatica ETL environment, translates into new environment ensuring source system data availability, update accessibility, data integrity, restart ability, and error handling requirements, plans tasks meet requirements.
Manage day to day development activities on the ETL platform, performance monitoring tuning, end to end Informatica ETL workflows and applying best practices in building ETL informatica applications.
Research ETL capabilities as needed to suit business requirements, provide gap analysis ensuring data quality while applying Informatica ETL, development tests, monitoring results and taking corrective actions.
Make changes to the SQL database that would prevent data corruption creating and presenting informational reports for management based on SQL data.
Conduct data analysis to support issue providing resolutions, design database schema, maintain integrity of the SQL database, encodes, tests, debugs issues identifying ways to increase efficiency of production support without involving more development resource time.
Prepare existing SQL platform for upgrades, as well as writes technical requirements and create an optimal technical solution to users’ needs through research an in-dept system analysis.
Manage over 80% daily service center’s accounts ensuring products/services on time delivery, identifying inefficiencies, recommending process improvement and meeting business requirements.
Implement authorization process through Service power that eliminated 50% of emails, call backs, managing customer relationship and implementing new process recommended.
Create requisitions in accounting system, meeting deadlines, providing accurate documentation supporting all inquiries and claims in applicable systems.
Multitask and manages several ongoing tasks and priorities, maintaining technical details, applying established processes, and assisting with the development of new or changes to support processes.
Identifies, investigates, research user questions, problems as well as recognizing, researching, isolating, resolving problems, providing solutions, and walking customer through steps to resolve problems.
Collaborating with multiple departments such as tier 1 technical support, client coordination, ensuring issues resolutions while maintaining call logs for lessons learned, tracking, and future support.
Using communicative research skills to identify the cause, not just the effect of technical problems, dispatching the technicians for situations requiring multiple technical triaging and mediated resolutions.
Organized and supervised all key functions, services, and programs, developed annual operating budget, documents, implementing systems, monitored general and administrative expenditures monthly.
Determined performance goals for business, implemented tracking procedures, analyzed sales statistics, and provided accurate reports.
Established clear goals, objectives, performance delivery outcomes, timeline and maintained a close working relationship with customer technical staff.
Provided successful recommendations/ solutions to drive business improvement to vendors, partners, direct and indirect resources, which led to growth of company.
Developed, delivered concise and effective communication to management applying strong leadership skills, which drove organizational process change.
Analyzed problems, propose solutions, implemented improvements in business operations, establishing effective, independent working process to overcome obstacles, achieved goals through being organizational savvy and possessing high level of emotional intelligence.