Data Management Specialist (Lead)
- Infogain
- 5 - 8 years
- Mumbai
- 5 months ago
- Email to a friend
- Report this job
Job Description
Roles & Responsibilities1 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
8-11 Years
Skills
Primary Skill: Data Management
Sub Skill(s): Data Management
Additional Skill(s): Python, ETL, DataOps Engineering, 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 500 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
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse Architect / ConsultantEmployement Type: Full timeContact Details:
Company: InfogainLocation(s): Mumbai+ View Contact
Keyskills: requirement gathering data management software testing design analysis etl transformation unix
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Infogain
Blue Star Infotech Ltd, now part of Infogain, delivers IT services and digital transformation solutions across industries. The company emphasizes innovation, client value, and excellence through high-impact projects and human-centered design. With a global presence and over 6,000 employees, it foste...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in