Data Warehouse & INFORMATICA Specialist Resume

SUMMARY

I am seeking a challenging opportunity in the field of data warehousing and INFORMATICA tools where I can fully utilize my skills in analysis, design and development to implement highly complex projects offering over 10 years of experience in data management.
Extract/Transform/Load (ETL) using INFORMATICA PowerCenter.
Data Quality using INFORMATICA Data Profile and IDQ.
Metadata using INFORMATICA Metadata Manger.
Business Intelligence using SAS WRS, Oracle BI, and SAP BO.
Database modeling using ERWIN.
Data warehousing concept and techniques.
Data migration from legacy systems to new systems.
Systems data integration.

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse & INFORMATICA Specialist

Responsibilities:

Gather business requirements and identify required reports and analytics.
Perform system analysis that includes the data model, functionality and integration with other systems.
Design target data model in EDW (as of date / from date, to date).
Design required data marts that show the benchmark figures.
Determine the frequency and loading mode (update/insert, delete/insert) according to the nature of the data (transactional, demographic, lookups).
Determine the selection criteria from source that identify the delta (changed records).
Develop detailed ETL technical specifications.
Thoroughly test ETL flows and perform the user acceptance testing (UAT).
Review raw data received in various formats from various sources and standardize its processing
Support operation and expansion of data warehouse and reporting environment.
Monitor performance and reliability of loading processes.
Debug and trace of reports defects, production incidents as well as performance issues, diagnosing the root causes and recommending corrective actions.
Maintain and implement the data governance policies agreed upon by the bank.
Develop and implement data auditing strategies and processes to ensure data accuracy and integrity.
Identify data quality issues and their causes through profiling reviews and root cause analysis
Collaborate with key users and operational groups to identify business needs, data usage requirements, and validation metrics.
Develop and maintain efficient reconciliation and validation processes to ensure accurate information is delivered to users.
Identify opportunities in processes, system capabilities and deliver methodologies for continuous improvement as applicable
Develop required reports and dashboards

Confidential

Data Warehouse & INFORMATICA Specialist

Responsibilities:

Extracts, manipulates, analyzes, and reports data to stakeholders; prepares and maintains data files; verifies data to ensure data integrity; determines data to be collected and data to be used; establishes data collection quality standards and ensures they are met.
Develops and implements processes for linking and analyzing data from a variety of sources; applies statistical techniques to analyze trends.
Acquires, manipulates, archives, and maintains historical data sets, verifying accuracy and consistency over time; determines data lifecycle to understand what and when data should become obsolete.
Designs, develops and prepares standardized operational, management, and ad hoc reports; works with user base to understand reporting and analysis needs and consistently meets delivery deadlines.
Establishes, implements and enforces correct data collection policies and procedures; documents procedures for data management processes; develops methodologies for data collection and evaluation relevant to each project; performs analysis to determine adequacy of data collection and evaluation processes; ensures data management system is compliant with all relevant laws and regulations; evaluates data management system to improve operational procedures.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship