SUMMARY

• 7+ years of extensive experience with ETL tool Informatica Power Center /Power Mart Power Exchange in designing and developing Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• 7+ years of Database experience using Oracle, PL/SQL, SQL Server. Strong Experience on database interfaces like SQL developer and TOAD.
• 3 years of experience with Informatica Data Quality 9.6.1 (IDQ) toolkit, in Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities.
• Almost 3 years of Experience in using Python in ETL data warehousing.
• Good exposure and experience in all phases of project SDLC( Software/Project development life cycle) like requirement gathering, analysis, design, development, testing and production support.
• Have performed various testing activities like Unit Testing, Integration, System Testing, Regression Testing and User Acceptance Testing and ensured that the code is ideal.
• Experience in Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Experienced in automating the Informatica jobs, also experienced in Autosys, UNIX scripts for automation.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner.
• Worked on different kinds of source and target systems like Oracle, Teradata, Flat file, DB2, Postgress, ODS.
• Experience in various domains like Healthcare, Banking, Financial investment services and Entertainment.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Powercenter Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensive experience in production support, solving various tickets within SLA's.
• Able to finish all the assigned user stories with in the sprint including Unit testing and documenting the results.

TECHNICAL SKILLS

Data Warehousing / ETL Tools: Informatica Power center (Repository Admin Console, Repository Manager, Designer, Workflow Manger, Workflow Monitor, Power Exchange), Informatica IDQ.

Data Modeling: Star Schema Modelling, Snow Flake Modelling.

Databases: Oracle 12c, Oracle 11g, Db2, SQL Server.

Languages: SQL, PL/SQL, Python 3.8, core java basics, Unix Shell Scripting, Linux.

Tools: Toad, SQL* plus, Putty, SVN, Autosys, Tivoli, IBM RTC, Power BI.

Operating Systems: Windows& Linux

Agile: Rally, Kanban, Jira.

Testing: Quality center.

PROFESSIONAL EXPERIENCE

Confidential

ETL - Informatica Developer

Responsibilities:

• Conducted requirement gathering meetings to get the requirement details and SLA details.
• Worked on creating mappings, sessions, workflows as per the business requirement and transformed the mapping document in to informatica mappings and workflows.
• Worked on unit testing and attached the results to Jira.
• Created shell scripts to do the file validations to make sure the source files are in correct format and scheduled these shell scripts before the actual informatica job picks the source files.
• Worked on creating SCD mappings to load the data.
• Used almost all types of transformations like expression, input, lookup, aggregator, update strategy and joiner.
• Worked on performance tuning of the existing workflows.
• Worked on Python scripts to do the data loads from source to STG and STG to Reporting layer data base.
• Worked on developing the Web Services using REST API’s for sending and getting data from the external interface in the JSON/XML format.
• Worked on Control-M to schedule the informatica jobs.

Environment: Informatica power center 10.2.0, Oracle 12c, SQL, PL/SQL, Python, Unix, Control-M, Putty, Jira, Winscp.

Confidential, Raleigh, NC

ETL-Informatica Consultant

Responsibilities:

• Involved in requirement gathering meetings to get the requirement and transformed that requirement into mapping and created workflows.
• Created mappings, sessions, workflows for the requirements and conducted code reviews and Test results review.
• Worked on testing ETL applications in testing environments Acceptance, Integration and Performance environments of the Data hodlers team.
• Created tables and Views as part of the requirement.
• Created and modified SCD Type1, Type2 and Type3 mappings.
• Worked on loading CDC (Change data capture) Data in the Reporting Layer and build the views on the top of the reporting layer to expose the data to the business users.
• Followed the project development standards to clearly log information of failure or succeeded whenever a work flow executed.
• Used different types of transformations like router, expression, update strategy, Aggregate and joiner.
• Created Stored procedures, SQL, PL/SQL scripts for informatica Load process.
• Worked on Performance tuning of the existing workflows without affecting the existing business requirement.
• Loaded the DB2 data into Oracle database by using Informatica and created Views on the target table by exposing the required columns to the business users.
• Worked with different source systems DB2, Postgres, ODS and flat files.
• Created parameter files for the inofrmatica workflows and sessions.
• Created test scripts and executed them to test the application.
• Prepared Technical specification document (TSD) and test results documents.

Environment: Informatica power center 10.2.0, Oracle 12c, SQL/PLSQL, Unix, Control-m, DB2, Postgress, Teradata, Exadata, Putty, Winscp, SQL developer, jira Kanban board, Agile, windows 10.