Job Description

Posted on: August 17, 2024ROLES & RESPONSIBILITIES - Informatica ETL Developer1 ETL (Informatica & IICS)
2 PL/SQL
3 Python (Nice to have)
4 Unix Experience (Helpful)\xc2\xb7 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.\xc2\xb7 Extensive ETL experience using Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor).\xc2\xb7 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.\xc2\xb7 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.\xc2\xb7 Expertise in scheduling workflows Windows scheduler, Unix, and scheduling tools like Apache airflow\xc2\xb7 Good knowledge of database language PL/SQL and writing complex SQL Queries to validate source and target data\xc2\xb7 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.\xc2\xb7 Hands-on experience working in LINUX or UNIX Shell scripting\xc2\xb7 Knowledge of PythonEXPERIENCE

• 8-11 Years

SKILLS

• Primary Skill: Data Management
• Sub Skill(s): Data Management
• Additional Skill(s): Python, Oracle PL/SQL Development, ETL, DataOps Engineering, Data Preparation, Insight Generation, Unix

ABOUT THE COMPANYInfogain 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\xc3\xb3w, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.

Infogain