The ETL Developer is responsible for creating ETL packages, managing SQL databases, performance tuning, and automating data processes while ensuring data integrity and quality.
This is a remote position.
Responsibilities:
- Analyze, solve, and correct issues in real time.
- Provide suggestions for solutions.
- Create ETL packages. (Mandatory on SSIS, Knowledge of other ETL is good to have).
- Experience with complicated SSIS Package coding and maintenance.
- Participate in ongoing DW/BI performance tuning activities.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with query tuning and schema refinement.
- Provide support for critical production systems as required.
- Maintaining code versioning and support code deployments.
- Perform scheduled maintenance and support deployment activities as required.
- Manage SQL Databases but not limited and can extend to NoSQL/Cloud Database as applicable.
- Preserve data integrity.
- Maintains contemporary knowledge of industry trends, concepts, and techniques.
- Experience in creation of SQL Tables, Views, MV’s, Stored Procedures and working on complex T- SQL statements.
Requirements
Skills & Certifications:
- Expert knowledge in traditional relational database concepts and design.
- Fluent in SQL
- Database design and query optimization.
- Write and debug stored procedures and ability in advanced SQL operations.
- Advanced query, join operation, and aggregate.
- Knowledge of data warehousing.
- Automate manual data tasks through workflows and ETL packages.
- Should possess skill to maintain, monitor, troubleshoot daily jobs using SQL Server Agent.
- Administrate application and server environments.
- Analyze data quality and make recommendations for data preparation.
- Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents).
- Experience with data manipulation, data engineering, and working with large data sets.
Similar Jobs
Artificial Intelligence • Big Data • Information Technology • Consulting
The role requires developing ETL processes, integrating data sources, and writing complex SQL queries. Additionally, experience with data warehousing concepts and Big Data technologies is needed.
Top Skills:
Big DataDatastageElk StackETLInformaticaPentahoPl/SqlSQLSsisT-SqlTalend
Consulting
Responsible for designing, developing, and deploying ETL workflows, optimizing performance, implementing data quality checks, and collaborating with stakeholders. Mentors junior staff and ensures adherence to data governance standards.
Top Skills:
AWSAzureBigQueryGCPInformatica IicsPythonRedshiftSnowflakeSQL
Information Technology • Software
The ETL Developer will be responsible for developing and maintaining ETL processes, ensuring data integrity and quality, and supporting data integration across systems.
Top Skills:
AWSAzureAzure Data FactoryETLInformaticaSnowflakeSsisTalend
What you need to know about the Delhi Tech Scene
Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.
