What are the responsibilities and job description for the Data Warehouse Analyst position at SWITS DIGITAL Private Limited?
Job Title: Data Warehouse Analyst
Job Location: Tallahassee, FL (on-site)
Job Tasks And Activities
Job Location: Tallahassee, FL (on-site)
Job Tasks And Activities
- Strong Data Integration and Data Warehousing experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools.
- Strong Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks
- Participates in strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development.
- Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics.
- Coaches and mentors’ peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
- Prototypes, builds, and tests Power BI and Tableau reports and dashboards.
- Assists with the development and maintenance of methods and practices documentation.
- At least 7 years of IT experience utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions.
- Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake.
- Experience designing data models for Business Intelligence tools like Power BI and Tableau.
- Experience with Informatica on-premises products like PowerCenter and Data Quality.
- Experience with ELT with Change Data Capture solutions like PowerExchange.
- Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.
- Experience with IICS Cloud Administration and Snowflake Data Cloud Administration.
- Ensures data warehouse metadata is collected and maintained.
- Experience with Informatica IICS Cloud Performance Tuning
- Experience with Snowflake Data Cloud Performance Tuning
- Experience with Data Governance products, like EDC, Axon, and CDGC
Salary : $50