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
Consulting
Design, develop, and optimize ETL workflows using Informatica IICS; build data pipelines, implement data transformations and quality rules, and perform source-to-target validation. Develop automated validation scripts, execute ETL test plans, log defects, support UAT and production verification, and collaborate with stakeholders to ensure data governance and documentation.
Top Skills:
AWSAzureBigQueryCi/CdGCPIics Data Quality (Idq)Informatica Iics (Cloud Data Integration)PythonRedshiftSnowflakeSQL
Agency • Information Technology
Build and maintain ETL pipelines and data warehouses on AWS/Snowflake to power multi-channel marketing reporting and self-service analytics. Develop dashboards (Tableau/PowerBI/Qlik), ensure data quality, manage latency/completeness, and support ad-hoc exports and reporting rationalization.
Top Skills:
Apache KafkaAws (S3Aws Aurora (Postgres)Ci/CdData MartData WarehouseETLJenkinsKinesis)MavenPostgresPower BIQlikSnowflakeSnsSQLSqsStashTableauUdeploy
Agency • Information Technology
Lead ETL design, data modeling, and ETL development for the enterprise data warehouse. Provide technical leadership, translate stakeholder requirements into designs, document specs, develop and test ETL, perform code and design reviews, ensure security and release/change management, and support migration and performance optimization within Agile teams.
Top Skills:
AgileChange ManagementData ModelingDatabricks LakehouseDelta Lake (Delta Tables)Enterprise Data Warehouse (Edw)ETLInformatica IdmcKimball MethodologyOracleOracle Data Integrator (Odi)Release ManagementSource Code ControlSQLSQL Server
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
