Uploaded File
no photo
ETL / Informatica Developer
9 years experience W2 Manchester, MA
Actively seeking
no photo
ETL / Informatica Developer
1 recommendation
Average rating
Profile views
ETL FTP Informatica Informatica Developer Oracle Shell Scripts SQL Analysis Business Analysis Informatica Powercenter
Remove Note
View Note
Recent Experience
Informatica Developer/Data Analyst 04/16 - present
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
ETL / Informatica Developer 06/15 - 03/16
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
ETL / Informatica Developer 01/15 - 06/15
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

  • 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 .


ETL Tools:

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


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


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

Top 5 Skills
SkillsProficiencyLast Used
Informatica Developer
Education and Certifications
Bachelor's in Information Technology
Dhaka University- Bangledesh
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:U.S. Citizen