What are the responsibilities and job description for the Data Warehouse Analyst – Advanced (Onsite) position at Influx Infosys?
We are seeking a highly experienced Data Warehouse Analyst – Advanced to support data warehousing, reporting, and analytics initiatives in a Snowflake cloud environment. The ideal candidate will be a seasoned professional with a deep understanding of data modeling, ETL/ELT development, Informatica tools, and BI reporting platforms like Power BI and Tableau.
Description
Job Description:
We are seeking a highly experienced Data Warehouse Analyst – Advanced to support data warehousing, reporting, and analytics initiatives in a Snowflake cloud environment. The ideal candidate will be a seasoned professional with a deep understanding of data modeling, ETL/ELT development, Informatica tools, and BI reporting platforms like Power BI and Tableau.
Scope of Services:
You will be responsible for gathering and analyzing business information needs, designing system requirements, and performing advanced analytics in a Snowflake data warehouse environment. This role includes end-to-end data processing, including extraction, transformation, loading, data quality, and visualization.
Primary Duties & Responsibilities:
- Participate in strategic planning and administration of the Snowflake and Informatica infrastructure.
- Analyze transactional data and design optimized data warehouse models.
- Prototype, build, and test ETL/ELT processes using Informatica PowerCenter and Snowflake.
- Design and implement data quality jobs using Informatica Data Quality.
- Maintain comprehensive metadata for the data warehouse environment.
- Develop reports and dashboards in Power BI and Tableau.
- Provide technical consulting, mentor peers, and contribute to documentation and best practices.
Required Experience:
- Minimum of 7 years of IT experience with a strong focus on data management, data warehousing, and BI tools.
- Extensive hands-on experience with Informatica PowerCenter, Snowflake, and data quality tools.
- Proven experience with Power BI and Tableau report/dashboard development.
- Strong understanding of data modeling, ETL processes, and data architecture.
Key Technical Skills:
SkillRequired Expertise, Snowflake Cloud Data Warehouse Advanced, Informatica PowerCenter & CloudExpertInformatica Data QualityProficientPower BIProficientTableau Proficient, DB2, SQL Server, OracleProficientData Modeling & Data Marts Advanced Metadata Management Proficient
Key Soft Skills:
- Initiative: Self-starter with the ability to prioritize and manage multiple tasks.
- Communication: Strong verbal and written communication skills.
- Customer Service: Strong interpersonal and client-facing skills.
- Decision Making & Problem Solving: Demonstrated analytical and evaluative skills.
- Flexibility: Open to new ideas, technologies, and continuous improvement.
- Team Building & Leadership: Ability to inspire, coach, and mentor others.
- Quality Assurance: Knowledge of QA principles and implementation practices.
