What are the responsibilities and job description for the ETL Specialist position at Technology Ventures?
application developers who have a good analytic mindset. candidates who have built/coded applications and understand what they have implemented. The role remains an analyst, but the candidate profile is a developer who understands functionality and can engage with our internal customers. Informatica and oracle SQL skills
• Analyze complex requirements by reading STTMs and apply the knowledge to troubleshoot failures in a production environment
• Propose solutions to resolve the analyzed problem/issue
• Write scripts to correct data (data corrections) and coordinate with the technical team members to ensure the change is delivered to production.
• Verify changes and certify the data after the data correction is implemented
• Articulate technology solutions, in consultations with the systems analyst or Tech lead and requirements to diverse internal/external stakeholders, integrating process, business rules, and data to meet business needs.
• Data-driven, results-oriented with the ability to quickly analyze data and make decisions that drive performance.
• Understanding of Data Lineage, source to target mapping, documenting the data elements accurately is strongly needed.
• Conducting meetings and presentations to share ideas and findings.
• Documenting and communicating the results of data and business requirements
• Effectively communicating your insights and plans to cross-functional team members and management.
• Managing competing resources and priorities.
• Should be able to complete task with minimum supervisio
Informatica / Data Analyst Requirements:
• 8 years of Business/Data Analysis experience
• A bachelor’s degree Is required.
• Must have Advanced SQL, excel skills (SQL on Oracle database preferred)
• Strong knowledge of Data Warehouse / Mart concepts.
• Must have experience using Toad and comparing data from various data sources
• Competency in Microsoft applications including Word, and Outlook.
• Must have experience using JIRA, Confluence