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