Informatica Consultant
InvestM Technology LLC · New York, NY · 2 wk ago
On-siteConsultingContract
Location: New York, NY 10004
Duration: 12 months; extension possible based on needs and performance
Responsibilities
- Design, develop, and maintain ETL processes using Informatica and SQL Server Integration Services (SSIS).
- Perform data modeling and database design following DBMS best practices.
- Optimize and tune SQL queries for performance.
- Develop reports using SQL Server Reporting Services (SSRS) and Power BI.
- Investigate and resolve data-related issues with minimal guidance.
- Document and articulate steps taken to resolve issues for stakeholders and project members.
Requirements
- Mandatory experience with Informatica.
- Experience writing SSIS packages for ETL processes.
- Strong skills in data modeling and database design.
- Proven ability to optimize and tune queries.
- Experience with SSRS and Power BI.
- Ability to work independently and see tasks through to completion.
- Strong issue resolution, investigation, and communication skills.
Preferred Qualifications
- Experience with Microsoft DevOps.
- Conceptual knowledge of CRM systems (e.g., Salesforce, Microsoft Dynamics).
- CRM or SQL certifications.
Skills
- Informatica
- SQL Server Integration Services (SSIS)
- Data modeling and database design
- Query optimization
- SQL Server Reporting Services (SSRS)
- Power BI
- Microsoft DevOps