Uploaded File
add photo
Samatha
samatha.etl@gmail.com
908-330-8182
Madison, WI 53704
Informatica Developer
12 years experience W2
0
Recommendations
Average rating
127
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
Informatica Developer
Information Technology
Aug 2013 - present
  • Participated in business requirement review meetings with BA’s, Solution Architect and users
  • Involved in developing complex Informatica mappings using transformations like, such as Source Qualifier, Expression, Look-up, Update Strategy, Filter,Router, Joiner, SQL Transformation etc
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data
  • Developed Informatica mappings for TYPE 1, 2 Slowly Changing Dimensions
  • Used Star Schema approach for designing of database for the data warehouse
  • Involved in developing mappings to load data from Flat files which includes fixed width files, Delimited files and also the relational database
  • Used various Tasks like Control, Assignment, Timer, Event-Wait, Event-Raise, Email as a part of Workflow Logic as per the requirements
  • Involved in Configuring sessions for incremental aggregation, pipe-line partitioning etc.
  • Created Sessions, Reusable Worklets, Reusable mapplets and workflows in Workflow Manager and Scheduled workflows and sessions
  • Worked on the teradata stored procedures and functions to confirm the data and have load it on the table
  • Involved in troubleshooting the load failures and Performance tuning by determining bottlenecks in sources, mappings and sessions
  • Worked with complex SQL queries to test the data generated by the ETL process against the target database
  • Experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata
  • Involved in identify the relationship between tables according to the requirements
  • Analyzed the transformation logic as per the Source to Target mapping document and source file workbook document to develop Informatica workflow mappings
  • Prepared Technical Design, Production Support Doc, Deployment Documents
  • Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations
  • Performance tuned and optimized various complex SQL queries
  • Worked on data warehouses with sizes from 30-50 Terabytes
  • Used TOAD to run SQL queries and validate the data in warehouse
  • Involved in Unit testing and providing support to the QA for testing the target data against the source data
  • Worked in Agile environment for rapidly changing or highly emergent requirements and following parallel development and testing

Environment: Informatica PowerCenter, Oracle 11g, Windows, Jira, Maestro, Teradata,SQL Server

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 Windows
Remove Skill
ETL/Informatica Developer
Information Technology
Aug 2012 - Jul 2013
  • Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets
  • Created Design Specification Documents including source to target mappings
  • Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target Star Schema
  • Extracted data from various source systems like Oracle, SQL Server, XML and flat files and loaded into relational data warehouse and flat files
  • Designed and developed complex mappings using various transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more
  • Created and scheduled Sessions, Jobs based on on-demand using Workflow Manager
  • Modified the existing worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger
  • Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
  • Experienced in designing and integrating the Enterprise Data warehouse and Data Marts in different environments like Teradata, Oracle
  • Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
  • Debugged and resolved load failures by verifying the log files. Supported QA Testing in fixing the bugs and also helped to resolve various data issues
  • Used SQL tools like Teradata SQL Assistant to run SQL queries and validate the data.
  • Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse
  • Provided 24x7 production support for business users and documented problems and solutions for running the workflows

Environment : Informatica PowerCenter 9.0.1, Teradata, MS SQL Server, Flat Files,UNIX, Windows,

CA workload Automation,SQL Server.

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 Windows
Remove Skill
Informatica Developer
Information Technology
Jul 2008 - Jul 2012
  • Involved in requirements gathering and analysis for the entire application
  • Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations
  • Used Star Schema approach for designing of database for the data warehouse
  • Involved in complete SDLC of the application
  • Designed and Implemented the Extraction, Transformation, and Load (ETL) techniques built using Informatica, SQL, PL/SQL and Unix Shell Scripting
  • Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
  • Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users
  • Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console
  • Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, mapplets ,dynamic lookups and reusable transformations in ETL maps
  • ETL performance (Data base and ETL jobs) by optimizing back end queries, by implementing techniques like index drop and re-create, table partition, parallelism etc
  • Experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata
  • Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to Teradata RDBMS using BTEQ, MultiLoad and Fast Load
  • Performed Database/ETL migrations from Dev environment to Test/Training/UAT/Staging and PROD environments

Environment:Informatica, Power Center, Oracle 9i, PL/SQL Developer,TWS Toad, ER-Studio, UNIX,Autosys,SQL server,Teradata.

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 SQL Developer
Remove Skill
Edit Skills
Non-cloudteam Skill
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
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