Job Information
Job Description
Description
- Expertise in Data Extraction, Transformation, Loading, Data Analysis, Data Profiling, and SQL Tuning.
- Data Engineer with Expertise in Relational & Dimensional Databases in engines like SQL Server, Postgres, Oracle…
- Assemble large, complex data sets that meet functional / non-functional business requirements. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL Server, PostgreSQL, SSIS, T-SQL, PL/SQL
- Work with stakeholders including the Product, Data, Design, Frontend and Backend teams to assist with data-related technical issues and support their data infrastructure needs
- Write complex SQL, T-SQL, PL/SQL queries, stored procedures, functions, cursors in SQL Server and PostgreSQL. Peer review other team members code
- Analyze the long running queries/functions/procures, design and develop performance optimization strategy.
- Create and manage SSIS packages and/or Informatica to perform day to day ETL activities. Use variety of strategies for complex data transformations using an ETL tool
- Perform DBA activities like maintaining the systems health and performance tuning, manage database access, deployments to higher environments, on-call support, shell scripting and python scripting is a plus
- Participate in employing the Continuous Deliver and Continuous Deployment (CI/CD) tools for optimal productivity. Collaborate with scrum team members during daily standup and actively engage in sprint refinement, planning, review and retrospective
- AWS / Azure cloud technologies, Agile methodologies and DevOps is a big plus
- Experience with developing CICD pipelines in Jenkins or Azure DecOps.
Job alerts
Receive emails for the latest jobs matching your search criteria