add photo
Samatha
samatha.etl@gmail.com
908-330-8182
Madison, WI 53704
Informatica Developer
16 years experience W2
0
Recommendations
Average rating
220
Profile views
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

Experience
Education
Madras University
Certifications
Scrum Master Accredited Certification (SMAC)
Product Owner Accredited Certification (SPOAC)
Skills
Project Management
2021
11
Informatica Developer
2021
10
Stored Procedure
2021
10
Triggers
2021
10
Unit Testing
2021
8
Windows
2021
8
Data Warehousing
2021
7
ETL
2021
7
Informatica
2021
7
Informatica Powercenter
2021
7
Oracle
2021
7
PL/SQL
2021
7
SQL
2021
7
SQL Server
2021
7
Star Schema
2021
7
Teradata
2021
7
TOAD
2021
7
UNIX
2021
7
Solutions Architecture
2021
6
Analysis
2013
4
PL/SQL Developer
2012
4
Requirements Gathering
2012
4
Scripting
2012
4
SDLC
2012
4
Shell Scripts
2013
4
SQL Developer
2012
4
UAT
2012
4
Agile Methodology
2021
3
Business Requirements
2021
3
Greenplum
2021
3
JIRA
2021
3
Junit
2021
3
Quality Assurance
2021
3
Data Analysis
0
1
Data Marts
2013
1
DB2
0
1
Linux
0
1
Metadata
0
1
Performance Tuning
2013
1
Salesforce
0
1
SSIS
0
1
Waterfall
0
1
XML
2013
1