Sai ShashankPanchangam

Contact: +1-925-***-**** E-mail: ac0lsw@r.postjobfree.com

Sr. Informatica Developer

Over 8+ years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Database and Data Warehouse Software Applications

Involved in designing, development and production support of Data Warehouse. Extensive experience in Informatica Power Center 9.x/8.x/7.x/6.x/5.x to carry out Extraction, Transformation and Loading process.

Hands on experience in Full Life Cycle Development of Data warehouse design Process.

Thorough understanding in Data Warehouse and Business Intelligence concepts with emphasis on Repository Manager, Master Data Management (MDM), Designer, Workflow Manager and Workflow Monitor.

Expert skills in OLAP, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi-dimensional modeling.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and worked on integrating data from flat files like fixed width and delimited

Have extensively worked in developing for supporting Data Extraction, transformations and loading using Informatica Power Center

Experience in all aspects of project development life cycle in Data Warehousing.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access, DB2 and flat files using Informatica.

Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations

Experience in using the Informatica command line utilities like paced to execute Workflows in non-windows environment

Experience in debugging mappings; Identified bugs in existing mappings by analyzing the data flow and evaluating transformations

Hands on experience in Performance Tuning of sources, targets, transformations and sessions.

Extensively worked with Stored Procedures, Triggers, Cursors, Indexes, Functions and Packages.

Expertise in PL/SQL development and SQL Query tuning for better performance.

Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases. Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model.

Performance Tuning at various levels such as Source, Target, Mapping, Session, and System.

Implemented complex business rules in Informatica by creating re-usable transformations,robust mappings/mapplets.

Worked on UNIX-shell Scripting for Pre-Session, Post-Sessions tasks and automated the scripts using a scheduling tool.

Experience in using Workflows, Worklets and Mapplets.

Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.

In-depth understanding of Star Schema, Snow Flake Schema, Normalization, 1st NF, 2nd NF, 3rd NF, Fact tables, Dimension tables.

Experience working in both Software waterfall model and Agile Methodology.

Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member with excellent Verbal and Communication Skills and clear understanding of Business procedures

Expertise in development of stored procedures and functions to develop business rules.

Extensively used scheduling tools like Control M, Autosys, etc

Hands on expertise in working with data processing solutions like Hadoop, Hbase, Hive.

Experience in extracting data from Hadoop and Hive using informatica and informatica power exchange.

Skill Synopsis

Skill Set

Name

Databases

Oracle 11g/10g/9i, Teradata V2R4, DB2, Netezza, TOAD, MS SQL Server 2008, 2012, SAP BW, SAP Logon

Programming Languages

C, C++, SQL, PL/SQL, UNIX Shell Scripts, Web services (SOAP/REST)

ETL Tools

Informatica Power Center 9.5, 8.6, 8.5.1/ 8.1 / 7.1.3 / 7.0 / 6.2, Informatica Data Explorer and Informatica Data Quality,SSIS,SSRS,SSAS

Data Modeling Tools

Erwin 4.0 / 3.5, Business Objects 6.0

Operating Systems

Win 95/98/2000/XP, UNIX / Korn Shell.

Web Technologies

HTML, XML, JavaScript, and VB Script.

BI Tools

Business Objects 6.x, Cognos 8.0

Scheduling Tools

Autosys, Control – M, Tidel

Reporting Tools

SSAS,SSRS,TABLEAU, EXCEL .

Work Experience

ETL/ Informatica Developer Jul’15 – Till Date

Bank of the West, San Ramon. CA

Responsibilities:

Responsible for Requirement Gathering Analysis and End User Meetings

Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications

Responsible for mentoring Developers and Code Review of Mappings developed by other developers

Extracted data from various heterogeneous sources like Oracle, Sybase, SQL Server, and Flat Files.

Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs

Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.

Responsible for best practices like naming conventions, Performance tuning, and Error Handling

Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level

Solid Expertise in using both Connected and Un connected Lookup transformations

Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache

Developed Re-Usable Transformations, and Re-Usable Mapplets

Worked with Shortcuts across Shared and Non-Shared Folders

Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all environment

Performed data manipulations using various Informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Update strategy and Sequence generator etc.

Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.

Extensively utilized the Debugger utility to test the mappings.

Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.

Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.

Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.

Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.

Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.

Defined Mapping parameters and variables and Session parameters per requirements and performance related issues.

Environment:Informatica Power center (v9.5), TDM, Data Quality, Power Exchange, Sybase,SQL Server, Oracle 10g/11gSQL, UNIX, AUTOSYS, Windows 7.

Informatica Developer Apr’12 –Jun’15

