DEEPTI WADHWA

ETL Informatica Developer

Contact: +1-551-***-****

Email: - adzoez@r.postjobfree.com

EXECUTIVE SUMMARY

Around 6 years of hands-on experience in the IT industry and a strong expertise in Informatica PowerCenter/Cloud, SQL, ETL concepts, EDW concepts, Data Analysis, SQL, PL/SQL, Unix command, Understanding Shell Scripting. In my career as an ETL Informatica Developer, I have developed complex ETL solutions that seamlessly ETL data between various systems, ensuring the integrity and accuracy of data. I have a solid understanding of data warehousing concepts; worked on efficient and scalable EDW Project that cater to the unique needs of diverse business stakeholders. My experience in the healthcare and banking domains has provided me with valuable insights into the industry-specific data challenges and regulatory requirements, enabling me to design and implement compliant and secure data solutions. As a SQL expert, have ability to write complex queries, perform data analysis, and write optimized SQL. My expertise in SQL performance tuning and optimization has resulted in significant improvements in query response times. Additionally, I possess extensive experience in ETL mapping performance tuning, ensuring efficient and streamlined data processing. I am well-versed in PL/SQL, Unix command execution, and understanding Shell Scripting, allowing me to efficiently interact with databases and automate tasks for enhanced productivity. My agile mindset has allowed me to collaborate effectively with cross-functional teams, delivering high-quality solutions within tight deadlines and adapting quickly to evolving project requirements.

PROFESSIONAL SUMMARY

●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 financial, Insurance and HealthCare domains.

●Exposure in writing SQL using analytical functions like Ranking, case statement etc., also in writing optimize SQL query using ORACLE 18c/12c, SQL Server 2019/2017 etc.

●Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.5, 9.6 and IICS.

●Experience in performing POC on IICS as a part of Informatica PowerCenter to Informatica Cloud conversion in the current Project.

●As a part of POC developed mapping using Source, Target, Lookup, Expression, Filter transformation in Informatica Cloud (IICS).

●Performed Data-synchronization task for Incremental load, Data replication tasks, Mapping and Task flows.

●Interacted with end-users to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.

●Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.

●Worked in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. x

●Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.

●Worked extensively in design and analysis of Requirements, Development, Testing and Production deployment.

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

●Expert in writing SQL query using multiple databases like ORACLE, SQL Server etc.

●Extensive knowledge of Informatica tuning and SQL tuning.

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

●Performed System testing, Integration testing and helped users for UAT; 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 in Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling.

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

●Used CI/CD pipeline to secure code in Bitbucket

●Having good knowledge of BI Reporting tool Tableau.

EDUCATION

●Bachelor in Arts from Kurukshetra University, India-2003

TECHNICAL SKILLS

ETL

Informatica PowerCenter 10.5, 9.6.1, 9.0.1, Informatica Cloud

Scheduling Tools

Control M, AutoSys

RDBMS

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

Other Tools

SQL, PL/SQL, Unix, Putty, WinSCP, Notepad++, Toad, SQL Navigator, JIRA, Rally, Excel, Git, Bicket

Reporting Tools

Tableau

Client: LPL Financial, Charlotte, NC Duration: July 2021 to Current

Role ETL Informatica Developer Project: LPL DW

Description: LPL Financial is a leader in the retail financial advice market and the nation’s largest independent broker/dealer. They serve independent financial advisors and financial institutions, providing them with the technology, research, clearing and compliance services, and practice management programs. LPL Data Warehouse project collects data from various internal and external financial sources and brings data into data mart for overall performance analytics. Tableau Dashboard helped business users identify actionable item and get insight on financial performance.

Responsibilities:

●Involved in all phases of SDLC from requirement gathering, design, development, testing, UAT, deployment to production environment.

●Actively involved in interacting with business users to record user requirements.

●Involved in Analysis, profiling and cleansing of source data and understanding the business process.

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

●Also implemented the change Data Capture (CDC) while integrating the enterprise data sources.

●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 and Oracle database.

●Maintained 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.

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

●Strong on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.

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

●Resolving the tickets based on the priority levels raised by QA team.

●Facilitated in developing test cases and User Acceptance Testing (UAT)

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

●Used CI/CD pipeline to checking code into Bitbucket

●Scheduled batch and sessions within Informatica using Informatica scheduler and also used pre written shell scripts for job scheduling.

Environment: Informatica PowerCenter 10.5, IICS, Oracle 18c, SQL Server 2019, PostgreSQL, Unix, WinSCP, Oracle SQL Developer, Toad, Erwin, AutoSys, BitBucket

Client: Prudential Financial, Newark, NJ Duration: Apr 2019 to Jul 2021

Role ETL Informatica Developer Project: EDW

Prudential Financial, Inc., together with its subsidiaries, provides insurance, investment management, and other financial products and services in the United States and internationally. The objective of this EDW 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:

●Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.

●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 project.

●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 and SQL server database.

●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 etc.

●Worked with various complex mapping, designed slowly changing dimension Type1 and Type2.

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

●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 as per requirement.

●Scheduled batch and sessions within Informatica using Informatica scheduler and also customized pre written shell scripts for job scheduling.

Environment: Informatica PowerCenter 9.6.1, Oracle 12c, MySQL, Unix, WinSCP, Oracle SQL Developer, Control M, JIRA.

Client: Horizon BCBSNJ, Newark, NJ Duration: Jul 2017 to Apr 2019

Role ETL Informatica Developer Project: Claim Data Mart

Horizon Blue Cross Blue Shield of New Jersey provides health insurance coverage; this project integrates from multiple applications into data into enterprise data warehouse. The objective of this project is to integrate Business 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. These BI reports enable management to act quickly based on KPI’s.

Responsibilities:

●Experienced in using Informatica for data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems

●Designed and implemented ETL mappings and processes as per the company standards, using Informatica PowerCenter.

●Extensively worked on complex mappings which involved slowly changing dimensions.

●Developed several complex mappings in Informatica a variety of transformations, Mapping

●Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update strategy, Sequence generator and Joiners.

●Deployed reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the development time.

●Worked on developing Change Data Capture (CDC) mechanism using Informatica

●Power Exchange for some of the interfaces based on the requirements and limitations of the Project.

●Implemented performance and query tuning on all the objects of Informatica using SQL Developer.

●Worked in the ETL Code Migration Process from DEV to QA and to PRODUCTION.

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

●Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing

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

Environment: Informatica PowerCenter 9.1.1, SQL Server 2017, Oracle 12c, Unix, Excel

Contact this candidate