Uploaded File
no photo
Al
ETL / Informatica Developer
Manchester, MA
Available immediately
Actively seeking
no photo
Al
55
views
ETL / Informatica Developer
1 recommendation
1
Recommendation
Average rating
55
Profile views
Oracle Analysis ETL Informatica Informatica Developer Shell Scripts SQL Business Analysis Informatica Powercenter TOAD
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
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
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
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

Top 5 Skills
SkillsProficiencyLast Used
Oracle
2018
Analysis
2018
ETL
2018
Informatica
2018
Informatica Developer
2018
Education and Certifications
Bachelor's in Information Technology
Dhaka University- Bangledesh
Preferences
Availability:Immediately
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