Uploaded File
add photo
Al
albillah01@gmail.com
860-550-4151
Manchester, MA 01944
ETL / Informatica Developer
12 years experience W2
1
Recommendation
Average rating
161
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
Informatica Developer/Data Analyst
Information Technology
Apr 2016 - present
  • Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id's, and translation rules.
  • Evaluation of data groups and data critically and developed automated conversion process.
  • Stored Procedures for parsing data required for mapping in Sale Force.
  • Worked with the business analysts in requirement analysis to implement the ETL process
  • Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables.
  • Coordinate for Connectivity all access related activities queue, server, tools, and net-work issues during the initial engagement set up.
  • Wrote shell script to run ETL job by scheduler tool, ftp scripts, logs cleanup script.
  • Extensively worked with various Active transformation like Filter, Sorter, Aggregator, Router, and Joiner transformations.
  • Involved in Informatica and Oracle up gradation from version 8.6 to 9.1.
  • Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Experience in working with Access management, Sales, Order management and fulfilling system of publishing company.
  • Documented all old and migrated Store Procedures and scripts for future references.
  • Different kind of Pivot table reports generation for easy access for the users for their immediate requirement.
  • Managing all Development, staging, upgrade and Production environment SQL Servers and keeping data in Sync which is managing data quality.
  • Handling Database backup schedule.
  • Created various DDL, DML and designed materialized views.
  • To handle smooth Knowledge transition between customer to the current support team and among the onsite-offshore teams.
UAT Stored Procedure SQL Server SQL Shell Scripts Requirement Analysis Oracle Informatica ETL Database Backups Data Mapping Business Analysis Analysis Informatica Developer Data Analysis FTP
Remove Skill
References
Average Rating

0 recommendations
ETL / Informatica Developer
Information Technology
Jun 2015 - Mar 2016
  • Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
  • Data profiling use IDQ developer and Informatica analyst before start mapping notice client and SME about data quality .
  • Interaction with the Business Partners to understand the business of the application, gather requirements, analyzed and put into technical design documents (HLD & LLD).
  • As an active team member, involved in the initial phases of the design and was taken part in the analysis of the product.
  • Migration of Informatica Powercenter v 9.1 to v 9.6 .
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
  • Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Involved in the creation of oracle Tables, Table Partitions, Materialized views and Indexes and PL/SQL stored procedures, functions, triggers and packages.
  • Working with various sources such as Flatfiles, Relational, XML and Webservices as part of Informatica Mappings.
  • Worked with Mapping and Workflow variables by using the value of mapping variables on the workflow level.
  • Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings
  • Responsible to tune ETL mappings to optimize load and query Performance
  • Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run the workflows to create the Front End screen insert activities.


Environment: Informatica Power Center 9.6.1 (Designer, Repository Manager, Workflow Manager), Oracle 9i, Oracle 11g, , TOAD, SQL Developer, UNIX Shell Scripts, Microsoft Visio 2007, Adminserver, UNIX, Windows 2000/NT

XML WebServices UNIX TOAD SQL Scrum Requirements Gathering PL/SQL Oracle jQuery Informatica Powercenter Informatica ETL Agile Methodology Analysis Triggers Shell Scripts Scripting Informatica Developer SQL Developer Data Profiling ETL Developer IDQ Stored Procedure Project Management Windows
Remove Skill
ETL / Informatica Developer
Information Technology
Jan 2015 - Jun 2015
  • Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
  • Perform analysis on quality and source of data to determine accuracy of information being reported.
  • Data profiling use IDQ developer and Informatica analyst before start mapping notice client and SME about data quality
  • Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
  • Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
  • Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
  • Developed custom data transformation (structured/unstructured data) process using Item field content master data transformation tool.
  • Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
  • Developed PL/SQL stored procedures for Informatica mappings.
  • Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for management reporting.
  • Involved in unit testing, Integration testing and User acceptance testing of the mappings.
  • Used various performance enhancement techniques to enhance the performance of the sessions and workflows.s
  • Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
  • Providing technical support and troubleshooting issues for business users.
  • Actively Participated in problem solving and troubleshooting for the applications implemented with Informatica.
  • Used Workflows Manager to create the Sessions to transport the data to target warehouse.

Environment: Informatica PowerCenter 9.6.1, Power Exchange 9.6.1, Erwin 4.1, EDI, Autosys r11.0 oracle 9i, PL/SQL, Teradata 12 , SQL,, XML, SQL Server 2005, Windows 2003, Unix.

