Tata Consultancy Services
ETL Developer, Data Pipeline Architect
Must Have Technical/Functional Skills ETL Skills •Develop and maintain complex ETL workflows, transformations, and mappings to meet business requirements. •Optimize and tune ETL processes for performance, efficiency, and scalability, handling large volumes of data. •Collaborate with data architects and business analysts to implement logical and physical data models for data warehouses and data marts. Understand and contribute to the overall data warehousing strategy. •Monitor ETL jobs for failures, performance bottlenecks, and data anomalies, responding to alerts and resolving issues promptly. Conduct root cause analysis for data-related issues and implement corrective actions. Strong SQL Skills: •Expert-level proficiency in writing complex SQL queries, stored procedures, and performance tuning. Experience with relational databases like SQL Server, Oracle, DB2, PostgreSQL, MySQL. Scripting Languages: •Proficiency in scripting languages such as Python or Shell Scripting, Problem-Solving Skills: Excellent analytical, problem-solving, and debugging skills Communication and Collaboration: •Strong verbal and written communication skills with the ability to effectively collaborate with technical and non-technical stakeholders.
Roles & Responsibilities Design, develop, and implement robust and scalable ETL processes to extract, transform, and load data from various source systems (databases, APIs, flat files, cloud applications) into data warehouses, data marts, and data lakes.
Salary Range- $125,000-$135,000 a year
#LI-CO1 #LI-SN1
Must Have Technical/Functional Skills ETL Skills •Develop and maintain complex ETL workflows, transformations, and mappings to meet business requirements. •Optimize and tune ETL processes for performance, efficiency, and scalability, handling large volumes of data. •Collaborate with data architects and business analysts to implement logical and physical data models for data warehouses and data marts. Understand and contribute to the overall data warehousing strategy. •Monitor ETL jobs for failures, performance bottlenecks, and data anomalies, responding to alerts and resolving issues promptly. Conduct root cause analysis for data-related issues and implement corrective actions. Strong SQL Skills: •Expert-level proficiency in writing complex SQL queries, stored procedures, and performance tuning. Experience with relational databases like SQL Server, Oracle, DB2, PostgreSQL, MySQL. Scripting Languages: •Proficiency in scripting languages such as Python or Shell Scripting, Problem-Solving Skills: Excellent analytical, problem-solving, and debugging skills Communication and Collaboration: •Strong verbal and written communication skills with the ability to effectively collaborate with technical and non-technical stakeholders.
Roles & Responsibilities Design, develop, and implement robust and scalable ETL processes to extract, transform, and load data from various source systems (databases, APIs, flat files, cloud applications) into data warehouses, data marts, and data lakes.
Salary Range- $125,000-$135,000 a year
#LI-CO1 #LI-SN1