2+ ETL management Jobs in Bangalore (Bengaluru) | ETL management Job openings in Bangalore (Bengaluru)

Description

Power BI JD

Mandatory:

• 5+ years of Power BI Report development experience.

• Building Analysis Services reporting models.

• Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.

• Connecting data sources, importing data, and transforming data for Business intelligence.

• Analytical thinking for translating data into informative reports and visuals.

• Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.

• Should have an edge over making DAX queries in Power BI desktop.

• Expert in using advanced-level calculations on the data set.

• Responsible for design methodology and project documentaries.

• Should be able to develop tabular and multidimensional models that are compatible with data warehouse standards.

• Very good communication skills must be able to discuss the requirements effectively with the client teams, and with internal teams.

• Experience working with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, and SSIS

• Mandate to have experience with BI tools and systems such as Power BI, Tableau, and SAP.

• Must have 3-4years of experience in data-specific roles.

• Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

• Knowledge of all the Power BI products (Power Bi premium, Power BI server, Power BI services, Powerquery etc)

• Grip over data analytics

• Interact with customers to understand their business problems and provide best-in-class analytics solutions

• Proficient in SQL and Query performance tuning skills

• Understand data governance, quality and security and integrate analytics with these corporate platforms

• Attention to detail and ability to deliver accurate client outputs

• Experience of working with large and multiple datasets / data warehouses

• Ability to derive insights from data and analysis and create presentations for client teams

• Experience with performance optimization of the dashboards

• Interact with UX/UI designers to create best in class visualization for business harnessing all product capabilities.

• Resilience under pressure and against deadlines.

• Proactive attitude and an open outlook.

• Strong analytical problem-solving skills

• Skill in identifying data issues and anomalies during the analysis

• Strong business acumen demonstrated an aptitude for analytics that incite action

• Ability to execute on design requirements defined by business

• Ability to understand required Power BI functionality from wireframes/ requirement documents

• Ability to architect and design reporting solutions based on client needs.

• Being able to communicate with internal/external customers, desire to develop communication and client-facing skills.

• Ability to seamlessly work with MS Excel working knowledge of pivot table and related functions

Good to have:

• Experience in working with Azure and connecting synapse with Tableau

• Demonstrate strength in data modelling, ETL development, and data warehousing

• Knowledge of leading large-scale data warehousing and analytics projects using Azure, Synapse, MS SQL DB

• Good knowledge of building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets

• Good to have knowledge of Supply Chain Domain.

Your key responsibilities

• Create and maintain optimal data pipeline architecture. Should have experience in building batch/real-time ETL Data Pipelines. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources
• The individual will be responsible for solution design, integration, data sourcing, transformation, database design and implementation of complex data warehousing solutions.
• Responsible for development, support, maintenance, and implementation of a complex project module
• Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
• Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support.
• complete reporting solutions.
• Preparation of HLD about architecture of the application and high level design.
• Preparation of LLD about job design, job description and in detail information of the jobs.
• Preparation of Unit Test cases and execution of the same.
• Provide technical guidance and mentoring to application development teams throughout all the phases of the software development life cycle

Skills and attributes for success

• Strong experience in SQL. Proficient in writing performant SQL working with large data volumes. Proficiency in writing and debugging complex SQLs.
• Strong experience in database system Microsoft Azure. Experienced in Azure Data Factory.
• Strong in Data Warehousing concepts. Experience with large-scale data warehousing architecture and data modelling.

• Should have enough experience to work on Power Shell Scripting

• Able to guide the team through the development, testing and implementation stages and review the completed work effectively
• Able to make quick decisions and solve technical problems to provide an efficient environment for project implementation
• Primary owner of delivery, timelines. Review code was written by other engineers.
• Maintain highest levels of development practices including technical design, solution development, systems configuration, test documentation/execution, issue identification and resolution, writing clean, modular and self-sustaining code, with repeatable quality and predictability
• Must have understanding of business intelligence development in the IT industry
• Outstanding written and verbal communication skills
• Should be adept in SDLC process - requirement analysis, time estimation, design, development, testing and maintenance
• Hands-on experience in installing, configuring, operating, and monitoring CI/CD pipeline tools
• Should be able to orchestrate and automate pipeline
• Good to have : Knowledge of distributed systems such as Hadoop, Hive, Spark

To qualify for the role, you must have

• Bachelor's Degree in Computer Science, Economics, Engineering, IT, Mathematics, or related field preferred
• More than 6 years of experience in ETL development projects
• Proven experience in delivering effective technical ETL strategies
• Microsoft Azure project experience
• Technologies: ETL- ADF, SQL, Azure components (must-have), Python (nice to have)

Ideally, you’ll also have