What are the responsibilities and job description for the Informatica Technical Data Analyst position at VALUECONNECT CONSULTING CORPORATION?
Advanced SQL Query Writer
We are seeking an expert in writing advanced SQL queries to join our team at ValueConnect Consulting Corporation. As a key member of our organization, you will be responsible for extracting valuable insights from large datasets using your exceptional analytical skills.
About the Role
- Data Analysis: You will utilize your knowledge of data analysis to identify trends and patterns within complex datasets.
- Snowflake: Experience with Snowflake is required, as we utilize this platform for storing and analyzing our data.
- MDM Expertise: As an MDM expert, you will leverage tools like Collibra and Informatica to ensure data consistency across our systems.
- ETL Tools: Proficiency in ETL tools such as dbt, ADF, and Talend is necessary for designing and implementing efficient data pipelines.
- Communication Skills: Effective communication is crucial, as you will need to convey complex technical information to both technical and non-technical stakeholders.
- Leadership: Leadership skills or self-directed work style are essential for success in this role, particularly for less experienced individuals.
- Financial Industry Expertise: Knowledge of the financial industry and its regulatory requirements is necessary for working with sensitive financial data.
Description
The ideal candidate will have extensive experience in writing advanced SQL queries, data analysis, and working with various databases and data platforms. Strong communication and leadership skills, combined with a passion for data-driven decision making, make you an excellent fit for this role.
Responsibilities
- Analyze complex datasets to extract meaningful insights
- Design and implement efficient data pipelines using ETL tools
- Develop and maintain advanced SQL queries to meet business needs
- Collaborate with cross-functional teams to ensure data consistency and accuracy
- Communicate technical findings to both technical and non-technical stakeholders
Requirements
- 5 years of experience in writing advanced SQL queries and data analysis
- Expertise in Snowflake and MDM tools like Collibra and Informatica
- Proficiency in ETL tools such as dbt, ADF, and Talend
- Strong communication and leadership skills
- Knowledge of the financial industry and its regulatory requirements
