Looking For Data Integration Developer ( Python + SQL)

Job Tittle: Data Integration Developer

Exp: 6+ years.

shift timing: 1 pm to 10 pm IST / 2 pm to 11 pm IST

The Opportunity

• Strong experience in developing ETL pipeline using SQL, T-SQL, stored procedures, SQL server, performance tuning of queries and stored procedures.
• Experience in troubleshooting and resolving database integrity issues, performance issues, deadlock issues, connectivity issues, etc.
• Hands-on and basic knowledge of data frames and pandas in Python. Reading data from excel, CSV, SQL, and JSON and writing to SQL and JSON.
• Excellent communication skills and client-facing experience

SQL

• Strong experience in DDL and DML commands, UNIONS, JOINS, Subqueries, execution plan, CTE, Pivot/unpivot and indexes.
• Strong experience in sorting & filtering data, grouping & functions for data processing (Aggregation functions, ranking functions, Rowset Functions).
• Strong experience in creating tables, views, triggers, partitions, complex stored procedures, functions, indexes, and other database objects for data extraction loading and transformations.
• Strong experience in data modeling and schemas, writing procedural T-SQL and stored procedures.
• Experience in generating and analyzing reports from SQL databases.
• Performing routine data quality checks and validations to ensure data integrity and consistency.
• Knowledge of best practices for writing efficient queries with increased performance
• Troubleshooting production tickets and issues that affect query performance.
• Experience in SSIS is good to have.

Python

• Strong Proficiency in Python Programming: hands-on experience.
• JSON Data Parsing: Extensive experience in handling JSON data formats and implementing parsing techniques.
• RESTful API & Google Analytics Integration: Skilled in development, integration, and optimization.
• Secure File Transfer Protocols: Proficient in working with SFTP for secure data transfers.
• Web Scraping: Experience using tools like Beautiful Soup, Scrapy, and Selenium for data extraction.
• Python Libraries: Familiar with libraries like NumPy and Pandas for data manipulation and analysis.
• Performance Optimization: Expertise in debugging and optimizing code for scalability and efficiency.
• Machine Learning Models (Added Advantage): Experience in developing, training, and deploying machine learning models for predictive analytics.
• Microsoft Fabric (Added Advantage): Exposure to data analytics solutions.
• Azure Data Integration (Added Advantage): Experience in pipeline development, data transformation, and cloud resource management.
• Documentation: Skilled in documenting processes, workflows, and development best practices.

Best Regards,

Mitra

TechTriad Technology Solutions Pvt Ltd

A-405, The Platina Building

Gachibowli, Hyderabad-500032

Ph: 040-42865851 M: +91 7993879862

Email: mitra@techtriad.com

www.techtriad.com

Preferred candidate profile

Total exp.

SQL databases

Azure Data Integration

Experience in creating tables, views, triggers, partitions, complex stored procedures, functions,

Experience in data modeling and schemas, writing procedural T-SQL and stored procedures.

Experience in DDL and DML commands, UNIONS, JOINS

Performance Optimization

Python Programming:

JSON Data Parsing

RESTful API & Google Analytics Integration

Secure File Transfer Protocols

Web Scraping

Python Libraries

Perks and benefits