05 Aug
|
iSageBrum Technologies
|
India
05 Aug
iSageBrum Technologies
India
3+ years of experience | Location: Ahmedabad
No salary bar for the right candidate
2 Positions open
Timing: 3:30 PM to 1:00 AM
5 days a week
We are seeking a Data Engineer to join our team and work on developing and maintaining our Python-based applications. As a Data Engineer, you will be responsible for designing, developing, and testing code for new features, as well as fixing bugs and maintaining our existing codebase.
Key Responsibilities
- Collaborates with source application team and Data Champions to build and maintain the ETL/ELT for various type of source system across the organization and utilize applicable tools (e.g., SSIS, APIs, etc.) to qualify, extract, standardize/normalize, optimize and import data from source to target data mart.
- Demonstrated experience working with Microsoft SQL Server Integration Services (SSIS) to create and deploy packages.
- Extensive SQL coding experience with performance optimization experience for data queries.
- Demonstrated experience around writing and troubleshooting complex T-SQL statements, creating stored procedures, views, and SQL functions.
- Participates in data analysis projects and continuous improvement programs, as necessary, to support relevant Internal projects.
- Demonstrated experience with data visualization and reporting tool like Power BI/ SQL Server Integration Services (SSRS) for creating and publishing reports.
- Write high-quality, clean, and maintainable code.
- Collaborate with cross-functional teams to define, design, and ship new features.
- Identify and fix bugs in existing code.
- Optimize and improve the performance of our applications.
- Excellent written and oral communication skills.
Requirements
- 3 to 5 years of experience in ETL/ELT Tools, SQL, SSIS, Python, and PowerBI.
- Solid Python development skills is important. Knowledge and experience in Python for data manipulation or back-end API or framework development.
- Experience with SSIS and Business Objects Data Services; data governance, master data management, data cleansing, Slowly Changing Dimensions, Change Data Capture and support data pipeline automation.
- Developing ETL pipelines in and out of data warehouse using combination of Python and SSIS Writing SQL queries against database.
- Having valuable experience in a Production support role managing ETL projects independently and deployment activities would be a plus.
Tools and Activities Experience
- Data Integration and Management Tools – SQL Server Integration Services (SSIS), ,APIs, Python, SQL Server
- Database – SQL Server, MySQL, DB2
- Good Analytical and SQL Query Writing Skills
- Data Visualization Tools - Microsoft Power BI and SSRS
- Cloud: Azure (would be plus)
Skill Sets – Python , SQL Server, and PowerBI, (Azure will be plus)
2 Positions open
Location: Ahmedabad
Time: 3:30 PM to 1:00 AM
5 days a week
📌 Data Engineer (India)
🏢 iSageBrum Technologies
📍 India