real softCary, NC
Information Technology_USA - USA_Developer
Information Technology_USA - USA_Developer
Information Technology_USA - USA_Developer
real softCary, NC
Apply for this role (opens in a new tab)yesterday
Lead Etl/Elt Architecture & DesignDesign and architect enterprise-scale data integration solutions across cloud (Snowflake, GCP, Azure) and on-premises environments (Oracle, SQL Server, Teradata) using Informatica IDMC/IICS and PowerCenter, supporting multiple industry verticals.
Cloud Data Migration StrategySpearhead 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 & AdministrationOversee 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 ManagementManage 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 SolutionsDevelop 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 domains (Retail, Pharma, Banking, Healthcare).
Cloud Saas IntegrationExecute 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 & TuningApply advanced optimization techniques including pushdown optimization, partitioning strategies, and CDC implementations to enhance ETL/ELT performance and reduce processing times for large-scale data operations.
Cross-Platform Database ExpertiseLeverage deep expertise across RDBMS systems (Oracle, SQL Server, Postgres, Teradata, DB2) with advanced SQL/PL/SQL capabilities, DDL design, stored procedures, and indexing strategies to support diverse data requirements.
Automation & Infrastructure as CodeImplement 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 GovernanceEstablish data validation frameworks, develop comprehensive test strategies, and oversee System/Integration Testing to ensure data accuracy, completeness, and business requirement alignment across all ETL/ELT pipelines.
Experience in Informatica (IDMC/IICS, Power Center, Power Exchange), Snowflake, GCP
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, task flows, processes etc.
Also on the board Same function, level within a rung
Level
Manager
Location
Cary, NC
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
yesterday