NEED ETL DEVELOPER || REMOTE || JCI-INFOSYS at Remote, Remote, USA |
Email: [email protected] |
ETL/Informatica Developer Remote VISA - USC AND GC NEED 9-10 YRS TOTAL EXPERIENCE IICS (Informatica Cloud) & Snowflake. The IICS (Informatica Cloud) and Snowflake Business Intelligence ETL Developer is a key, hands-on role that will develop and deliver solutions that enable the collection, transformation and management of information from one or more sources. This role will be integral in migrating the data warehouse to Snowflake and re-platforming the ETL to Informatica Cloud IICS. The ideal Developer for this role is able to handle end-to-end Data Warehouse and Data Integration by taking into consideration the business cases, objectives and requirements. The technical domain of the position includes Snowflake cloud data warehouse and the Data Integration, App & API Integration, Data Replication and Mass Ingestion services of Informatica Intelligent Cloud Services. In addition, the responsibilities will include data integration, data architecture, information delivery, infrastructure, testing, performance tuning for all components of the project. Essential Responsibilities: Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility Debug and tune data integration processes; analyze data warehouse architecture, normalized/denormalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies Design, develop and maintain Snowflake database objects (tables, views, stored procedures, etc.) and SQL scripts. Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications Provide L2 and L3 support of ETL/ELT processes to ensure timely completion and availability of data in data warehouses for reporting use. Analyzes and resolves problems and provides technical assistance as is necessary. Implements corrective actions May prepare or review product documentation, written instructions or technical literature for accuracy and completeness Data Quality management Maintenance of business rules associated with data integration Participate in the fulfillment of ad-hoc data requests from internal business owners Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand and comply with Project Life Cycle Methodology in all planning steps Kind Regards, Krish Agrani| Absolute IT | IT Recruiter. 116 Village Blvd Suite 200 Princeton New Jersey 08540 Absolute IT -- Keywords: active directory information technology green card NEED ETL DEVELOPER || REMOTE || JCI-INFOSYS [email protected] |
[email protected] View all |
Thu Jun 06 19:15:00 UTC 2024 |