SUMMARY:

*+ 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 HealthCare, and financialdomains.

Experience in Informatica PowerCenter10.4, 9.6.1, 9.1, along with a strong background ETL skill for Data warehousing using Informatica.

Good experience in developing ETL applications and statistical analysis of data on databases ORACLE 11g/12c, and SQL Server 2016.

Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.

Have ability to write and interpret SQL statements and good in SQL optimization and performance tuning.

Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.

Strong experience in implementing CDC using Informatica Power Center.

Extensively worked on Informatica Power center transformations as well like Expression, Joiner, Sorter, Filter, Router, and other transformations as required.

Good in Data Warehouse Concepts like Dimension Tables, Fact tables, Slowly Changing Dimensions, DataMart’s, and Dimensional modeling schemas.

Experience in Data modeling; Dimensional modeling and E-R Modeling and OLTP AND OLAP in Data Analysis. Very familiar with SCD1 and SCD2 in snowflake schema and star schema.

Strong experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts and Data Warehouse using Informatica power center components.

Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools -Task Developer, Workflow & Worklet Designer.

Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.

Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Experience in tuning and scaling the SQL for better performance by running explain plan and using different approaches like hint and bulk load.

Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger projects.

Good experience in using UNIX command.

Skilled in creating & maintaining ETL Specification Documents, Use Cases, Source to Target mapping, Requirement Traceability Matrix, performing Impact Assessment and providing Effort estimates, deployment artifacts

EDUCATION:

Bachelor in Computer Science from Jawaharlal Nehru Technological University, India

TECHNICAL SKILLS:

ETL

Informatica PowerCenter 10.4, 9.5.1, 9.1

RDBMS

Oracle 11g/12c, SQL Server 2017, MySQL, PostgreSQL

Other Tools

SQL, Notepad++, Toad, SQL Navigator, Control M, ESP, JIRA, Rally

PROFESSIONAL EXPERIENCE:

LPL Financial Holdings Inc., San Diego, CA Duration: Sept 2020 to Current

Role: Informatica Developer

DescriptionLPL Financial Holdings Inc. provides an integrated platform of brokerage and investment advisory services to independent financial advisors and financial advisors at financial institutions in the United States. Its brokerage offerings include variable and fixed annuities, mutual funds, equities, retirement and education savings plans, fixed income, and insurance. The objective of this project is to integrate Customer data from multiple source system into data mart and support it stakeholder for making better decision. It helps users / businesses make decisions by binding their data.

Responsibilities:

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

Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.

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.

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.

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

Created batch scripts for automated database build deployment.

Experience using UNIX scripts to run Informatica workflow.

Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.

Environment:Informatica Power Center 10.4, SQL Server 2017, Putty, Notepad++, Control-M, Flat files, JIRA, WinSCP

Tenet Healthcare Corp, Dallas, TX Duration: Apr 2019 to Sept 2020

Role: Informatica Developer

Tenet Healthcare Corporation operates as a diversified healthcare services company. The company operates in three segments: Hospital Operations and Other, Ambulatory Care, and Conifer. Its general hospitals offer acute care services, operating and recovery rooms, radiology and respiratory therapy services, clinical laboratories, and pharmacies. The company also provides intensive and critical care, and coronary care units; physical therapy, orthopedic, oncology, outpatient services and many more for various medical specialties.

This project receives data from various source system using ETL to build corporate report/dashboard to help the payer and providers work together to improve outcomes, reduce opioid prescriptions and target patients for preventive care.

Responsibilities:

Involved in all phases of SDLC from requirement gathering, design, development, testing, user training and warranty support.

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

Translated requirements into business rules & made recommendations for innovative IT solutions.

Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.

Involved in documentation of Data Mapping & ETL specifications for development from source to target.

Parsing high-level design spec to simple ETL coding and mapping standards.

Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Created the design and technical specifications for the ETL process of the project.

Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy.

Performance tuning of the process at the mapping level, session level, source level, and the target level.

Created Workflows containing command, email, session, decision and a wide variety of tasks.

Tuning the mappings based on criteria, creating partitions in case of performance issues.

Tested End to End to verify the failures in the mappings using scripts.

Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.

Facilitated in developing testing procedures, test cases and User Acceptance Testing

Developed Parameter files for passing values to the mappings for each type of client

Scheduled batch and sessions within Informatica using Informatica scheduler

Leveraged WinSCP to do flat file transfers from Source system to target destination.

Environment:Informatica Power Center 9.5.1, SQL, Oracle 11g, TOAD, Control M, JIRA

Molina Healthcare, Long Beach, CA Duration: Jun 2017 to Apr 2019

Role: Informatica Developer

Molina Healthcare is focused exclusively on government-sponsored health care programs for families and individuals who qualify for government sponsored health care.

Molina Healthcare contracts with state governments and serves as a health plan providing a wide range of quality health care services to families and individuals. Molina Healthcare offers health plans in California, Florida, Illinois, Michigan, New Mexico, New York, Ohio, South Carolina, Texas, Utah, Washington, Wisconsin and Puerto Rico. Molina also offers a Medicare product and has been selected in several states to participate in duals demonstration projects to manage the care for those eligible for both Medicaid and Medicare. This Project involves development of ETL processes to integrate data received from multiple sources into a target. Informatica is leveraged those extracts, transforms and load into target.

Responsibilities:

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

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, Integration 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 data validations.

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

Involved in testing the database using complex SQL scripts and handled the performance issues effectively.

Created batch scripts for automated database build deployment.

Ensured acceptable performance of the data warehouse processes by monitoring, researching and identifying the root causes of bottlenecks.

Environment:Informatica Power Center 9.1, Oracle 11g, Cognos 10.4, Flat files, SQL, Putty, Toad, Rally

Contact this candidate