ETL Developer • March-2022 to January-2025
Description: 1. Data Integration & ETL Development Design, develop, and maintain ETL/ELT workflows using Informatica Intelligent Cloud Services (IICS). Work with Cloud Data Integration (CDI) and Cloud Application Integration (CAI) to integrate various cloud and on-premise systems. Implement data transformation, cleansing, and validation processes. 2. Cloud Data Warehousing Perform data integration with Snowflake, Redshift, or other cloud data warehouses. Optimize performance and storage within cloud environments. 3. API & Cloud Service Integration Develop and maintain REST/SOAP API integrations using IICS Cloud Application Integration (CAI). Handle data ingestion from SaaS applications like Salesforce, Workday, and ServiceNow. 4. Performance Tuning & Troubleshooting Monitor and optimize ETL pipelines for high availability and efficiency. Troubleshoot job failures, performance bottlenecks, and data discrepancies. 5. Data Governance & Security Implement data quality checks, security policies, and audit mechanisms. Ensure compliance with data governance standards and best practices. 6. Automation & CI/CD Automate ETL workflows using scheduling tools (Control-M, AutoSys, or Tidal). Contribute to CI/CD pipelines for ETL code deployment and version control. 7. Collaboration & Documentation Work closely with business analysts, data engineers, and cloud architects. Prepare technical documentation, data flow diagrams, and process workflows. 8. Continuous Learning & Innovation Stay updated with the latest Informatica releases, cloud trends, and ETL best practices. Explore new automation and optimization techniques to improve performance.