Looking For Data Integration Developer ( Python + SQL)

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

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 7993879862

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