Cary NC (Day One Onsite)
Skills: Digital : Informatica BDM
• Lead ETL/ELT Architecture & Design – Design 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 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 domains (Retail, Pharma, Banking, Healthcare).
• Performance Optimization & Tuning – Apply 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 Expertise – Leverage 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 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.
Thanks & Regards
Mohammad Faisal
