Job Summary
Seeking a Senior Specialist with 7 to 11 years of experience in Informatica PowerCenter ANSISQL and Dimensional Data Modeling to drive data integration and management initiatives within the IDMC skill cluster
Job Description
Design develop and maintain ETL processes using Informatica PowerCenter to support enterprise data warehousing and analytics Utilize ANSISQL to write complex queries and optimize database interactions for performance and scalability Apply dimensional data modeling techniques to create productive and scalable data models that support business intelligence solutions Collaborate with crossfunctional teams to understand data requirements and translate them into technical solutions Ensure data quality consistency and governance in all data integration workflows Stay updated with the latest trends and best practices in data management and the Informatica Intelligent Data Management Cloud IDMC ecosystem
Roles and Responsibilities
Lead the design and implementation of data integration solutions leveraging Informatica PowerCenter within the IDMC framework Develop and optimize ANSISQL scripts for data extraction transformation and loading processes Architect and maintain dimensional data models to support reporting and analytical needs Mentor junior team members and provide technical guidance on best practices in data management Collaborate with stakeholders to gather requirements and ensure alignment with business objectives Monitor and troubleshoot ETL workflows to ensure high availability and performance Participate in code reviews testing and deployment activities to maintain solution quality
Skills
Mandatory Skills : AWS AI Services, AWS API Gateway, AWS DMS, AWS Glue, Snowflake
Recruiters
- Vishal Golla
[email protected]
- Santoshi Siddireddy
[email protected]
- Ashwini Pawar
[email protected]
📌 Data Engineer (Bengaluru)
🏢 U-set Consulting
📍 Bengaluru