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
- Exclusive Automation Testing Job Updates: Your Key to Securing Top Roles in 2024
- Proven Hacks to Increase IT Job Interview Calls: Email Applications, Resumes, Follow-Ups, and Notice Period Tips
- Step into the World of Quality Engineering with Accenture
- Elevate Your Testing Career as a Test Specialist with Birlasoft
- Join GE Digital as a Quality Assurance Engineer (Automation) in Hyderabad
- Testing-Automation-Functional Role at EY in Mumbai
- Senior Quality Assurance Automation Engineer Job Opening at Checkmarx in Pune
- Performance Tester Job Opening at GlobalLogic in Pune
- Exciting Career Opportunity: Associate Senior SDET Analyst at Global Payments Inc. in Pune
- Exciting Opportunity: Performance Test Engineer at Globant in Pune
- Exciting Opportunity: Software Testing Engineer at Mahindra Group in Pune
- Career Opportunity: Quality Assurance Analyst at Wipro in Pune
- Exciting Career Opportunity: QA Engineer at Community Brands in Pune
- Exciting Opportunity: Senior Software Test Engineer at UBS in Pune
- Unlock Your Career Potential as a QA Specialist at PTC in Pune
- Exciting Career Opportunity: Quality and Testing Engineer at Deutsche Bank in Pune
- Elevate Your Career as a QA Lead at Virtusa in Pune
- Sr Quality Engineer at HMH Tech India: An Exciting Opportunity in Pune
- Exciting Opportunity: Test Lead Position at YASH Technologies in Pune
- Join Accenture as a Quality Engineering Lead (Test Lead) in Pune
- Advance Your Career as a Deputy Manager in Quality Assurance at Whirlpool Corporation
- Elevate Your Career with Capgemini: API Testing Position in Bengaluru
Apply: Click here to Apply
Get daily 200+ openings on WhatsApp for Manual Testing, Automation Testing, ETL Testing and IT Freshers