Confidential ยท 1 day ago
Data Warehouse Analyst
Confidential is seeking an experienced Data Warehouse Analyst to support a large-scale cloud data integration and modernization initiative for a major state government project. The role involves designing, developing, and supporting enterprise-level data warehouse solutions with a focus on Informatica IDMC and Snowflake.
Marketing & Advertising
Responsibilities
Design, build, and optimize ETL/ELT pipelines using Informatica IDMC
Support cloud data warehousing and integration initiatives
Convert legacy mainframe logic (COBOL, JCL, COOLGEN, FOCUS/WebFOCUS) into modern cloud workflows
Perform data modeling for analytics and reporting
Collaborate with business and technical stakeholders to translate requirements into solutions
Ensure data quality, governance, and performance optimization
Create technical documentation, diagrams, and integration designs
Mentor team members on data warehousing best practices
Qualification
Required
7+ years of experience in Data Warehousing & Data Integration
4+ years hands-on experience with Informatica IDMC / PowerCenter
Strong experience with Snowflake
Expertise in ETL/ELT design and data modeling
Experience with Informatica Data Quality & Data Catalog
Knowledge of Power BI, Tableau, or similar BI tools
Strong SQL and experience with DB2, SQL Server, or Oracle
Bachelor's degree or equivalent experience