Jatin Jain Email & Phone Number

Jatin is working as BI ETL Informatica PowerCenter Expert with Nabors Industries, Houston, TX.11+ years of IT experience in Analysis, Design, Development & Implementation of application software in Data Warehousing, Oracle SQL, and ETL Process. Expertise in implementing complex business rules by creating Mappings, Mapplets, Sessions and Workflows using Informatica Power Center. Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into DataWarehouse and Data Marts using Informatica PowerCenter & SSIS tools.Experience in designing/developing complex mappings using transformations like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Sequence Generator, Connected and Unconnected Lookup, Update Strategy, SQL, Stored procedure and Implementing SCD Type 1, SCD Type 2 Excellent conceptual knowledge of Oracle 9i/10g/11g,Data Warehouse Concepts, ETL, Data modeling, and Dimensional Modeling.Strong experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.Fair Experience in working on Mainframes for scheduling of JCL's , solving production job failures and third party vendor file handling.Good understanding of Data modeling concepts ER Diagrams, Use Cases, Normalization and De-normalization of Tables, Excellent analytical, problem solving skills with strong technical background and interpersonal skills.Adequate knowledge with Microsoft Power BI.Beginner with Microsoft Power Automate & Microsoft Fabric.

• 

  Maharishi Markandeshwar Engineering College

  Computer Engineering