EMC Corporation, Santa Clara.CA

Responsibilities:

Interacted with business users and team leads for better understanding of business specifications and requirements, Identifying data sources and Development strategies.

Analyzed business requirements, technical specifications, source repositories and physical data models for ETL mappings.

Worked extensively with mappings using expressions, aggregators, filters, lookup, joiner, update strategy and stored procedure transformations.

Coordinated and developed documentation related to ETL design and development.

Used update strategy transformation to effectively migrate data from source to target.

Used repository manager to create repository, user groups and managed users by setting up privileges.

Created stored procedures and invoked from Informatica.

Used Informatica debugger to debug the mappings.

Performed partitions on sources to improve the performance.

Optimized the mappings and implemented the complex business rules by creating re-usable transformations and mapplet.

Used Informatica workflow manager for create, ran batches and sessions and scheduled them to run at specified time.

Involved in Performance Tuning of mappings, SQL overrides and stored procedures.

Improved the performance of ETL process by indexing and caching

Created workflows, tasks, database connections, FTP connections using workflow manager.

Created UNIX shell scripting for automation of ETL process.

Developed simple & complex mappings using Informatica to load dimension & fact tables as per STAR Schema techniques

Analyzed Session log files to resolve errors in mapping and managed session configurations

Environment:Informatica Power Center 8.6, Oracle 10g, SQL Server 2005, Oracle Designer, Toad, PL/SQL, Linux, Erwin and Windows 2000 / XP.

Informatica Developer Jul’10 – Mar’12

Polycom,Herndon.VA

Responsibilities:

Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.

Used Informatica Power Center 9.0.3 for migrating data from various OLTP servers/databases to the data mart.

Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.

Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.

Expertise in developing SQL and Oracle PL/SQL code as procedures functions and packages to implement the business logic.

Database logical Modeling and physical design multiple schema creation and maintenance on multiple platforms and supported for the application development team.

Created stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes.

Extracted data from and to relational, flat file sources and XML data.

Data cleansing extracted data from Hadoop and Hive sources .

Extensively used ETL to load data from wide range of sources such as flat files, XML to Oracle.

Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.

Developed shell scripts for merging load fact tables, cleanup and Archive process for the entire Group subject area.

Developed schedules to automate the update processes and Informatica sessions and batches

Data Quality Analysis to determine cleansing requirements.

Documented data conversion, integration, load and verification specifications.

Developed complex mappings using corresponding Source, Targets and Transformations, which were optimized for maximum performance.

Created mappings using various transformations like update strategy, lookup, stored procedure, router, filter, sequence generator, joiner, aggregate, and expression transformation.

Created reusable transformations and Mapplets in the designer using transformation developer and Mapplets designer tools.

Created different parameter files and started sessions using these parameter files using pmcmd command. Session parameters, mapping parameters, and variables are changed at run time.

Modified the PL/SQL stored procedures to meet the changing standards.

Scheduled mappings using Control-M Scheduler.

Generated completion messages and status reports using Informatica Server Manager.

Created and monitored Batches and sessions using Informatica Server Manager.

Worked in the performance tuning of the programs, ETL procedures and processes.

Developed shell scripts to automate the update processes.

Environment:Informatica Power Center 9.0.3, Oracle 11g, Netezza. PL/SQL, UNIX Shell Scripts, OBIEE, Power Exchange, Sun Solaris 9.0, Erwin 4.0, Windows XP, Control M scheduler.

ETL Developer May’08 – June’10

Vanguard,Malvern.PA

Responsibilities:

Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.

Interacted with Source system SME's to analyze how various business processes have been tracked across the source tables.

Designed Data warehouse target tables by using Dimensional Modeling Techniques.

Created Dimensions and Fact tables using Erwin.

Extracted data from various data sources such as Oracle, Flat file, XML, DB2 and transformed and loaded into targets using Informatica.

Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.

Designed and developed initial and incremental data loads using Informatica.

Designed and Developed several mapplets and worklets for reusability.

Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.

Developed sessions using different types of partitioning techniques like round robin, hash key portioning for better performance.

Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.

Implemented CDC using Informatica Power Exchange.

Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.

Created Shell scripts with PMCMD command and scheduled using Maestro scheduler for nightly batch processing.

Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems per the user requirements.

Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.

Provided Nightly batch loads support and implemented solutions to correct the data issues raised by end user during production support phase of the project.

Environment:Informatica Power Center 8.5, Oracle SQL, Pl/SQL 10g, Unix Maestro, XML, Flat files, Erwin, AS 400 DB2, Windows XP, UNIX, Shell Scripting.

Contact this candidate