SQL Data Engineer - Main stress is on full stack data engineer i.e. ETL + Cube development on Microsoft Azure tech stack.
Location : Preferably Gurgaon / Hyderabad
7+ years’ development experience on end to end BI development Backend Data Engineering
5+ of SQL Server development experience writing complex stored procedures, triggers, views, etc.
Strong experience on Big Data Technologies especially on Azure Azure Databricks, Azure Datawarehouse / Azure Data Lake / Azure Synapse, Spark, with strong foundation in SQL
Strong understanding of BI areas. Ability to work in large, complex development BI projects
Demonstrated experience in end to end development Cubes, ETL, Data Integration
Cube development experience is mandatory
Knowledge of at least one programming language (e.g. Python, C#) is preferred
Experience on PowerBI is preferred
Strong Analytical and troubleshooting skills
Excellent coding and debugging skills.
Able to work independently to implement a solution with minimal guidance
Ability to communicate with Business and developers accordingly.
Ability to work independently or with minimal supervision.
Sever as a consultant through the lifecycle of the project and facilitate resolution of any issues / open items by getting relevant teams involved.
Strong communication skills in both written and spoken English.
Excellent communication skills and ability to work under continual deadline constraints are necessary, show agility towards meeting business needs
Work on complex BI ecosystems and design / develop solutions based on BI Data technologies based on Azure Communicate design, requirements, feature set, functionality, usability and limitations of subsystem to team and / or development lead or manager.
Participate in Business Requirements and Functional Requirements meetings, identify gaps in requirements and drive discussion around appropriate solutions.
Design and code ETL / Build Data Pipelines and build / modify Cubes Design and code high quality database solutions within a fast-paced sprint release cycle Manage errors gracefully.
Document code and work completed. Conduct thorough unit testing of code and document the unit test cases. Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria.
Provide support as needed throughout Test and User Acceptance Testing phases. Create Technical Design Specification documentation that clearly articulates the design and code being implemented.
Provide client communication as appropriate to project. Be able to translate technical specifications into finished programs and systems and also have a thorough understanding of developing solutions to handle large volume data sets that are typical with BI solutions.
Assist in architectural design reviews and ensure technology stack selection is relevant Ensure development and testing follow industry standards