XML UNIX Unit Testing TOAD Teradata Technical Support SQL Server SQL PL/SQL Oracle Junit ITAM Informatica Powercenter ETL Data Profiling Data Management Data Conversion Informatica Analysis AutoSys Business Analysis Integration Testing Informatica Developer Erwin Data Modler Stored Procedure ETL Developer IDQ Project Management EDI Windows
Remove Skill
Informatica Developer/Support Analyst
Information Technology
Jul 2013 - Dec 2014
  • Responsible for gathering the requirements both functional and technical and documentation of the same and creating the mapping documentation, leading the team, preparing various standard template,
  • Worked with the business analysts in requirement analysis to implement the ETL process
  • Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables.
  • Requirement gathering and analysis with business users and onsite subject matter experts
  • Extensively worked with OLTP and Record creation/management systems in data extraction, manipulation and masking in/out of record management systems.
  • Loaded data into various star schema data warehouse dimension and fact tables.
  • Responsible for gathering functional specifications and converting it into mapping documents.
  • Handled Performance tuning by increasing buffer block size, creating various Named-Caches for Connected and un-Connected lookups, error handling.
  • Created re-runnable SQL scripts to create tables, triggers, indexes, views, packages and procedures.
  • Responsible for data conversion from SQL Server to Oracle 10g.
  • Responsible for working with DBAs for DDL Changes in Oracle 10g and 11g (Tables/Views/Stored Procs/Packages/Functions/Triggers).
  • Planned/participated in DR exercises, application risk management planning and effective backup and recovery planning for applications.
  • Extensively participated in various testing like, Development Unit Testing, Integration testing, User Acceptance testing and regression & performance testing.
  • Smooth coordination, managed team meetings, transition between customer to the current support team and among the onsite-offshore teams.
  • Coordinate for Connectivity all access related activities queue, server, tools, and net-work issues during the initial engagement set up.
  • Migration of Informatica Powercenter v 9.1 to v 9.6 .
  • Full time production environment support and maintenance for the retail operations.
  • Regular maintenance activities & provide 24*7 support.
  • Worked on Various Teradata utilities like FLOAD,MLOAD and TPump.
  • Bringing up the same level of knowledge shared among resources
  • Managing the customer communication and escalations
  • Up to date technical documents Runbook and service overview document SOD
  • Resource management and updating customer on timely basis.
  • Managing other prod adhoc issues and supporting the production system.
  • Coordinate Onsite and offshore team, managing various calls related to requirements, development, testing and migration.

Environment: InformaticaPowerCenter 9.5/9.1, InformaticaPowerExchange 9.1, Oracle Exadata, MSSQL Server 2008 R2, T-SQL, ERWin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Tidal, Shell Scripting, Perl Scripting, Windows XP, Putty, DB2 Mainframe, OBIEE 11g, Teradata 13/12.

TOAD SQL Server SQL Shell Scripts Scripting Requirements Gathering PuTTY PL/SQL Perl Performance Testing Oracle MySQL Linux Junit Informatica Powercenter Informatica Exadata ETL Data Warehousing Data Conversion Business Analysis Analysis Teradata Triggers OBIEE Integration Testing Risk Management Requirement Analysis Erwin Data Modler Informatica Developer T-SQL Database Backups DB2 PL/SQL Developer SQL Developer Windows OLTP Performance Tuning Unit Testing
Remove Skill
Informatica Developer/Data Analyst
Information Technology
Oct 2012 - Jun 2013
  • Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id's, and translation rules.
  • Evaluation of data groups and data critically and developed automated conversion process.
  • Stored Procedures for parsing data required for mapping in Sale Force.
  • Worked with the business analysts in requirement analysis to implement the ETL process
  • Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables.
  • Coordinate for Connectivity all access related activities queue, server, tools, and net-work issues during the initial engagement set up.
  • Wrote shell script to run ETL job by scheduler tool, ftp scripts, logs cleanup script.
  • Extensively worked with various Active transformation like Filter, Sorter, Aggregator, Router, and Joiner transformations.
  • Involved in Informatica and Oracle up gradation from version 8.6 to 9.1.
  • Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Experience in working with Access management, Sales, Order management and fulfilling system of publishing company.
  • Documented all old and migrated Store Procedures and scripts for future references.
  • Different kind of Pivot table reports generation for easy access for the users for their immediate requirement.
  • Managing all Development, staging, upgrade and Production environment SQL Servers and keeping data in Sync which is managing data quality.
  • Handling Database backup schedule.
  • Created various DDL, DML and designed materialized views.
  • To handle smooth Knowledge transition between customer to the current support team and among the onsite-offshore teams.

