ETL Informatica Developer (Fulltime - Plano, TX / Charlotte, NC)

Job Title - ETL Informatica Developer
Experience - 8+ years
Location - Charlotte, NC / Plano, TX
Hire Type - Fulltime (Onsite)

Roles & Responsibilities

• ETL Pipeline Development: Design, build, and deploy robust ETL mappings, sessions, and workflows utilizing informatica PowerCenter and Informatica Cloud.
• Data Integration & Modeling: Develop and optimize complex SQL queries and PL/SQL scripts. Work with relational databases like Oracle, Teradata, or SQL Server to ingest and integrate data.
• Performance Tuning: Troubleshoot and resolve data bottlenecks; tune SQL queries and Informatica mappings for optimal performance and high-volume data ingestion.

• Monitor production environments, respond to alerts, and resolve technical issues, including tracking incidents against SLAs and preventing recurring issues through RCA.
• Debug Informatica, Spark, Oracle and Shell scripting code, analyze logs, and troubleshoot hardware/software issues.
• Maintain, document, and update system operating procedures, and provide performance reports.
• Assist with code deployments and migrations through environment stacks (Dev, SIT, UAT, Prod).
• Proficiency in Unix/Linux commands, SQL for database querying, performance tuning and scripting languages (e.g., Python, Shell) for automation. 
• Experience with monitoring tools (e.g., Splunk, Datadog), ticketing systems (e.g., Jira, ServiceNow), and cloud platforms. 
• Configuring session objects, optimizing Spark engines, and managing file descriptors for high-volume data ingestion.