We are seeking a skilled SQL developer/engineer proficient in MS SQL Server, PL/SQL, SSIS, data analysis, and SSRS. The ideal candidate should have experience in implemented master data services in SQL Server. He/she be responsible to develop DTS/SSIS packages to perform ETL operations from various data sources and poses good Transact SQL skills ability to write and tune complicated stored procedures and views utilizing inner and outer joins. This role demands strong analytical skills, a deep understanding of relational databases, and expertise in ETL processes.
Responsibilities:
1. Design, develop, and maintain robust ETL processes using MS SQL Server, PL/SQL, and SSIS.
2. Proven experience as a Data Engineer with hands-on experience in MDM implementations.
3. Extensive experience with SQL Server database environments leveraging databases, tables/views, stored procedures, jobs
4. Designs, develops, and supports solutions utilizing MS SQL Server relational database management system
5. Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.
6. Optimize and tune existing data pipelines for performance and scalability.
7. Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues
8. Perform data analysis to identify trends, patterns, and insights to drive business decisions.
9. Develop and maintain documentation for data processes, workflows, and standards.
10. Ensure data quality and integrity by implementing appropriate validation and testing procedures.
11. Stay updated with the latest advancements in data engineering technologies and best practices.
12. Capable to create Test driven design and implementation in MS SQL Server involves validating database components (unit testing), assessing performance, security, and data integrity (integration, performance, security, data integrity testing)
Primary Requirements:
Proven experience as a Data Engineer or similar role.
5 plus years working with T-SQL/PL-SQL
Exposure to data warehouse models and design
Strong proficiency in MS SQL Server, PL/SQL, and SSIS.
Solid understanding of data modelling, database design, and SQL query optimization.
Experience with data analysis tools and techniques.
Familiarity with data warehousing concepts and methodologies.
Excellent problem-solving and analytical skills.
Strong communication and collaboration skills.
Ability to work independently and in a team environment.
key words highlighted in Bold / Sentence for the SQL Server Developer we require to support CCM on MDM.
Strong understanding of the SQL Server database engine works, including but not limited to: Physical storage, indexing, physical database design best practices, and the Query Optimizer
Create normalized database schemas utilizing data modelling discipline
Normalization, de-normalization, and the difference between the two
Create schemas for both OLTP and OLAP databases
Ability to write Transact-SQL / T-SQL code or PL/SQL
Worked on SQL Server features such as SSMS, SSIS, SSAS, SSRS, XML, Service Broker, Full-Text, etc.