Environment: InformaticaPowerCenter9.1/8.6.1, InformaticaPowerExchange 9.1/8.6.1, Oracle 11g, MSSQL Server 2008 R2, T-SQL, ERWin 7.1, SQL Server, TOAD, PL/SQL Developer, Windows XP, Visual Basic 6, .Net, SQL Server 2005&2008, SSIS, SSMS, Sybase 12, Windows xp, Sun Solaris, Harvest.

UAT TOAD T-SQL SSIS SSMS SQL Server SQL Solaris Shell Scripts Requirement Analysis PL/SQL Oracle MySQL Informatica ETL Business Analysis Analysis Data Mapping Erwin Data Modler Data Analysis Informatica Developer SQL Developer Stored Procedure .NET Database Backups Visual Basic PL/SQL Developer Windows FTP
Remove Skill
Consultant Program Analyst/ETL Developer
Information Technology
Apr 2011 - Sep 2011
  • Involved in the documentation/Design of Technical Design Document of various interfaces like Sales organization, Field AOP, and Field Forecast.
  • Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
  • Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
  • Used simple to moderately complex debugging techniques to test ETL applications.
  • Developed Test Cases for testing the ETL mappings.
  • Conducted code reviews and lead design reviews to assure compliance.
  • Involved in migration of ETL/Bteq code from Development environment to QA environment and finally to Production environment.
  • Followed Informatica development standards and enforce best practices.
  • Performed QA work to verify the results provided from other teams.
  • Worked with various file formats like fixed length and delimited.
  • Involved in creation of BTEQ Script for validating the data quality like referential integrity, not null check.
  • Maintained the proper communication between other teams.
  • Utilizing the existing UNIX shell scripts to run the informatica workflow through process control.
  • Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
  • Identified BI reporting problems, and suggests practical resolutions.
  • Participates in *on-call* support for ODS and the data warehouse.
  • Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: Informatica Power Center 8.1, Teradata V2 R6, SQL, Windows XP, SQL Assistant, UNIX Shell Script, Sun Solaris.

UNIX Teradata SSIS Solaris Shell Scripts Quality Assurance Informatica Data Warehousing ETL Developer Informatica Powercenter Compliance ETL SQL Project Management Test Case Preparation Windows
Remove Skill
Informatica Developer
Information Technology
Jan 2010 - Feb 2011
  • Involved in creation of Logical Data Model for ETL mapping and the process flow diagrams.
  • Worked with SQL developer to write the SQL code for data manipulation.
  • Worked on Informatica versioned repository with check in and checkout objects feature.
  • Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
  • Provided guidance to less experienced personnel. Conducted quality assurance activities such as peer reviews.
  • Participate in the business analysis process and the development of ETL requirements specifications.
  • Worked with production support systems that required immediate support
  • Develop, execute and maintain appropriate ETL development best practices and procedures.
  • Assisted in the development of test plans for assigned projects.
  • Monitor and tune ETL processes for performance improvements; identify, research, and resolve data warehouse load issues.
  • Involved in unit testing of the mapping and SQL code.
  • Developed mappings to load data in slowly changing dimensions.
  • Involved in performance tuning of source & target, mappings, sessions and workflows.
  • Worked with connected, unconnected lookups and reusable transformations and mapplets.
  • Utilized Unix Shell Scripts for adding the header to the flat file targets.
  • Involved in designing the star schema and populating the fact table and associated dimension tables.

Environment: Oracle 10g, SQL Developer, SQL , Informatica Power Center 8.1,Sybase, Windows XP, Visio 2000, Business objects XIR2, Linux.

UNIX TOAD Sybase SSIS Star Schema SQL Shell Scripts Quality Assurance Oracle Linux Informatica ETL Data Warehousing Business Objects Business Analysis Informatica Developer Informatica Powercenter SQL Developer Windows Unit Testing
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Information Technology
Dhaka University- Bangledesh
Skills
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
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
Salesforce
0
1
SAP
0
1
SAP TR
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