Informatica Developer

SEJAL PATEL Email: ad5dqo@r.postjobfree.com

ETL Informatica Developer Cell: 512-***-****

PROFESSIONAL SUMMARY:

6+ years of IT experience in the Analysis, Design, Development, Testing, and Implementation of Data warehousing and Database business systems for Banking, Financial, and Insurance domains.

Excellent experience in designing and developing of ETL Methodology using Informatica PowerCenter 10.5,10.2,9.6.1

Having experience in working with ORACLE 19c/12c, MySQL, SQL Server 2012/2014

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, design documentation, data mapping, build, unit testing, systems integration, user acceptance testing and defect fixing.

Prepared various types of documents like requirements gathering, ETL specification, Data Mapping, Test cases, Data dictionary, etc.

Expert in writing SQL queries using multiple databases like ORACLE, SQL Server, Teradata, MySQL, etc.

Experience in the integration of various data sources into the staging area.

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.

Experience in optimizing the Mappings and implementing complex business rules by creating reusable transformations like Mapplets.

Extensively used the Slowly Changing Dimension (SCD) technique in business applications.

Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for company merger projects. Heavily created Mapplets, user-defined functions, reusable transformations, and look-ups.

Daily Stand-up with Scrum Master and Weekly status meeting with Business Owner and project manager.

Semantic Code checking using uDeploy version control tool.

Resolving Service Now Incidents and application issues in the production environment.

Experience in developing reports and dashboards using Tableau.

Working experience in Agile and Waterfall methodologies.

EDUCATION:

Master from Gujarat University, India

TECHNICAL SKILLS

ETL TECHNOLOGY

Informatica PowerCenter 10.5, 10.2, Power Exchange, Informatica Intelligent cloud services(IDMC)

DATA WAREHOUSE

Star Schema, Snowflake schema

DATABASES

Oracle 18c/12c, SQL Server 2017/2014, MySQL, SQL,TOAD, SQL*PLUS,

OPERATING SYSTEMS

UNIX

APPLICATIONS

MS Office, Toad 9.2/8.6

OTHER

Bitbucket, Putty, Rally, SecureFX, Mainframe, Tableau, Cognos, Service NOW, uDeploy, Jira

PROFESSIONAL EXPERIENCE

Client: PNC Bank, Pittsburgh, PA July 2022 to June 2023

Role: ETL Informatica Developer

The project is all about changing how we look at information. Instead of focusing only on accounts, we're now looking at everything related to customers in the PNC Investment group. My job is to sort and organize data to better understand customers and make sure all our applications show the same information.

Responsibilities:

Worked on Power Center Designer tools like Source Analyzer, Mapping Designer, Mapplet Designer and

Transformation Developer.

Developed mappings using Informatica and performed tuning of mappings for better and more efficient performance.

Analyzed the existing mapping logic to determine the reusability of the code.

Created Mapping Parameters, Session parameters, Mapping Variables, and Session Variables.

Implemented SCD Type-1 and Type-2 using informatica mapping.

Integrated different tasks and sessions for the workflow using workflow manager.

Performed Unit testing and data validation for different scenarios, supported System testing, Regression testing and UAT.

Used Power Exchange to read source data from mainframe systems and power center for ETL and DB as targets.

Used Debugger within the Mapping Designer to test the data flow between source and target and to

troubleshoot the invalid mappings.

Populated the business rules using mappings into the target tables.

Managed performance and tuning of SQL queries and fixed the slow-running queries in production.

Modified UNIX scripts to run informatica workflow.

Effectively met the deadline by completing given tasks on time.

Migrated code by CI/CD pipeline using GIT and Bitbucket, including ETL and database code, and successfully transferred workflows, mappings, and sessions to QA and Production environments.

Updated existing mappings to meet new requirements.

Environment: Informatica PowerCenter 10.5, Power Exchange, SQL, Oracle 18c, TOAD, CA7, Shell Scripting, SecureFX, UNIX, Jira, Bitbucket

Client: Charles Schwab, Austin, TX Jan 2020 to June 2022

Role: ETL Informatica Developer

The goal of this project is to integrate its daily transactional data into a central data warehouse to serve multiple purposes including enterprise reporting needs using the ETL Informatica tool into Oracle target tables/views.

Responsibilities:

Worked with business analyst for requirement gathering, business analysis, testing, business process descriptions, scenarios, and workflow analysis.

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.

Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test and 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.

Modified UNIX scripts to run informatica workflow.

Tuned the mappings by removing the Source/Target bottlenecks and Expressions to improve the throughput of the data loads.

Created different parameter files and started sessions using these parameter files using the pmcmd command to change session parameters, mapping parameters, and variables at runtime.

Environment: Informatica PowerCenter 10.2, SQL, Oracle 12c, TOAD, Control M, Shell Scripting, Rally, Tableau

Client: Cullen/Frost Bankers, Inc., San Antonio, TX Mar 2018 to Jan 2020

Role: ETL Informatica Developer

This project helps clients and Stakeholders with long-term decision-making, strategic plans, support, and solutions giving mainstream users the ability to access and analyze and help stakeholders automate the extraction process for down-line applications.

Responsibilities:

Actively involved in interacting with business users to record user requirements and Business Analysis.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Developed the Informatica Mappings by the 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 the requirement and loading into data warehouse tables.

Developed several reusable transformations and mapplets that were used in other mappings.

Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.

Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.

Migrated Mappings, Sessions, and Workflows from Development to Test and then to UAT environment.

Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.

Improved performance testing in Mapping and the session level.

Coordinated with multiple teams to run Informatica jobs for loading historical data in production.

Maintaining bug, status using JIRA tool

Environment: Informatica PowerCenter 9.6.1, SQL Server 2012, Shell Scripts, ORACLE 12c, SQL, UNIX, Toad, SQL Developer, JIRA

Client: Client: Anthem, Inc., Chicago, IL Jul 2016 to Mar 2018

Role: ETL Informatica Developer

Led the construction of a data warehouse, merging diverse data for trend analysis, using Informatica for integration and Cognos for enterprise reporting in response to market dynamics.

Responsibilities:

Worked on Power Center Designer tools like Source Analyzer, 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 validated the data.

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 the 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.

Environment: Informatica Power Center 9.1.1, Oracle 11g, SQL, JIRA, Cognos

Contact this candidate