ETL Developer

Information Professionals, Inc.; Taguig; Ibrido; PHP 500.000 - 900.000; Tempo pieno

Descrizione del lavoro

Information Professionals, Inc. is seeking a data engineer to design, develop, and optimize ETL pipelines using SSIS and SQL Server. You will handle data extraction, transformation, integration, and validation, and you will troubleshoot complex T-SQL queries.

You will ensure data accuracy and quality through ETL testing and performance optimization, and collaborate with cross-functional teams to translate business needs into technical solutions. Documentation of solutions is expected.

Competenze

• 2+ years of proven experience in data engineering and development.
• Strong proficiency in ETL development and data integration using SSIS and SQL Server.
• Solid track record building, testing, and optimizing data pipelines.

Mansioni

• Design, develop, and optimize ETL pipelines using SSIS and SQL Server.
• Handle data extraction, transformation, integration, and validation with T-SQL queries and stored procedures.
• Ensure data accuracy, quality, and integrity through ETL testing and performance optimization.
• Collaborate with cross-functional teams to translate business requirements into technical solutions and maintain technical documentation.

Conoscenze

ETL development

SSIS

SQL Server

T-SQL

Data pipelines

Data quality

Data testing

Documentation

Strumenti

Microsoft Visual Studio

MS SQL Server

Descrizione del lavoro

• Responsible for designing, developing, and optimizing ETL processes and data pipelines using Microsoft SSIS and SQL Server.




• Handles data extraction, transformation, integration, and validation while developing and troubleshooting complex T-SQL queries and stored procedures.




• Ensures data accuracy, quality, and integrity through data analysis, ETL testing, and performance optimization.




• Collaborates with cross-functional teams to translate business requirements into technical solutions and maintain comprehensive technical documentation.

Primary Skills:

• Minimum of 2+ years of proven experience in data engineering and development.




• Strong technical proficiency in ETL development, data integration, and functional system analysis using Microsoft Visual Studio (SSIS), MS SQL SSIS, MS SQL (TSQL)




• Solid track record of building, testing, and optimizing data pipelines and identifying technical fixes through detailed data analysis.




• MS SQL: Complex querying and stored procedures.