2 Sql Mi Jobs

At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself and a better working world for all. EY's Consulting Services is a unique, industry-focused business unit that provides a broad range of integrated services leveraging deep industry experience with strong functional and technical capabilities and product knowledge. EY's financial services practice offers integrated Consulting services to financial institutions and other capital markets participants. Within EY's Consulting Practice, the Data and Analytics team solves big, complex issues and capitalizes on opportunities to deliver better working outcomes that help expand and safeguard businesses, now and in the future. This way, we help create a compelling business case for embedding the right analytical practice at the heart of clients" decision-making. **The Opportunity** As a Senior Designer and Developer working with Informatica Intelligent Cloud Services (IICS), you will play a crucial role in designing, developing, and managing complex data integration workflows involving multiple sources such as files and tables. Your responsibilities will span across various data sources to ensure seamless data movement and transformation for analytics and business intelligence purposes. **Key Roles and Responsibilities of an IICS Senior Designer and Developer:** - **Designing and Developing Data Integration Solutions:** - Develop ETL (Extract, Transform, Load) mappings and workflows using Informatica Cloud IICS to integrate data from various sources like files, multiple database tables, cloud storage, and APIs. - Configure synchronization tasks involving multiple database tables to ensure efficient data extraction and loading. - Build reusable mapping templates for different data loads including full, incremental, and CDC loads. - **Handling Multiple Data Sources:** - Work with structured, semi-structured, and unstructured data sources including Oracle, SQL Server, Azure Data Lake, Azure Blob Storage, and more. - Manage file ingestion tasks to load large datasets from on-premises systems to cloud data lakes or warehouses. - Use various cloud connectors and transformations to process and transform data efficiently. - **Data Quality, Governance, and Documentation:** - Implement data quality and governance policies to ensure data accuracy, integrity, and security. - Create detailed documentation such as source-to-target mappings, ETL design specifications, and data migration strategies. - Develop audit frameworks to track data loads and support compliance requirements. - **Project Planning and Coordination:** - Plan and monitor ETL development projects, coordinate with cross-functional teams, and communicate effectively across organizational levels. - Report progress, troubleshoot issues, and coordinate deployments. - **Performance Tuning and Troubleshooting:** - Optimize ETL workflows and mappings for performance. - Troubleshoot issues using IICS frameworks and collaborate with support teams as needed. - **Leadership and Mentoring (Senior Role Specific):** - Oversee design and development efforts, review work of junior developers, and ensure adherence to best practices. - Lead the creation of ETL standards and methodologies to promote consistency across projects. **Summary of Skills and Tools Commonly Used:** - Informatica Intelligent Cloud Services (IICS), Informatica Cloud Data Integration (CDI) - SQL, PL/SQL, API integrations (REST V2), ODBC connections, Flat Files, ADLS, Sales Force Netzero - Cloud platforms: Azure Data Lake, Azure Synapse, Snowflake, AWS Redshift - Data modeling and warehousing concepts - Data quality tools and scripting languages - Project management and documentation tools In essence, a Senior IICS Designer and Developer role requires technical expertise in data integration across multiple sources, project leadership, and ensuring high-quality data pipelines to support enterprise BI and analytics initiatives. **What We Look For:** We are seeking a team of individuals with commercial acumen, technical experience, and enthusiasm to learn new things in a fast-moving environment. Join a market-leading, multi-disciplinary team of professionals and work with leading businesses across various industries. **What Working at EY Offers:** At EY, you will work on inspiring and meaningful projects, receive support, coaching, and feedback from engaging colleagues, and have opportunities for skill development and career progression. You will have the freedom and flexibility to handle your role in a way that suits you best. Join EY in building a better working world, creating long-term value for clients, people, and society, and fostering trust in the capital markets through data-driven solutions and diverse global teams.,

As a dedicated professional at Leighton Asia, you will be responsible for spearheading the development of end-to-end Azure integration solutions in alignment with CIMIC's OneIT Target Reference Architecture. Your key responsibilities will include ensuring compliance with CIMIC's Security Standards, constructing data and integration solutions that adhere to CIMIC's Target Reference Architecture, as well as hands-on development and unit testing of the solutions. You will play a crucial role in following CIMIC's path to production environments, providing technical support during test phases, and conducting handover sessions to transition solutions to BAU Support. Additionally, you will be involved in deploying solutions in PROD through CIMIC's CAB process and offering post go-live hypercare support. Your expertise will be instrumental in preparing technical specification documents, obtaining code review approvals, and ensuring compliance with standards. Your work will focus on the development and maintenance of CIMIC's data and integration solutions while aligning with CIMIC's Target Reference Architecture, strategic roadmap, and emerging technologies. To excel in this role, you should hold a degree in ICT, Engineering, or Science in a relevant discipline and possess at least 2-3 years of experience in a similar capacity. Your qualifications should include data and integration solution design skills, familiarity with Azure projects related to data ingestion, storage, transformation/enrichment, data lake solutions, point-to-point integrations, real-time and batch integrations, and an understanding of security compliance requirements. A solid grasp of Azure standards applicable to data and integration solutions, experience collaborating with on and offshore teams, and a commitment to architectural design and solutions are essential. Moreover, your technical proficiency should encompass two out of the three pillars of technical skills outlined below: Tech Pillar #1 Ingestion: - API Manager, REST APIs, Web API - Azure Logic Apps, Function Apps (C# - no, Python- 5 years) - Azure Data Factory and Integration Runtimes - Azure Storage, Delta Lake - Creation of Azure GitHub Repos, Build and Release Pipelines - Azure Key Vault - Service Principles, Security and Azure AD Groups/Entral ID Tech Pillar #2 Process/Enrichment: - Azure Databricks - Azure SQL and SQL MI (with SQL skills) - Azure Data Factory (including orchestration of Databricks notebooks) - Azure Storage, Delta Lake - Creation of Azure GitHub Repos, Build and Release Pipelines - Azure Key Vault - Service Principles, Security and Azure AD Groups/Entral ID By joining our team, you will play a vital role in delivering innovative solutions that drive the success of our projects while contributing to the growth and development of CIMIC Group.,