Uploaded File
Tech Lead/Lead Developer
14 years experience W2 New Brunswick, NJ
Available immediately
Actively seeking
Tech Lead/Lead Developer
Average rating
Profile views
Oracle SQL ETL Informatica Informatica Powercenter TOAD Data Warehousing PL/SQL UNIX Stored Procedure
Remove Note
View Note
Recent Experience
Tech Lead/Lead Developer 05/18 - present
Data Engineer/Lead Developer      07/17 - 04/18
Big Data Data Mapping Data Visualization Data Warehousing ETL Hadoop Hive Informatica Informatica Powercenter Oracle PL/SQL QlikView Spark SQL Tableau TOAD
Data Engineer/Lead Developer 11/14 - 06/17
Data Cleansing Data Integration Data Mapping Data Validation Data Warehousing ETL Hbase Informatica Informatica Powercenter Java MapReduce MongoDB Oracle PL/SQL QlikView SQL SQL Server Stored Procedure TOAD Triggers UNIX

  • 12+ years of work experience in ETL Development, Data Visualization and Data Warehousing using cutting edge technologies.
  • 3+ years data visualization experiences using Tableau, QlikView and Power BI.
  • 8+ years of strong experience in Data Warehousing and ETL using Informatica PowerCenter 10.1/9.1/9.0.1/8.x/7.x/6.1, Power Exchange 9.1/8.6/8.1, Oracle 11g/10g/9i, Teradata 13/12/V2R6 and Erwin.
  • 2 years of experience in IBM Netezza data warehouse development using Netezza Database 7.2.1.
  • 3 years of experience on real-time data Warehouse development using CDC tool Informatica PowerExchange 9.1/8.6/8.1.
  • Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, ROLAP, MOLAP, Fact and Dimension tables, and Logical & Physical data modeling using ERWIN 7.5/4.2 and MS Visio.
  • Having Business Intelligence experience using OBIEE 11g/10g, Business Objects XI R2, MS Access Reports.
  • Extensive experience in using Oracle 11g/10g/9i, DB2 8/7, MS SQL Server 2008/2000, Teradata 13/12/V2R6, MS Access 7.0/2000, Erwin, XML, SQL, PL/SQL, SQL*Plus, SQL*Loader and MS SQL Developer 2000, Win 7/XP and Sun Solaris.
  • Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.
  • Extensively worked on Oracle Function, Cursor, Store Procedure, and Package & Trigger.
  • Experience on data modeling and create LDP and PDM for Star schema and Snowflake schema using MS Visio and ERWIN 7.1/4.5.
  • Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
  • Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
  • Experience in preparing ETL design documentations, user test case documentation and standard operating procedures (SOP) documentation.
  • Experience of working on onsite – offshore module.
  • Worked as Agile Scrum call facilitator and track status and discussion using BaseCamp and Rally.
  • Extensive experience on effort estimation, distribution of work, track & update status report, team coordination and update client.
  • Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
  • Providing on Production Support, Resolution & Closure of Trouble issues tickets.
  • Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
  • Worked on multiple projects using Informatica developer tool IDQ of latest versions 9.1.0 and 9.5.1

Top 5 Skills
SkillsProficiencyLast Used
Informatica Powercenter
Education and Certifications
Bachelor's in Information System Management
City University of New York 2005
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