Uploaded File
no photo
Informatica Developer
11 years experience W2 Madison, WI
Check for availability
Actively seeking
no photo
Informatica Developer
Average rating
Profile views
Project Management Informatica Developer Stored Procedure Triggers Data Warehousing ETL Informatica Informatica Powercenter Oracle PL/SQL
Remove Note
View Note
Recent Experience
Informatica Developer 08/13 - present
UNIX TOAD Teradata Star Schema SQL Server SQL Quality Assurance PL/SQL Oracle Junit Informatica Powercenter Informatica Data Warehousing Business Requirements Agile Methodology JIRA ETL Greenplum Informatica Developer Stored Procedure Triggers Solutions Architecture Project Management
ETL/Informatica Developer 08/12 - 07/13
XML UNIX TOAD Teradata Star Schema SQL Server SQL Shell Scripts Quality Assurance PL/SQL Oracle Informatica ETL Data Marts Data Warehousing Business Requirements Performance Tuning Informatica Powercenter Analysis Informatica Developer Stored Procedure Triggers Project Management
Informatica Developer 07/08 - 07/12
UNIX UAT TOAD Teradata SQL Server SQL SDLC Scripting Requirements Gathering PL/SQL Oracle Informatica ETL Shell Scripts Star Schema Data Warehousing Analysis Triggers Informatica Developer Stored Procedure Informatica Powercenter Project Management PL/SQL Developer

  • 7+ years of IT experience in Informatica Data Analysis, Design and Development for various software applications in client-server, N-tier environment
  • Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines
  • Strong Knowledge and experience in SDLC methodologies like waterfall and iterative methodologies
  • Experience in various phases of data warehouse development lifecycle, including gathering requirements to design, development, testing
  • Extensively used SQL and PL/SQL for development of Procedures, Functions, Packages and Triggers
  • Extensively worked with Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager
  • Good understanding in Informatica Administration like Repository set-up, Domain configuration, User management, etc.
  • Experience in Creating the Data Mart using the Flat file sources
  • Expertise in implementing complex business rules by creating re-usable transformations and Mappings/Mapplets
  • Experience working with various relational datasources like Oracle, DB2,Green Plum and SQL Server
  • Experienced in integration of Salesforce with external applications by using Metadata API
  • Created Workflow Rules to automate Tasks, Email Alerts, Field Updates,time-dependent actions and Outbound API Messages
  • Experience in implementing the complex business rules by re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings
  • Experience in documenting High level design and Low level design documents for the ETL solution
  • Expertise in Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data like Flat Files, XML Files, Oracle, DB2, SQL Server into Data Warehouse/Data Marts using Informatica
  • Involved in indentifying the bottle necks and performance tuning of Informatica Mappings, Sessions
  • Created and updated the job schedules as and when new jobs were added and dependencies were updated in the scheduling tool
  • Excellent problem solving skills with strong technical background, quick learner and excellent team player with great interpersonal skills and ability to meet tight deadlines under high pressure

Top 5 Skills
SkillsProficiencyLast Used
Project Management
Informatica Developer
Stored Procedure
Data Warehousing
Education and Certifications
Madras University
Scrum Master Accredited Certification (SMAC),
Product Owner Accredited Certification (SPOAC),
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Contract
Security Clearance:No clearance
Citizenship:Employment Authorization Document