ETL / Informatica Developer Resume

SUMMARY:

An IT professional with 3 plus years of industry related experience with emphasis on ETL transformations and end to end ETL delivery of Jobs using Infomatica Power Center tools. Participates in Informatica Power Center upgrade from 9.6 to 10.2. Converts relational data sources to flat files and completed passive and active transformations lncluding joiner, router, expression, filter and Source Qualifier transformations.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

ETL / Informatica Developer

Perform Debugging uncovering missing columns and troubleshoot for errors arising from a workflow session.
Gather business requirement to create a SQL query that translate business Logic into source and target table.
Define session properties for source and target transformations either for a normal or bulk load that may involve a truncate and load option based on requirement.
Develop and maintain cache mechanism using the sorter, joiner, xml transformation for different mappings.
Define and research source systems and identify target output for ETL delivery
Create re - usable and non-reusable sessions for ETL Jobs that runs individually or concurrently.
Create a passive and active pass through mappings using the distinct feature in the Source Qualifier.
Manually create table with primary keys definition in the source analyzer and generate script that creates table structure in the Database for non-existing tables based on requirement.
Define primary keys into dimension tables that act as foreign keys in the fact table in the target analyzer.
Use the debugger to analyze a mapping to troubleshoot for errors in the log session whenever a workflow fails in the Workflow monitor.
Create a scheduled workflow that executes multiple sessions defined for Daily Job upload into the database or defined output location.
Create SQL query that implements the business logic from the SQL and perform transformation based on requirements.

Maimonides Medical Center

Confidential

Provided support for Cerner Millennium applications like Power Chart, Power Note, First Net, Rad Net, SurgiNet, eMAR, Message Center, PAL, iView, Power Forms, and Power Plans.
Assisted anesthesiologist and OR techs during surgical interventions and documentation.
Assisted with clinical documentation, Pathnet, code upgrades, troubleshooting and results viewing.
Assisted physicians with ordering procedures, viewing work list, starting and completing exam and managing exams result and follow-ups.
Supported the clinicians on Cerner applications such as PowerChart, PowerNote, FirstNet, RadNet, eMAR, Message Center, PAL, iView, PowerForms, and PowerPlans.
Perform audit of IT risk assessments, Application controls and specific controls related to the area of business, including A-123, HIPAA.
Developed scheduling, Reports, User Preferences, Enter/Edit Results, Demographics Activity, and In Basket Messages.