SUMMARY

• Associate having 12 + years of experience in the Data Warehousing & Business Intelligence Solutions (Informatica PowerCenter /Informatica Cloud/ORACLE - SQL, PLSQL/Teradata/SFDC(SALESFORCE).
• Played various roles on projects that required Datawarehouse development and Prod support which include Technical lead, Team lead, Developer and Managerial roles with a maximum project team.
• Have extensively worked in developing ETL applications for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Created Informatica mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Connected and Unconnected Lookup, Normalizer, Stored Procedure, filter, Sequence generator, Router and Update strategy.
• Hands on experience in Integration with Salesforce (Veeva CRM) using Informatica On Demand
• Experience with Snowflake- Cloud based Data Warehouse architecture.
• Experience with data analysis and Dimensional Data Modeling (specific to a data warehouse), Star schema/Snowflake schema, fact and dimension tables.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Experience in databases such as Oracle, SQL Server, DB2, MongoDB and Teradata
• Completed Informatica S - PowerCenter Mapping Design and S - PowerCenter Architecture external certification.
• Handling ETL part for HL7, XML and JSON format
• Strong skills in coding and debugging Teradata utilities like Fast Load, Fast Export, MultiLoad and Tpump for Teradata ETL processing huge volumes of data throughput.
• Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata
• Worked on Agile methodologies
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Performance tuning is performed at the Mapping, Session level as well as the Database level to increase the data throughput
• Designed the Process Control Table that would maintain the status of all the CBR process.
• Extensive experience on deploying Workflow, Session on Grid.
• Extensive experience in error handling and problem fixing in Informatica.
• Deployment & Post Deployment Support
• Extensive experience in Unix scripting
• Created Unix script for FTP source files from remote location to informatica source location
• Tracking all types of testing issue in JIRA.
• Migration of informatica objects across different environment like Dev, SIT, UAT &Prod
• Create, backup and restore for Informatica Repositories.
• Quick learner with the ability to make solutions-oriented, creative and innovative contributions in highly demanding situations.
• Good Knowledge and experience in Informatica architecture design and implementation.
• Strong skills in designing and implementation of data marts and data warehouse solutions using standard software development life cycle.
• Domain knowledge in Banking and Finance, Healthcare, Retail, Life science, Insurance and Telecom.
• Excellent communication and inter-personal skills, accustomed to working in both large and small team environments.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1/9.6/10.1 , Informatica Cloud, Informatica IDQ and SSIS

Cloud Environment: AWS, Informatica Cloud, Salesforce(Veeva)

DATABASE: Oracle 10g, MS-SQL Server, DB2, Teradata and MongoDB.

Reporting Tools: Business Object, COGNOS

Languages: C, C++ and Java

Operating System: UNIX, Windows NT, 2000, XP

Scheduling Tools: Control M, Autosys and Tidal scheduling

Tools: Toad, SQL Developer, Erwin, JIRA, WinSCP, Putty, AML and Python

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica Developer

Tools: Informatica POWERCENTER 10.1, Oracle, MS-SQL Server, AutoSYS, Unix and Windows 7.

Responsibilities:

• Played the role of ETL Informatica Developer.
• Involved in understanding the requirements, Design, Development and Testing.
• Extensively used Transformations like Router, Lookup, Aggregator, Sorter, Union, Expression and Update strategy.
• Involved in ETL development and testing
• Preparing the unit test scripts
• Analysis of the Source System Data and Interfaces
• Perform troubleshooting analysis for critical applications.

Confidential

ETL SENIOR Informatica Developer

Tools: Informatica POWERCENTER 9.6, Informatica IDQ, Oracle, MS-SQL Server, AutoSYS, Actimize, Unix, AML and Windows 7.

Responsibilities:

• Played the role of onsite Lead & Senior ETL Developer.
• Involved in understanding the requirements, functional specification, Design, Development and Testing.
• Extensively used Transformations like Router, Lookup, Aggregator, Sorter, Union, Expression and Update strategy.
• Actively involved in requirement Analysis and Design phase
• Actively involved in Data mapping Observation Analysis in Design phase
• Involved in ETL design documents
• Involved in ETL development and testing
• Preparing the unit test scripts
• Analysis of the Source System Data and Interfaces
• Production Support
• Perform troubleshooting analysis and resolution of critical applications and batch processes
• Coordinating with offshore team