Position: Lead BI Engineer
Location: Hyderabad, Telangana, India
Optimize Your LinkedIn Profile
Link- https://wa.me/p/6003143909798263/918830328039
Job Description
Qualification and Skills
- 10+ years’ experience in RDBMS design, development, and performance tuning
- 5+ years’ working experience as a team lead.
- 5+ years’ experience implementing ETL for Data Warehouse and Business Intelligence solutions.
- 3+ years’ experience with ETL/ELT in the AWS environment.
- 3+ years’ experience using Tableau and/or SSRS and/or similar tools.
- 1+ years’ experience with Snowflake
- Familiarity with providing data for different query engines such as visualization tools like Tableau and Portals.
- Deep familiarity with the Scrum process
- Deep familiarity with MS SQL Server 2014 to 2019 database technologies and ETL best practices with MS SQL Server environment.
- Experience using Business Intelligence Development Studio to build SSIS packages.
- Excellent troubleshooting & optimization skills: interpreting ETL logs, performing data validation, dissecting SSIS code, understanding the benefits and drawbacks of parallelism, experience with change data capture, using expressions, scoping of variables, commonly used transforms, event handlers, and logging providers, ability to understand and optimize the surrogate key generation, and inconsistent data type handling.
- Experience in performance tuning of the SSIS packages, deploying and administering SSIS packages, proficient in utilizing scripting in SSIS, and replacing ActiveX script tasks in DTS with the script task in SSIS.
- Experience with NoSQL databases such as Mongo DB
Optimize Your Naukri Profile
Link- https://wa.me/p/6105392242909026/918830328039
Responsibilities
- Works on highly complex and cross-functional BI solutions.
- Works with product owners to understand customer needs and help in translating business requirements to technical stories.
- Participates in work stream planning process including inception, technical design, development, testing, and delivery of BI solutions.
- Participates in project management estimation process.
- May participates in the development of business cases to support IT projects.
- Explores the data and discovers patterns, meaningful relationships, anomalies, and trends.
- Performs programming analyses for a wide range of requests using data in different formats and from various platforms.
- Ensures documentation is created and maintained.
- Interfaces with Architects to recommend new technology opportunities that will have an impact on BI systems.
- Ability to create ETL specifications, unit, and system integration test cases.
- Build reusable components for a scalable ETL methodology such as error handling, logging, and recoverability.
- Ability to read and write effective, modular, dynamic (parameterized), and robust code. Establish and/or follow already established code standards, and ETL framework.
- Ability to capture and research SSIS issues and bugs, build sample test jobs that recreate a bug, and troubleshoot the ETL until successful issue resolution.
- Ability to create dashboards using Tableau and/or SSRS and/or similar tools.
- Ability to choose and implement the right API for integration with the web portal.
- Responsible for unit, string, and system testing and assisting in the development of UAT test plans.
Software Testing Jobs
- Hiring Functional Testing Professionals – Multiple Locations!
- Fractal Hiring Data Test Engineers – Multiple Locations!
- We’re Hiring: NeoLoad Consultant at TTC Global – Pune, Maharashtra
- Hiring Software Quality Assurance (SQA) – Join MOL IT India Pvt. Ltd. | Kolkata
- Salesforce Testing Professionals Wanted – Join Our Team in Chennai (Hybrid) | Up to ₹36 LPA
- Join Our Team as a QA Engineer | 4+ Years Experience | Playwright & TypeScript Expertise
- Job Opportunity: QA Engineer (Manual & Automation Testing) | Converj IT | PAN India
- Hiring: Manual Tester for Go-Live Faster | Pune | Banking Domain Experience Required
- Hexaware Technologies Hiring: Manual Testing (AR/VR Headset Experience) | Mumbai
- Join Our Team as a QA Engineer/Lead | Bangalore – Immediate Openings
- Join Tier5 as a QA Engineer | Remote Opportunity
- Exciting Opportunity: Java + Selenium QA Engineer | Chennai
- Exciting Opportunity at Zehntech: Quality Analyst Role in Indore
- Join JigNect as a Quality Assurance Automation Engineer | Ahmedabad
- Join Appnox Technologies as a Senior QA Engineer | Exciting Career Opportunity
- Urgent Hiring: Experienced QA Tester in Noida | On-Site Opportunity
- Launch Your Career in QA: Join Us as a Software Tester in Bangalore!
- Exciting Opportunity: Join Us as a QA Engineer (Java with Selenium) | Remote
- Elevate Your Career as a Quality Engineering Specialist at Dassault Systèmes, Pune!
- Join Us as a Software Tester in Mohali!
- Exciting Remote Opportunity: QA Tester Role – Join a Fintech Start-up Revolutionizing Payments and Cryptocurrencies
- BT Group Hiring QA/SDET Engineer – Join Our Team in Bangalore
Apply: Click here to Apply
Get daily 200+ openings on WhatsApp for Manual Testing, Automation Testing, ETL Testing and IT Freshers