Job Description :
Data Architect
Need someone who has worked as a Data Architect at enterprise level and have dealt with data related to any of these- reservoir engineering, Well Analytics, rock Analysis, Hydrolic Frac Simulation or Geo mechanics.
Some one who has very strong Data Modelling exp and have Data transformation / migration exp on AWS cloud
Datawarehouse: have worked on Data lake
ETL tools- SSIS or talend or Informatica
Database- must have- postgres, sql server, redshift, snowflakes database. Nice to have is mongo db or Cassandra.
Python knowledge is required.
Job Description
Technical Skills:
Overall experience – 10-12 years
6-8 years of experience in DB Design , DB Modelling areas
Experience in designing and leading the conceptual , logical and physical design for relational and dimensional systems
3NF, BCNF, Star schema etc
Excellent experience in Postgres and Mongo DB
Excellent experience in SQL , PLSQL and Performance tuning
Experience with Modelling , Visualization and reporting tools
Excellent knowledge on Data Warehousing architecture and implementation
Experience in ETL tools
Experience in data integration and tools
Strong understanding in Master data management , Metadata management and Data governance
Experience of Cloud data technologies , solutions and strategies AWS / MS Azure Docker, ECS,
Python : Hands-on experience using data handling libraries using pandas, numpy, airflow, luigi
Added Advantage: Nice to have
Snowflake Datawarehouse
Hadoop HDFS , SQOOP , KAFKA , etc
Excellent knowledge on Big Data ecosystem and tools
Excellent knowledge on Agile Methodologies
Building CI/CD pipelines
Key Responsibilities:
Build , operate and enhance activities for teams tasked with data lake hub architecture
Design and build a centralized data lake to enable business intelligence , analytics and data science options
Provide Architectural/ technical guidance to architectural/design decisions across
Reviews, coordinates, analyses and defines requirements for new development/enhancements
Generate and document technical designs including all appropriate flow charts, class, sequence, activity, data flow diagrams, database ER diagrams, descriptive software component documentation, wireframes as needed
Design and Develop POCs /ideas /sometimes new tool-system and tests applications based on customer requirements and best practices.
Creates required technical documentation, use cases, system and deployment architecture, and technical process/procedure documents for the group.
Assess the risk, problem/problem resolution and impact of changes to complex applications and solutions
Provide overall level of effort(LOE) with the ability to organize & scope software development into smaller task units to provide overall product effort estimates/costs and organize into the more tactical backlog
Interface with database/ DWH/ UDA oriented end-users and customer-facing groups Communicate effectively with other engineers and various stakeholders including mentoring junior developers and engineers