Syntricate Technologies
SQL DBA
Syntricate Technologies, Windsor Locks, Connecticut, us, 06096
Job Description: 8+ Year experience
Builds scalable and reliable ETL/ELT systems to pull large and complex data together efficiently.Develop ETL/Data Integration/Data Processing Flows.Provides subject matter expertise and collaborates with other Engineers to build optimal and efficient ETL/ELT and Database code.Supports ETL Batch processing.Data integration patterns/technologies.Development experience using SQL Server and SSIS.SSRS experience.Oracle as a database platform and PL/SQL.Full Software Development Life Cycle (SDLC) experience.Experience with TFS or JIRA or any other requirements management tool.Experience with CI/CD practices and using software version control tools (e.g., GIT).Facilitate the process of onboarding a new third party interface, debugging the data.Learn and maintain the existing ETL interface.Proficiency in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as MSSQL, Oracle, DB2, Sybase and MS Access.Skilled in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).Skilled in Creating and Deploying SSRS Reports on the portal for user accessibility.Good communication, organization and time-management skills.Positive attitude and ability to function in a collaborative team environment.Perseverance and self-discipline. Ability to see things through to the end.Working understanding of SQL databases and Transact query language.Working understanding of the Software Development Life Cycle (SDLC) involving Systems Analysis,Quick learner, driven to ask questions and to learn holistic understanding of processes, systems and the business.
Builds scalable and reliable ETL/ELT systems to pull large and complex data together efficiently.Develop ETL/Data Integration/Data Processing Flows.Provides subject matter expertise and collaborates with other Engineers to build optimal and efficient ETL/ELT and Database code.Supports ETL Batch processing.Data integration patterns/technologies.Development experience using SQL Server and SSIS.SSRS experience.Oracle as a database platform and PL/SQL.Full Software Development Life Cycle (SDLC) experience.Experience with TFS or JIRA or any other requirements management tool.Experience with CI/CD practices and using software version control tools (e.g., GIT).Facilitate the process of onboarding a new third party interface, debugging the data.Learn and maintain the existing ETL interface.Proficiency in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as MSSQL, Oracle, DB2, Sybase and MS Access.Skilled in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).Skilled in Creating and Deploying SSRS Reports on the portal for user accessibility.Good communication, organization and time-management skills.Positive attitude and ability to function in a collaborative team environment.Perseverance and self-discipline. Ability to see things through to the end.Working understanding of SQL databases and Transact query language.Working understanding of the Software Development Life Cycle (SDLC) involving Systems Analysis,Quick learner, driven to ask questions and to learn holistic understanding of processes, systems and the business.