OverviewThe role of an MS SQL Developer with Informatica is crucial in ensuring the efficient design, development, and maintenance of MS SQL databases and Informatica ETL processes. This role plays a pivotal part in the organization's data management and integration efforts, contributing to the overall success of data-driven initiatives.
Key Responsibilities
• Design and develop MS SQL databases
• Create and maintain complex Informatica ETL mappings and workflows
• Optimize SQL queries and stored procedures for performance
• Collaborate with cross-functional teams to gather and interpret business requirements
• Implement data models for applications and reporting purposes
• Ensure data quality and integrity through validation and testing
• Participate in troubleshooting and resolution of database and ETL issues
• Document database and ETL processes and procedures
• Provide technical support and guidance to internal teams
• Stay updated with industry best practices and technologies
Required Qualifications
• Bachelor's degree in Computer Science, Information Technology, or related field
• Proven experience as an MS SQL Developer with expertise in Informatica
• Strong understanding of database design principles and data modeling
• Experience in performance tuning and query optimization
• Knowledge of ETL processes and tools, particularly Informatica PowerCenter
• Ability to work in a fast-paced, dynamic environment
• Excellent problem-solving and analytical skills
• Effective communication and collaboration abilities
• Relevant certifications in MS SQL and Informatica would be advantageous
Location: Los Angeles, CA
Posted: Sept. 16, 2024, 7:27 a.m.
Apply Now Company Website