ETL Informatica Architect Remote Location
Posted Today by Sierra Business Solution LLC
Negotiable
Undetermined
Remote
Remote
Summary: The ETL Informatica Architect will lead the design and architecture of enterprise-scale data integration solutions across various cloud and on-premises environments. This role involves overseeing complex data migration strategies, managing Informatica platform governance, and ensuring data quality and performance optimization. The architect will also execute integration projects and establish best practices for data management across multiple industry verticals. The position is fully remote, focusing on delivering robust data solutions and governance frameworks.
Key Responsibilities:
- Design and architect enterprise-scale data integration solutions across cloud and on-premises environments.
- Spearhead complex data migration initiatives ensuring data integrity and performance optimization.
- Oversee Informatica infrastructure including installation, upgrades, and repository management.
- Manage critical production incidents and coordinate cross-functional stakeholder engagement.
- Develop and optimize data warehouse solutions supporting real-time and batch processing.
- Execute integration projects connecting enterprise SaaS platforms with data warehouses.
- Apply advanced optimization techniques to enhance ETL performance and reduce processing times.
- Leverage expertise across RDBMS systems to support diverse data requirements.
- Implement infrastructure automation using shell scripting and scheduling tools.
- Establish data validation frameworks and oversee System Integration Testing.
Key Skills:
- Experience in Informatica (IDMCIICS, Power Center, Power Exchange).
- Experience in data engineering methods like data integration, warehousing, and migration.
- Experience in creating Informatica cloud IICS services objects.
- Experience in migrating data from Oracle and MS SQL Server to cloud databases.
- Experience in creating data flows for various databases.
- Experience writing queries in various RDBMS systems.
- Experience with DOS PowerShell scripting and UNIX Shell scripting.
- Required experience in extracting data from GCS, AWS, Azure blob files.
- Strong experience in developing test plans and scripts for data validation.
Salary (Rate): £52.80 hourly
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Job Description:
Lead ETLELT Architecture & Design - Design and architect enterprise-scale data integration solutions across cloud (Snowflake, Google Cloud Platform, Azure) and on-premises environments (Oracle, SQL Server, Teradata) using Informatica IDMCIICS and PowerCenter, supporting multiple industry verticals.
Cloud Data Migration Strategy - Spearhead complex data migration initiatives from on-premises databases to cloud platforms (Snowflake, BigQuery), ensuring data integrity, performance optimization, and minimal business disruption while achieving cost efficiency.
Informatica Platform Governance & Administration - Oversee Informatica infrastructure including installation, upgrades, server migrations, secure agent deployment, and repository management establish standards and best practices for enterprise-wide adoption.
Production Support & Incident Management - Manage critical production incidents and escalations through structured management processes (ServiceNow) coordinate cross-functional stakeholder engagement to resolve issues and implement permanent solutions with minimal downtime.
Data Warehouse & Integration Solutions - Develop and optimize data warehouse solutions implementing advanced techniques (Slowly Changing Dimensions, Change Data Capture, partition strategies) supporting real-time and batch processing requirements across diverse business domainas (Retail, Pharma, Banking, Healthcare).
Cloud SaaS Integration - Execute integration projects connecting enterprise SaaS platforms (Salesforce, Veeva CRM) with data warehouses and analytical systems, enabling seamless data flow and business intelligence capabilities.
Performance Optimization & Tuning - Apply advanced optimization techniques including pushdown optimization, partitioning strategies, and CDC implementations to enhance ETLELT performance and reduce processing times for large-scale data operations.
Cross-Platform Database Expertise - Leverage deep expertise across RDBMS systems (Oracle, SQL Server, Postgres, Teradata, DB2) with advanced SQLPLSQL capabilities, DDL design, stored procedures, and indexing strategies to support diverse data requirements.
Automation & Infrastructure as Code - Implement infrastructure automation using shell scripting and scheduling tools (Control-M, Autosys, UC4, Cron) to ensure reliable job execution, monitoring, and operational excellence across distributed systems.
Data Quality & Testing Governance - Establish data validation frameworks, develop comprehensive test strategies, and oversee SystemIntegration Testing to ensure data accuracy, completeness, and business requirement alignment across all ETLELT pipelines.
Experience in Informatica (IDMCIICS, Power Center, Power Exchange), Snowflake, Google Cloud Platform
Experience in Various Data Engineering methods like Data Integration, Data Warehousing, Data Migration, application integration and Business Intelligence
Experience on creation of Informatica cloud IICS services CDI, CDQ and CAI Services objects like Mappings, tasks, tasks flows, processes etc.
Experience for Migration of data from Oracle, MS SQL Server to Cloud databases Snowflake, GBQ
Experience in creating Data flows to extractload into different Databases (Oracle, SQL Server, Snowflake, Postgres, GBQ, Teradata, and DB2)
Experience writing querys using in various RDBMS systems like Oracle (SQL, PLSQL), Teradata, MS SQL Server, Postgres, including DDL creation, views, complex SQL constructs, stored procedures, indexing, Partitioning techniques
Experience with DOS power shell scripting and UNIX Shell scripting
Required experience on extracting data from GCS, AWS, Azure blob files into Data warehouse
Strong experience in developing the Test plan, test scripts to perform data validation and Involved in System and Integration Testing