SUMMARY

• 5 + years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for Banking, Financial and Insurance domains.
• Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.2, 9.6.1/9.1.1
• Having experience in working with ORACLE 11g/10g, MySQL, SQL Server 2017/2014, Teradata 16 databases.
• Expert in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. x
• Worked extensively in design and analysis of Requirements, Development, testing and Production deployment.
• Prepared various types of documents like ETL specification, Data Mapping, Test cases, Data dictionary etc.
• Expert in writing SQL query using multiple databases like ORACLE, SQL Server, Teradata, MySQL etc.
• Extensive knowledge of Informatica tuning and SQL tuning.
• Experience in integration of various data sources into staging area.
• Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
• Designed and developed complex mappings, mapplets, tasks and workflows and tuned it.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Good understanding of teh Data modeling concepts like Star - Schema Modeling, Snowflake Schema Modeling.
• Moderate experience in Informatica Change Data Capture Management
• Experience in optimizing teh Mappings and implementing teh complex business rules by creating re-usable transformations like mapplets.
• Extensively used Slowly Changing Dimension (SCD) technique in business application.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced teh execution time for huge volumes of data for a company merger projects.
• Working experience in Agile and Waterfall methodologies.
• Good experience in working with onshore, offshore team and End to End teams to ensure commitments are met.

TECHNICAL SKILLS:

ETL TECHNOLOGY: Informatica PowerCenter 10.2, 9.x

DATA WAREHOUSE: Star Schema, Snowflake schema

DATA MODELLING: Erwin 9.5/7.1

DATABASES: Oracle 12c/11g, MS SQL Server 2017/2014, MySQL

APPLICATIONS: MS Office, Toad 9.2/8.6Others Quest, TOAD, SQL, WinSCP, Putty, Rally

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Documented Data Mappings/ Transformations as per teh business requirement.
• Prepared Technical Design documents and Test cases.
• Creating and maintaining source-target mapping documents for ETL development team.
• Created mappings using Designer and extracted data from various sources, transformed data according to teh requirement.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed teh Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to teh requirement and loading into data warehouse tables.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Developed transformation logic as per teh requirement, created mappings and loaded data into respective targets.
• Used SQL tools like TOAD to run SQL queries to view and validate teh data loaded into teh warehouse.
• Created summarized tables, control tables, staging tables to improve teh system performance and as a source for immediate recovery of database
• Migrated Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Wrote hundreds of SQL query for data analysis to validate teh input data against business rules.
• Responsible for determining teh bottlenecks and fixing teh bottlenecks with performance tuning.
• Extensively worked on Unit testing for teh Informatica code using SQL Queries and Debugger.
• Used PMCMD command to start, stop and ping server from UNIX.
• Improved performance testing in Mapping and teh session level.
• Coordinated with scheduling team to run Informatica jobs for loading historical data in production.
• Maintaining bug, status using JIRA tool

Environment: Informatica PowerCenter 10.2, Tableau 2020.3, Cognos 11, SQL, Oracle 12c, SQL Server 2017, Oracle SQL Developer, TOAD, Control M, Rally

Confidential, Mooresville NC

Informatica Developer

Responsibilities:

• Worked with business users to get teh requirement and to involve in complete SDLC of this project
• Analyzed source data and gathered business requirements from teh business users and source data team
• Created Technical Design Document from business requirements document (BRD).
• Analyzed business and system requirements to identify system impacts.
• Created teh Detail Technical Design Documents which have teh ETL technical specifications for teh given functionality.
• Prepared source to target mapping and conducted meetings with teh business to understand data / transformation logic.
• Analyzed teh existing mapping logic to determine teh reusability of teh code.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Done teh extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test and supported teh UAT for teh client.
• Performing ETL and database code migrations across environments using deployment groups.
• Populating teh business rules using mappings into teh target tables.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Managed performance and tuning of SQL queries and fixed teh slow running queries in production.
• Created batch scripts for automated database build deployment.
• Used prewritten scripts to run informatica workflow.

Environment: Informatica PowerCenter 9.6.1, SQL Server 2017, ORACLE 12c, SQL, UNIX, Toad, SQL Developer, Cognos 9, Control M, JIRA

Confidential, Longwood, FL

Informatica Developer

Responsibilities:

• Co-ordination from various business users’ stakeholders and SME to get Functional expertise, design and business test scenarios review, UAT participation and validation of data from multiple sources.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Debugger within teh Mapping Designer to test teh data flow between source and target and to troubleshoot teh invalid mappings.
• Created Mappings using Mapping Designer to load teh data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Used SQL to analyze source data, performed data analysis and validate teh data.
• Scheduled Informatica Jobs through Autosys scheduling tool.
• Studying teh existing system and conducting reviews to provide a unified view of teh program.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Involved in creating Informatica mappings, Mapplets, worklets and workflows to populate teh data from different sources to warehouse.
• Responsible to facilitate load testing and benchmarking teh developed product with teh set performance standards.
• Involved in testing teh database using complex SQL scripts and handled teh performance issues effectively.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL, SQL Server 2014, Cognos, JIRA