Data Management Specialist - Noida, India - Infogain

    Infogain
    Infogain Noida, India

    2 weeks ago

    Default job background
    Description

    Data Management Specialist (Senior) with skills DataOps Engineering, Survey Programming, Data Preparation, Insight Generation for location Noida, India

    Posted on: May 01, Share on Linkedin Share on Twitter Share on Facebook

    ROLES & RESPONSIBILITIES

    Job Description – Informatica ETL Developer

    1 ETL (Informatica & IICS)
    2 PL/SQL
    3 Python (Nice to have)
    4 Unix Experience (Helpful)

    · In-depth knowledge of Software Development Life Cycle (SDLC), having a thorough understanding of various phases such as Requirement gathering, Analysis, Design, Development, and Testing.

    · Extensive ETL experience using Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor).

    · Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like Oracle, SQL Server, MongoDB, PostgreSQL, DB2, Flat files, JSON, XML.

    · Expertise in Developing Mappings and Mapplets/Transformations between Source and Target using Informatica Designer.

  • Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un-connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.
  • Experience in handling initial/full and incremental loads.

    • · Expertise in scheduling workflows Windows scheduler, Unix, and scheduling tools like Apache airflow

    · Good knowledge of database language PL/SQL and writing complex SQL Queries to validate source and target data

    · Experience in creating Tables, Views, Stored Procedures, and Indexes, troubleshooting database issues and Performance Tuning of Stored Procedures and Database queries.

  • Involved in the logical and physical data modeling process to develop corresponding DB objects & ETL flows.
  • Knowledge of handling inbound/outbound secured SFTP file transfer.

    • · Hands-on experience working in LINUX or UNIX Shell scripting

    · Knowledge of Python

    EXPERIENCE

  • 6-8 Years

    • SKILLS

  • Primary Skill: Data Management
  • Sub Skill(s): DataOps Engineering, Survey Programming
  • Additional Skill(s): Data Preparation, Insight Generation

    • ABOUT THE COMPANY

    Infogain is a human-centered digital platform and software engineering company based out of Silicon Valley. We engineer business outcomes for Fortune companies and digital natives in the technology, healthcare, insurance, travel, telecom, and retail & CPG industries using technologies such as cloud, microservices, automation, IoT, and artificial intelligence. We accelerate experience-led transformation in the delivery of digital platforms. Infogain is also a Microsoft (NASDAQ: MSFT) Gold Partner and Azure Expert Managed Services Provider (MSP).

    Infogain, an Apax Funds portfolio company, has offices in California, Washington, Texas, the UK, the UAE, and Singapore, with delivery centers in Seattle, Houston, Austin, Kraków, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.