Educational Initiatives (EI)
Location
Bangalore | India
Job description
1. Analyze requirements, produce accurate, unambiguous technical design specifications to the appropriate detail
2. Plans, designs, develops, integrates application components and tests software systems or applications for software enhancements and new products. Write, debug, and deploy code to production; deliver timely fixes.
3. Deliver customer value in the form of high-quality software components and services in adherence with policies on security, performance, longevity and integration testing.
4. Be well versed in the latest development methodologies like Agile, Scrum, and DevOps.
5. Adhere to DOD (story definition of done) as part of the sprint, including unit tests, functional testing, code reviews, no regressions, bug fixes, documentation and adhere to best coding practices.
6. Develop both physical and logical data models.
7. Analyze all data warehouse architecture goals and identify skill requirement for same.
8. Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products.
9. Develops and applies sound fundamental design, analysis, and data administration concepts, practices, and procedures.
10. Transition data within/across traditional RDBMS, Massively Parallel Processing DW, modern cloud based DW
11. Build data warehouses, data marts on-premises/cloud
12. Ingest batch and streaming data, build ELT/ETL pipelines
13. Perform data profiling and quality analysis
14. Prepare designs for database systems and recommend improvements for performance.
15. Focuses on enterprise-wide data modeling and database design.
16. Maintain and develop various database scripts and tools to facilitate automation process.
17. Creates logical and physical data models, mapping logical to physical.
18. Understand and load dimensional data models.
19. Design, build, and maintain physical databases, dimensional data models, OLAP cubes, ETL layer design and data integration strategies
20. Develop various ETL processes, prepare OLAP cubes, and perform tests on data.
21. Prepare design for all metadata according to various ETL processes.
22. Perform troubleshoot on all ETL processes and resolve issues in Data ETL/warehouse/marts.
23. Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment.
24. Designs and develops BI reporting deliverables
25. Prepare appropriate status reports and submit it to management.
26. Design holistic system, sub systems and develop system design document that outlines implementation scope for entire team; review get sign off from all stakeholders and set expectations.
27. Ensure alignment of data models within the enterprise data warehouse environment across conceptual, logical, and physical data models, whether overall or project/iteration level data model
28. Evangelize the use of data quality metrics and best practices from ingest to deliver
29. Partner with solution architects to align various project architectures with the overall vision and standards outlined
30. Investigate complex strategic business issues, researching and identifying innovative solutions
31. Partner closely with Business Analysts, Product Capability Managers, Technical Leads, other Solution Architects, internal stakeholders, and external customers to ensure alignment with projects, programs and strategies, and standards.
32. Guide test plan creation.
33. Participates in the design of the technical and information architecture for the data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores).
34. Perform peer code reviews in order to ensure quality standards
35. Master the domain knowledge in the area of assignment
36. Take ownership of what the team builds after the release; consider customer adoption as success criteria
37. Volunteer for work in the backlog and commit to quality delivery; Coordinate efforts across the team to ensure completion and effectiveness
38. Participate and contribute to scrum meetings ie daily stand-up, sprint planning, readouts and retrospectives
39. Work collaboratively across the Technology and Product organizations to ensure alignment towards business goals
40. Should understand fundamentals of iterative product development.
41. Should understand the value of commitments to delivery made by a development team
42. As a member of technical staff, youll have the opportunity to grow as a software engineer in a culture of technical excellence, high team performance and impeccable work ethics.
Technical Requirements:
1. Expertise in data warehouse modeling and implementation
2. Deep knowledge experience in Data Architecture, Data Warehouse Concepts, and enterprise scale Reporting and analytical systems
3. Must have experience in various data related roles including but not limited to data systems architecting, design and development, implementing large scale enterprise applications and analytical solutions and leading team of junior developers to deliver solutions
4. SQL ETL tools (eg, Informatica, Talend, Pentaho, SSIS)
5. RDBMS (eg, Oracle, DB2, SQL Server)
6. DW on cloud (eg, Snowflake, Redshift, Azure Synapse)
7. Cloud environments (eg, AWS, Azure, GCP)
8. Unix shell scripting Scheduling tools (eg, Control-M, Autosys, Cron)
9. Experience in working with data marts and dimensional models (star, snowflake schema)
10. Experience in data modeling (data warehouse) will be an added advantage.
11. Hands-on experience with one or more ETL tools like Informatica PowerCenter, Talend, DataStage, ODI, BODS, Microsoft SSIS
12. Hands-on experience with one or more Cloud ETL/ELT - Matillion, Fivetran, Stitch, StreamSet, DBT, Striiim
13. Hands-on experience with one or more Data Replication tools - Qlik Replicate/Composite, HVR, Oracle GoldenGate, Informatica PowerExchange
14. Experience in cloud data migration project or building DW/Data Lake on Cloud Data Platform like Snowflake, Azure Synapse, AWS Redshift and/or BigQueryStrong skills in memory management and exception handling, knowledge in asynchronous programming practices.
15. Independently able to decide on strategy, design, develop and implement enterprise grade data warehouse system.
16. Experience with building high-quality software based upon architectural specifications.
17. Very comfortable using GIT version control tool (we use Bitbucket)
Job tags
Salary
