add photo
Al
albillah01@gmail.com
860-550-4151
Manchester, MA 01944
Informatica Developer/Data Analyst
14 years experience W2
1
Recommendation
Average rating
319
Profile views
Summary

  • IT Professional with 5+ years of Experience in the Business Requirements Analysis, Application Design, Data Warehousing, Development, Implementations and Testing of software systems in various verticals such as Financial, Retail, Insurance industries.
  • 7+ years of strong experience in Data Warehousing and ETL using Informatica Power Center 9.6/9.51/9.0.1/8.x/7.x/6.1,Oracle 11g/10g/9i, Taradata 13/12/V2R6 and Erwin.
  • 3 years of experience on real-time data Warehouse development using CDC tool Informatica Power Exchange 9.1/8.6/8.1.
  • Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica understands complex mappings transformation rules, data formats and efficient in performance tuning of sources, mappings, targets and sessions.
  • Experience in Power Exchange to connect and import sources from external systems like SAP R/3, DB2, Salesforce, Mainframes, and AS/400.
  • Designed and developed mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure, Update Strategy, SCD's Type1, Type2 and Type3.
  • Knowledge of Informatica administration in windows and Linux environment
  • Proven experience at building, motivating and leading professional teams, managing projects and supporting client relationships.
  • Knowledge of tools such as Erwin and MS Visio Professional.
  • Experienced with Multiple Databases including Oracle 11g/10g/9i, Teradata13/12, MS SQL Server 2008/2000 and DB2.
  • Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
  • Worked on Oracle Procedure, Function, Package and Trigger.
  • Worked on Teradata utilities BTEQ, FLOAD, FEXPORT, MLOAD and TPUMP.
  • Developed test case’s for business and user requirements to perform System/ Integration / Performance testing.
  • Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
  • Expertise in Performance Tuning of overall data warehouse, database, ETL and OLAP tuning coordinating with DBAs and UNIX Administrator for better performance.
  • Confident self-starter, independent worker and team player.
  • Data Profiling use IDQ for data profiling , mapping Use Informatica Analyst generate data profiling report .

SKILLS

ETL Tools:

Informatica Power Center 9.6/9.5/9.1/8.6/8.1/7.1, Informatica PowerExchange 9.1/8.6

Databases:

Oracle 11g/10g/9i, DB2 8.0/7.0/6.0, Teradata 13/12, MS SQL Server 2000/7.0/6.5, MS Access 7.0/97/2000

Other Tools:

Oracle Report Writer, MLOAD, TPUMP, BTEQ, FLOAD, SAS, SQR 3.0, Erwin 4.x/3.5/3.x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer

Languages:

SQL, UNIX Shell Scripting, Unix Commands, XPath, XSLT

Operating Systems:

Windows Server 2008/2003, UNIX, Sun Solaris 2.x.

Scheduler& Reporting Tools:

ESP, Autosys, OBIEE 11g, Cognos 7

Experience
Education
Bachelor's in Information Technology
Dhaka University- Bangledesh
Skills
Translation
2023
8
ETL
2021
5
FTP
2021
5
Informatica
2021
5
Informatica Developer
2021
5
Oracle
2021
5
Shell Scripts
2021
5
SQL
2021
5
Analysis
2021
4
Business Analysis
2021
4
Informatica Powercenter
2016
4
TOAD
2016
4
Windows
2016
4
PL/SQL
2016
3
SQL Developer
2016
3
SQL Server
2021
3
Data Warehousing
2014
2
Database Backups
2021
2
Erwin Data Modler
2015
2
Linux
2014
2
MySQL
2014
2
PL/SQL Developer
2014
2
Requirement Analysis
2021
2
Requirements Gathering
2016
2
Scripting
2016
2
SSIS
2013
2
Stored Procedure
2021
2
Teradata
2015
2
Triggers
2016
2
Unit Testing
2015
2
UNIX
2016
2
.NET
2013
1
Business Objects
2011
1
Data Analysis
2021
1
Data Conversion
2015
1
Data Mapping
2021
1
Data Profiling
2016
1
DB2
2014
1
ETL Developer
2016
1
Exadata
2014
1
IDQ
2016
1
Integration Testing
2015
1
Junit
2015
1
OBIEE
2014
1
OLTP
2014
1
OPTIM
2016
1
Performance Testing
2014
1
Performance Tuning
2014
1
Perl
2014
1
Project Management
2016
1
PuTTY
2014
1
Quality Assurance
2011
1
Risk Management
2014
1
Solaris
2013
1
Star Schema
2011
1
Sybase
2011
1
T-SQL
2014
1
UAT
2021
1
Visual Basic
2013
1
XML
2016
1
Agile Methodology
2016
1
AutoSys
2015
1
Business Requirements
0
1
Cognos
0
1
Compliance
2011
1
Data Management
2015
1
EDI
2015
1
ITAM
2015
1
jQuery
2016
1
Regulatory Reporting
2011
1
Salesforce
0
1
SAP
0
1
SAP TR
0
1
SAS
0
1
Scrum
2016
1
SQL Loader
0
1
SSMS
2013
1
System Administration
0
1
Technical Support
2015
1
Test Case Preparation
2011
1
WebServices
2016
1
Windows Server
0
1
XSL
0
1
XSLT
0
1