Data Engineer (SQL Server and SSIS)

Position : Data Engineer (SQL Server and SSIS)
Work Timings : 12:30 PM - 9:30 PM 
Experience - 4 - 8 years

Technical Skills
  • Must have BS in Computer Science/Computer Information Systems
  • Development Experience in Microsoft Azure Cloud environment Azure SQL, Azure Data Factory, Data Lake.
  • Proficient in SSIS packages
  • Strong knowledge of Data Warehouse concepts with experience in data modelling.
  • Maintains a strong knowledge base of new applications, techniques, and skills
  • Strong problem-solving and analytic skills; must be proactive and take initiative
Summary & Responsibilities
  • Relevant experience in application development, maintenance, and support, preferably on Microsoft Azure SQL Data Warehouse
  • Hands-on knowledge of Azure SQL Data Warehouse architecture, and best practices
  • ability to create, maintain and optimize queries, views, and stored procedures. Should be able to analyse and understand complex queries.
  • Strong ETL knowledge, with Hands-on experience on ETL tools, preferably Azure Data Factory.
  • ability to work with large volumes of data from multiple sources; Should be able to design the data flow, extract data from different sources, enrich and present in a format ready to address business needs.
  • Solid experience in performance tuning of queries and applications. Should be able to continuously review the design of applications, recommending changes for better performance.
  • Ability to focus on performance optimization of the landscape and individual applications, by continuously monitoring the system to ensure optimal performance at all times
  • A database developer develops database right from the scratch
  • He collects data, analyzes the collected information, designs algorithms, draws flowcharts and then implements code for the logic developed through algorithms and flowcharts
  • During the code development process of the database a developer has to develop appropriate queries that can help him to retrieve data from the database, look into the security issues of the data and develop structures, procedures and triggers
  • He also has to design Relational Database models and test the developed code with test data to make sure the code is error free
  • If any errors are thrown when the code is running then they should be corrected and once again tested
  • Database developers are also supposed to prepare and maintain report of the entire backend development life cycle
  • Once the development process is completed and all the front end modules are ready, database developers need to work with the front end development team and help in integrating the modules together
  • If the modules are successfully integrated then the integrated code is again tested by the testers and errors if any are sent to the development team for fixing
  • If integration of the modules fails then the database development team has to rework on the modules and fix the problem.
B.E, B.Tech, CDAC, Computer Science, Information Technology, MCA, MCM, MCS
Hinjewadi Phase 1,Pune
Job Status: