Data Integration Developer Resume

SUMMARY:

Data extraction, transformation and loading (ETL)
All activities related to the development, implementation, administration and support of ETL processes
Informatica 9.x / 10.x
Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor, Repository Manger)
Informatica Data Quality (Developer, Address Doctor, Customer ID Matching)
Informatica Administrator
Tuning of Informatica Mappings and Workflows
Informatica Deployment Groups
Building/ migrating Informatica Domains and Repositories
SQL Server 2008 R2 / 2012
SQL Server Integration Services (SSIS)
SQL Server database tuning
T - SQL scripting
Windows shell scripting and batch processing

PROFESSIONAL EXPERIENCE:

Data Integration Developer

Confidential

Responsibilities:

Primary Informatica PowerCenter and Data Quality Developer
Develop and unit test ETL processes for optimal performance
Performance tuning of daily jobs
Work with Data Management team members, technology analysts, business users to gather requirements
Primary Informatica Administrator
Built and migrated multiple Informatica environments in 9.x/ 10.x
Ensure “lights on” support - services are up and running in all environments (DEV, TST, PRD)
Implement security standards and roles
Implement upgrades, hot fixes, emergency bug fixes, patches in all environments
Create and maintain connections (relational, application, etc.).
Create and manage Informatica Deployment Groups
Collaborate with Server/Network team to optimize environments
Perform various DBA duties such as backup/restore, database optimization through indexing, create/maintain databases and tables. Monitor after hour ETL processes

SQL Programmer

Confidential

Responsibilities:

Perform data discovery and analysis for the construction of the Enterprise Data Warehouse (EDW)
Gather requirements from analysts and business users
Create initial Informatica extraction routines for staging data of the EDW
Documented extraction processes
Administrator for Informatica domain
Participated in deploying ASB’s EDW 1.0