Technical Lead (ETL- Informatica)

Job description

Share your resume over **Aarushi.Shukla@Coforge.Com** **Job Description-** - Mandatory Skills- Informatica PC, Unix, SQL, Control M, Azure Cloud Basics, Production Support - Databases - MS SQL, Oracle, Snowflake - Good to have skills - DBT, VS GitHub, Power shell Scripting, AWS, BI Reporting, ServiceNow/Ivanti **Key Responsibilities:-** **Production Support & Maintenance:** Provide L2/L3 production support for ETL and data integration applications.Monitor, troubleshoot, and resolve production incidents within defined SLAs.Perform root cause analysis and implement permanent fixes for recurring issues.Support code deployments and release activities across multiple environments. **ETL Development & Data Integration**Develop, maintain, and enhance ETL workflows using Informatica PowerCenter.Translate business requirements into technical designs and ETL specifications.Perform data profiling, cleansing, validation, and transformation activities.Support batch and near real-time data integration processes. **Database & Performance Optimization**Analyze and optimize SQL, PL/SQL, and Snowflake queries.Troubleshoot data load failures, performance bottlenecks, and data quality issues.Ensure data accuracy, consistency, and integrity across systems. **Cloud & Infrastructure:**Work with cloud platforms (AWS or Azure) and services like Synapse, Data Pipelines, and Data Flows. Implement and maintain Data Governance and Data Quality frameworks.Analyze ETL PC flows, provide temporary fix, and analyze Snow SQL Queries.Troubleshoot production issues and provide post-deployment support.Project & Stakeholder Management: Collaborate with cross-functional teams including PMs, analysts, and business stakeholders.