Job Tittle: Data Integration Developer

Exp: 10 +years.

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

4 days working from the office and every Wednesday working from home)

Hyderabad Gachibowli The Opportunity

This position is ideal for a senior software engineer who is passionate about solving challenging business problems and has -

- 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 productive 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.

Required

- Basic SSIS package design and development

Add- on

- Fabric data pipeline design and development knowledge

Best Regards,

Mitra

TechTriad Technology Solutions Pvt Ltd

A-405, The Platina Building

Gachibowli, Hyderabad-500032

Ph: 040-42865851 M: +91 (phone hidden)

Email: [email protected] 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

📌 Looking For Data Integration Developer ( Python + SQL) (Hyderabad)
🏢 TechTriad
📍 Hyderabad