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 2014/2017 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, 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 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 the Data modeling concepts like Star - Schema Modeling, Snowflake Schema Modeling.
• Moderate experience in Informatica Change Data Capture Management
• Experience in optimizing the Mappings and implementing the 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.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Working experience in Agile and Waterfall methodologies.
• Excellent communication skills, self-motivated, quick learner, and outstanding team player.

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica PowerCenter 10.2/9.6/9.0.1

DATA WAREHOUSE: Star Schema, Snowflake schema

DATA MODELLING: Erwin 9.5/7.1

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

APPLICATIONS: MS Office, Toad 9.2/8.6

Others: TOAD, SQL, WinSCP, Putty, Rally

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Informatica Developer

Responsibilities:

• Actively involved in interacting with business users to record user requirements and Business Analysis.
• UsedInformaticaas an ETL tool to create source/target definitions, mappings, and sessions to extract, transform and load data into staging tables from various sources.
• Develop Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Responsible for Creating workflows and Worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Maintained warehouse metadata, naming standards and warehouse standards in the ETL mapping.
• Develop Informatica SCD Type I and Type II mappings.
• Used SQL queries to view and validate the data loaded into the warehouse.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively working on Unit testing for the Informatica code using SQL Queries and Debugger.
• Use PMCMD command to start, stop and ping server from UNIX and used existing UNIX Shell scripts to automate the process.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Created Workflows containing command, email, session, decision, and a wide variety of tasks.
• Coordinate with Scheduling team to run Informatica jobs for loading historical data in production.
• Document Data Mappings/ Transformations as per the business requirement.
• Migration of code from development to Test and upon validation to Pre-Production and Production environments.
• Written documentation to describe development, logic, testing, changes and corrections.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Resolving the tickets based on the priority levels raised by QA team.
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions withinInformaticausingInformaticascheduler.
• Participated in weekly/Daily status meetings and conducted internal and external reviews as well as formal walkthroughs among various teams and documented the proceedings.

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

Confidential, Irving, TX

ETL Informatica Developer

Responsibilities:

• Worked with business users to get the requirement and to involve in complete SDLC of this project
• Analyzed source data and gathered business requirements from the 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 the Detail Technical Design Documents which have the ETL technical specifications for the given functionality.
• Prepared source to target mapping and conducted meetings with the business to understand data / transformation logic.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Done the 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 the UAT for the client.
• Performing ETL and database code migrations across environments using deployment groups.
• Populating the business rules using mappings into the 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 the slow running queries in production.
• Created batch scripts for automated database build deployment.

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

Confidential, Houston, TX

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 the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Created Mappings using Mapping Designer to load the 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 the data.
• Scheduled Informatica Jobs through Autosys scheduling tool.
• Studying the existing system and conducting reviews to provide a unified view of the program.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Involved in creating Informatica mappings, Mapplets, worklets and workflows to populate the data from different sources to warehouse.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL, SQL Server 2014, Cognos, JIRA