Uploaded File
add photo
Bhumika
bpatel4325@gmail.com
832-409-2893
Houston, TX 77299
Informatica Developer
6 years experience C2C
0
Recommendations
Average rating
6
Profile views
Summary

  • Over 5+ years of IT experience with expertise in analysis, design, development and implementation of Data warehouses and Decision Support Systems (DSS) using ETL tools Informatica 10.2/9.x with RDBMS like Oracle, MS SQL server, Teradata and MySQL databases on Windows and UNIX platforms.
  • Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, production deployment and production warranty support.
  • Extensive experience of providing IT services in engineering, construction and HealthCare domain.
  • Good understanding of Data Warehousing Concepts like Dimensions Type I and II, Facts, Surrogate keys, ODS, staging area.
  • Good understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.
  • Good experience of writing SQL Queries for Data analysis, Data mapping specification, Data Profiling, Data Migration and creating Data Dictionaries.
  • Expert in writing complex SQL queries and optimizing the queries in Oracle, SQL Server and Teradata.
  • Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets.
  • Experience in tuning and scaling the procedures for better performance by running explain plan.
  • Experience in Performance tuning of ETL process using pushdown optimization and other techniques.
  • Used mapplets, user defined functions, reusable transformations, look-ups in Informatica mapping.
  • Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
  • Skilled in creating Source to target mapping, ETL Specification Documents and capturing requirement.
  • Experience with Informatica tools using real-time CDC (change data capture) and MD5.
  • Good communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

TECHNICAL SKILLS:

  • ETL tools Informatica PowerCenter 10.2/9.6/9.2
  • RDBMS Database Oracle 12c/11g, MS SQL Server 2018, MySQL, Teradata 16
  • Tools Microsoft Visio, Erwin 9.5/8.1, TOAD, Oracle SQL developer, WINSCP, MS Office,
  • Control-M, Rally, JIRA
  • Mythologies SDLC, Agile, Waterfall

Experience
Informatica Developer
Information Technology
Jul 2019 - present

Project Name: Bechtel Data Mart Bechtel is a trusted engineering, construction and project management partner to industry and government. Bechtel serves the Infrastructure Nuclear, Security & Environmental Oil, Gas & Chemicals and Mining & Metals markets. their services span from initial planning and investment, through start-up and operations. This project aims to create a data mart for ETA (Electronic Test Automation) tools to access all their needed data from a single environment and to enhance efficiency, analysis, and the tools' ability to communicate in sync with one another. This enables ETA (Electronic Test Automation) to achieve their goals:

  • Improving customer return cycle time through consistent and quicker analysis
  • Automatically optimizing test limits
  • Implementing strategic Final Test outlier screening to meet automotive customer expectations. 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 & stored procedure transformation.
  • 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 10.2, Tableau 2020.3, Unix, TOAD, Microsoft SQL Server 2018, Teradata 16, Control M, Shell Scripting, SharePoint, Confluence

Data Marts ETL Informatica Informatica Developer Informatica Powercenter MS SharePoint Project Management Shell Scripts SQL SQL Server Stored Procedure Tableau Teradata TOAD UNIX
Remove Skill
Sr. Informatica Developer
Information Technology
Jun 2017 - Jul 2019

Description: Amegy Bank specialize in banking privately owned business of all sizes and public companies in all industries with additional expertise in real estate, energy and correspondent banking. Amegy Bank operates in nearly 500 local financial centers across 11 Western states, it is known as Zions Bancorporation in S&P 500. The objective of this project is to enrich data from new sources into existing IDW i.e., integrated data warehouse to enable improved decision-making, strategic plans, support and solutions that favorably impact costs, quality of care, outcomes, and customer satisfaction through an information-driven environment that leverages their integrated data assets for competitive advantage.

Responsibilities:

  • Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
  • Documented Data Mappings/ Transformations as per the business requirement.
  • Worked on project documentation which included the Technical and ETL Specification documents.
  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
  • Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
  • Involved in extracting the data from the Flat Files and Relational databases into staging area.
  • Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
  • Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
  • Developed the Informatica Mappings by 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.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Prepared Technical Design documents and Test cases.
  • Extensively worked on Unit testing for the Informatica code using SQL Queries.
  • Implemented various Performance Tuning techniques.
  • Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
  • Wrote SQL queries to view and validate the data loaded into the warehouse.
  • Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
  • Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
  • Used PMCMD command to run workflows from command line interface.
  • Improved performance testing in Mapping and the session level.

Environment: Informatica PowerCenter 9.6, SQL Server 2016, MySQL, Shell Scripts, SQL, UNIX, Toad, SQL Developer, tableau, Control M

Informatica Informatica Developer Data Warehousing ETL Informatica Powercenter MySQL Shell Scripts SQL SQL Developer SQL Server Tableau TOAD UNIX
Remove Skill
ETL Developer
Information Technology
Jan 2016 - Jun 2017
Irving, TX

Description: Humana Inc. offers medical and supplemental benefit plans; it operates through Retail, Group and Specialty, and Healthcare Services segments. The company provides commercial fully-insured medical and specialty health insurance benefits comprising dental, vision, and other supplemental health benefits; financial protection products; and administrative services to individuals and employer groups, as well as military services. The project is aimed at developing Visuals dashboard and reports for their huge customer base that will be helpful for long-term decision-making, strategic plans, support and solutions giving stakeholders ability to access, analyze and help stakeholder to automate extract process for down-line application. This data mart sourced data from multiple source system like QNXT, QCARE, LEON etc. into data mart.

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

Environment: Informatica PowerCenter 8.6, Oracle 11g, SQL Server 2012, SQL, Erwin 8.1, UNIX, Control-M

Past experience in non IT area Nov 2008 to Oct 2015

  • AMEC Foster Wheeler: worked as Piping Engineer IV from Dec 2013 to Oct 2015
  • Worley Parsons Limited worked as Offshore Structural Engineer from Nov 2012 to Nov 2013
  • Bechtel Corporation worked as Pipe Stress Engineer/ Civil Engineer from Nov 2008 to July 2012
Data Cleansing Data Marts Data Profiling Erwin Data Modler ETL ETL Developer IDQ Informatica Informatica Powercenter Metadata Oracle SQL SQL Developer SQL Server UNIX
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Engineering
Lamar University 2008
Skills
Data Analysis
2021
1
Windows
2021
1
ETL
2021
5
Informatica
2021
5
Informatica Powercenter
2021
5
SQL
2021
5
SQL Server
2021
5
UNIX
2021
5
Data Marts
2021
3
Informatica Developer
2021
3
Shell Scripts
2021
3
SQL Developer
2019
3
Tableau
2021
3
TOAD
2021
3
Data Warehousing
2019
2
MySQL
2019
2
Data Cleansing
2017
1
Data Profiling
2017
1
Erwin Data Modler
2017
1
ETL Developer
2017
1
IDQ
2017
1
Metadata
2017
1
MS SharePoint
2021
1
Oracle
2017
1
Project Management
2021
1
Stored Procedure
2021
1
Teradata
2021
1
Agile Methodology
0
1