Role:
Data Engineering & Quality Management: Design, implementation, and management of data platform, data pipelines to help fulfill data access and aggregation functionality for users in cloud environment.
Responsibility:
- Key responsibility is to design and develop data warehouse and BI platform including the architecture, prototyping and development of data extract, transformation, cleansing and integration of structured and unstructured data ▪ Transform raw data into useful information and insights utilizing Analytics, Business Intelligence (BI) and visualization tools
- Provide technical expertise to design efficient solutions to consolidate data from other data systems (Oracle\MySQL\PostgreSQL\SQL Server\object storage etc), Enterprise Applications and 3rd party API
- Develop optimal design of data warehouse environments, analyzing complex distributed data deployments and making recommendations to optimize performance
- Design and develop database and application interfaces between various internal and external systems to efficiently and effective capture and integrate data
- Organize, optimize and debug data-driven reporting, BI and analytics applications
- Document & maintain data dictionary for data from various sources to enable data democratization - Work with business stakeholders to support their data needs and technical teams to replicate from their data sources.
Competency Requirement:
Technical/Functional:
- Hands-on experience with data architecture, design and development of data warehousing solutions
- Programming experience using Python - Extensive technicalexperience with SQL on RDBMS (Oracle/MySQL/PostgreSQL) and Data warehouse schema definitions (Snowflake), data modeling, security and design
- Strong analytical skills with ability to synthesize data to design and deliver meaningful solutions
- Experience implementing Reporting, BI, Visualization and Analytics tools such Power BI / AWS QuickSight / Cognos
- Good level of knowledge of database performance and tuning, troubleshooting and query optimization and tuning
- Good knowledge next generation ETL/ELT tools and data consolidation frameworks that enable capabilities within the data ecosystem.
- Ability to work independently or within a team, proactively, in a fast-paced AGILE-SCRUM environment.
Educational Qualification:
- B.E / B. Tech in Computer Science/IT
