Analytics & BI Spclst 3 or Sr

Design and implement scalable data ingestion and transformation frameworks using one or more of the following: Azure services enabling structured, semi-structured, and unstructured data to be efficiently processed and integrated into enterprise data platforms Informatica Power Center & Informatica Cloud Oracle Data Integrator

Build and maintain robust ETL/ELT pipelines. Integrate data from diverse sources including on-premises systems, cloud storage, APIs, and streaming platforms. Informatica Development and Optimization Design, develop, test, and maintain ETL pipelines using Informatica PowerCenter, including performance tuning, error handling, and integration with Control‑M scheduling. Participate in the migration from PowerCenter to Informatica Cloud (IICS) by redesigning mappings, optimizing transformations, and supporting secure agent configurations. Oracle Data Integrator Design, develop, test, and maintain ETL pipelines using Oracle Data Integrator, including performance tuning, error handling, and integration with Control‑M scheduling. Experience with Fusion AI Data Platform a plus (Fusion Data Intelligence, Fusion Analytics Warehouse). Databricks Development and Optimization Develop and optimize notebooks and workflows in Azure Databricks using PySpark, SQL. Implement Delta Lake for efficient data storage, versioning, and ACID transactions. Leverage Databricks features such as Unity Catalog and job orchestration. Data Modeling and Architecture Design and implement data models (star/snowflake schemas) for analytics and reporting. Collaborate with architects to define data lakehouse architecture and best practices. Hands-on experience implementing and optimizing data solutions using the Medallion Architecture (Bronze, Silver, Gold layers) for scalable and structured data processing Data Quality and Governance Implement data validation, profiling, and cleansing routines. Ensure compliance with data governance policies, including data lineage and metadata management. Performance Tuning and Monitoring Monitor and optimize performance various data processes. Troubleshoot and resolve issues related to data latency, job failures, and resource utilization. Collaboration and Stakeholder Engagement Work closely with data scientists, analysts, and business units to understand data requirements. Translate business needs into technical solutions that are scalable and maintainable. Security and Compliance Implement role-based access control (RBAC), encryption, and secure data handling practices. Ensure compliance with industry regulations (e.g., NERC CIP, GDPR, HIPAA if applicable). Documentation and Best Practices Maintain clear documentation of data flows, architecture, and operational procedures. Promote best practices in code versioning, testing, and CI/CD for data engineering.