Data Integration Developer

Job Tittle: Senior Data Integration Developer

Work experience: Around 5 years.

Shift timing: 1 pm to 10 pm IST / 2 pm to 11 pm IST Skills required: SQL, Python (Pandas etc), SSIS, Good communication

This position is for a Senior Software Engineer who is passionate about solving challenging business problems and has:

•

Overall 5 years of experience as a Data Integration Developer

•

Strong experience in developing ETL pipelines using SQL, T-SQL, stored procedures, and SQL Server, along with performance tuning of queries and stored procedures

•

Experience in troubleshooting and resolving database integrity, performance, deadlock, and connectivity issues

•

Hands-on experience with DataFrames and Pandas in Python, including reading data from Excel, CSV, SQL, and JSON, and writing to SQL and JSON

•

Excellent communication skills

SQL:

•

Strong experience with DDL and DML commands, UNIONs, JOINs, subqueries, execution plans, CTEs, pivot/unpivot, and indexing

•

Strong experience in sorting and filtering data, grouping, and using functions for data processing (aggregation, ranking functions, etc.)

•

Strong experience in creating tables, views, triggers, partitions, complex stored procedures, functions, indexes, and other database objects for data extraction, loading, and transformation

•

Experience performing routine data quality checks and validations to ensure data integrity and consistency

Python:

•

Strong proficiency in Python programming with hands-on experience

•

Extensive experience in JSON data parsing and handling

•

Experience with RESTful APIs and Google Analytics integration, including development and optimization

•

Proficient in secure file transfer protocols (SFTP) for data transfers

•

Experience in web scraping using tools like Beautiful Soup and Scrapy

•

Familiarity with libraries such as NumPy and Pandas for data manipulation and analysis

•

Expertise in debugging and optimizing code for scalability and efficiency

•

Experience with machine learning model development, training, and deployment is an added advantage