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.
S
Syntricate Technologies Inc