Umesh Kumar

ETL Oracle Informatica Azure Cloud Synapse Hyperscale Lead
  • January 12, 2021
  • Umesh Kumar
    502-876-5846
    E-mail: er.umeshgupta22@yahoo.in
    Current Location: Louisville, KY
    Availability: 2 Weeks
    PROFESSIONAL SUMMARY:
    10+ years of IT Experience in Software Analysis, Design, Development, Testing and
    Implementation of Client/Server Business systems like Business Intelligence and Data
    warehousing.
    ● Translate requirements into various documentation deliverables such as functional
    specifications, workflow /process diagrams, and data flow/data model diagrams.
    ● Experience in Informatica Client tools: Power Center Designer, Workflow Manager,
    Workflow Monitor, and Repository Manager.
    ● Experience in all phases of Software Development Life Cycle (SDLC) such as
    development, testing, migration, administration, and production support on various
    platforms like UNIX, Windows 10.
    ● Experience in gathering, analysis and documenting business requirements,
    functional requirements. Designing and developing the mapping based on the
    requirements.
    ● Experience in implementing the Business rules by creating transformations (Expression,
    Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter,
    Joiner, Union), and developing Mappings.
    ● Strong knowledge on Data warehousing concepts, Data mart, Star Schema and Snow
    Flake Schema modelling, Fact tables and Dimensional tables.
    ● Implemented Slowly Changing Dimension methodology for accessing the full history of
    accounts and transaction information.
    ● Experience in the concepts of building Fact Tables, Dimensional Tables, handling
    Slowly Changing Dimensions and Surrogate Keys.
    ● Experience in Migration of objects between environments, from Local (DEV) to Test
    (QA).
    ● Experience in writing complex SQL queries and Unix Shell Scripting.
    ● Excellent experience in Performance tuning in SQL and query optimization.
    ● Strong knowledge on Relational databases like Oracle 9i/10g/11g/12c/19c, SQL Server,
    Azure Synapse, Azure Hyperscale on different platforms like Windows/Unix Linux
    using GUI tools like TOAD, PL/SQL,SSMS Developer.
    ●Analytical and Technical aptitude with the ability to solve complex problems.
    ● Strong interpersonal skills with ability to interact with end-users, managers and technical
    personnel.
    ● Well versed in Agile and Waterfall Methodologies.
    ● Experienced and well versed in writing UNIX Shell scripts as part of file manipulation,
    scheduling and text processing.
    ● Worked as Data Modeler for database creation for data migration.
    Involved in Unit Testing, Integration testing and QA Validation.
  • ● Experience in designing and developing database applications and data support systems
    (ETL/ELT) for Data Warehouse / Data Mart databases, Data Staging, Operational
    Data Stores and Data summarization for Decision Support Systems
    (OLAP/BI/Analytics) of various data volumes employing data models, requirement
    specifications, functional specifications, business rules, validation rules, system statistics,
    etc.
    ● Experience in design and development of various Data Integration, Data Migration and
    ETL applications in different types of SDLC processes employing Data mappings,
    UNIX shell scripting / Windows scripting, Database programming such as UDF,
    stored procedures, functions, SQL scripting.
    ● Experience in various data profiling methods to perform analysis of structured, semi-
    structured and unstructured data sources and data consumables.
    ● Experience in application metadata gathering and metadata analysis of system
    configuration, application complexity, runtime statistics, etc.
    ● Experience using Informatica Power Center / Power Exchange / Analyzer /
    Developer, Oracle Warehouse Builder, External Loaders such as Oracle
    SQL*Loader, PERL, etc.
    ● Experience in Data Masking, Data Subset for non-production data environments with
    Informatica Power Center.
    ● Experience in Informatica Power Center Load balancer and HA clustered systems.
    Involved in process recovery and dynamic partitioning solutions in multi-node
    Environment.
    ● Thorough understanding of mapping / transformation rules, use cases, data models /
    dictionaries and other artifacts constituting database and backend application systems
    design and development.
    ● Conduct Gap analysis on existing processes and potential alternatives. Identify and
    report on trends and patterns found within the data.
    ● Used logical data models, physical designs, and business rules to create mapping
    definitions.
    ●Analyze complex business requirements and design, build, and implement technology
    enabled solutions to address multi-discipline business opportunities/requirements.
    ● Investigate, analyze and address complex technical problems within the ETL processes.
    EDUCATIONAL QUALIFICATION:
    ● B-Tech from Kurukshetra University, Haryana in Computer Science & Engineering
    (Batch 2009).
    WORK EXPERIENCE SUMMARY:
    Humana Inc., Louisville, KY (Tata Consultancy Services) April 2019– Till Date
    HERO (Humana Encounter Resolution and Operation)
    Azure Synapse, Hyperscale, Oracle SQL, Informatica Tech Lead /Architect
E-mail
er.umeshgupta22@yahoo.in
Phone Number
5028765846
Country
United States of America
Degree
Bachelor's Degree
Category
Others

Contact Candidate

Contact