Senior Informatica Developer Resume CA - Hire IT People

SUMMARY:

An IT Professional with 5+ years experience in data warehouse/application development, design and testing. Has experience with ETL tools like Informatica Power Designer and IBM DataStage, and Reporting tools like MS SSRS and Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Senior Informatica Developer

Responsibilities:

Meet with business users to collect requirements and document system specifications
Design Informatica ETL Jobs to migrate policy information from DB2 mainframe to Oracle database
Manage Offshore team for code changes in development/production environments using GitHub and HP Quality Center
Assist with system testing and debug/fix production issues
Work with DBA/Admin teams to troubleshoot performance issues

Confidential, FL

BI Developer

Responsibilities:

Designed and developed MS SSRS reports for business users to help with foreclosure case management using data warehouse on MS SQL Server
Designed and developed T - SQL stored procedures to encapsulate business logic
Worked on conversion of teh backend of Perfect Practice application to Postgres database
Worked on performance tuning of SQL statements and stored procedures
Managed code in development/production environments, and debugged/fixed production issues

Confidential, MO

Associate Consultant

Responsibilities:

Met with teh business users to collect requirements for new reports and changes to existing reports
Developed MS SSRS reports for teh Rate Management System based on specifications using SQL and T-SQL Stored Procedures
Completed unit testing of reports and made changes based on feedback from User Acceptance testing

Confidential, OH

Associate BI Consultant

Responsibilities:

Designed and developed ETL processes utilizing teh Informatica PowerCenter tool based on teh business requirements
Designed multiple test cases that verify teh business requirements are being met and performed data validation within SQL Server database.
Gathered reporting requirements and performed data analysis to determine data sources and performed source to target mapping
Designed and developed ETL jobs which migrated data from teh operational and external environments to teh Business Intelligence environment (Microstrategy and Netezza) using IBM DataStage.
Completed unit testing for jobs developed in DataStage
Developed Informatica ETL jobs for teh CCAR regulatory data mart (Teradata) used for stress-tests of bank holdings
Completed unit test cases using SQL

Confidential, FL

Report Developer

Responsibilities:

Participated in requirements gathering sessions with business users for converting Crystal reports to MS SSRS
Developed MS SSRS reports using teh specifications
Performed unit and system testing

Confidential, FL

S ystems Analyst

Responsibilities:

Created and validated business rules
Tested business rules for sources and targets using SQL
Mapped source system data to teh data warehouse, data marts and operational data store models
Defined and captured metadata and rules associated with teh ETL processes