Overview
The 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
Skills: troubleshooting,databases,ms sql,performance tuning,collaboration,communication,data quality,documentation,data modeling,query optimization,informatica,analytical skills,technical support,sql,etl,database design,problem-solving