Overview
Skills
Job Details
Job Role: MSSQL Developer
Location: Alpharetta, GA
Experience: 15 Years
Skills:
Experience as an SQL Developer responsible for designing, developing, and maintaining databases and database applications using SQL (Structured Query Language). Their primary focus is on ensuring data integrity, security, and optimal performance of database systems.
Proficient in SQL and experience working with relational databases like SQL Server
Strong proficiency with SQL server and its variation among popular databases; Design stable, reliable and effective database
Able to quickly understand an existing landscape of huge databases with large numbers of stored procedures, triggers, jobs and multiple upstream / downstream data flows with different applications.
Skilled at writing, editing large, complicated SQL statements
Create and maintain SSIS packages for data extraction from various sources, transforming data into the required format, and loading it into destination systems like a data warehouse.
Experience in optimizing ETL(SSIS) jobs, tuning database queries, and improving job execution times.
Implement measures to ensure the accuracy, security, and performance of data and ETL workflows.
Exposure to SDLC tools, such as: JIRA, Confluence, SVN, TeamCity, Jenkins, Nolio, and Crucible.
Experience on DevOps, CI/CD, and Agile methodology.
Strong ability to apply data transformation logic, clean data, and ensure data quality in the ETL(SSIS) processes.
Experience with version control systems like Git or SVN for managing Informatica artifacts.
Proficient understanding of code versioning tools such as SVN; merging and creating production scripts
Sqlserver DB coding, DB scheduling tools, File transfer mechanisms, DB Devops
Thanks& Regards,