Lead ETLELT Architecture & Design

NMK Global Inc. is a global IT Services & Solutions company specializing in IT Staffing Technology Consulting Workforce Solutions and Application Development Services. We help organizations build high-performing technology teams by connecting them with exceptional talent across a wide range of industries. Our expertise industry knowledge and consultative approach enable clients to achieve successful business outcomes while helping professionals advance their careers.

Job Title: Lead ETL/ELT Architecture & Design

Location: Cary NC (Local Candidates Only)

Job Type: Contract

Job Description:

• 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).

• 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 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.

• Data Quality & Testing Governance - Establish 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 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 extract/load into different Databases (Oracle SQL Server Snowflake Postgres GBQ Teradata and DB2)

• Experience writing querys using in various RDBMS systems like Oracle (SQL PL/SQL) 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

NMK Global Inc. is an Equal Opportunity Employer. We are committed to creating an inclusive workplace and consider all qualified applicants without regard to age race color religion sex national origin disability protected veteran status sexual orientation gender identity or any other characteristic protected by applicable law.