Uploaded File
no photo
Samatha
Informatica Developer
Madison, WI
Check for availability
Actively seeking
no photo
Samatha
45
views
Informatica Developer
0
Recommendations
Average rating
45
Profile views
UNIX Informatica Developer Triggers Stored Procedure Data Warehousing Star Schema ETL Informatica 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
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
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
Summary

  • 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
UNIX
2019
Informatica Developer
2019
Triggers
2019
Stored Procedure
2019
Data Warehousing
2019
Education and Certifications
Madras University
Scrum Master Accredited Certification (SMAC),
Product Owner Accredited Certification (SPOAC),
Preferences
Availability:
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