Immediate Joiner
Contract
Work from home
Job Details:
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Google 'big data'
Build processes supporting data transformation, data structures, metadata, dependency and workload management.
Work with stakeholders including the BSA, Report developers, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
Additional responsibilities include troubleshooting, maintenance, and optimization or enhancement of existing processes.
Partner with engineering leads and architects to define & coordinate technical design.
Design and code reviews to ensure standards and quality level for the build
Performance tuning of Data Pipeline jobs to meet SLA
Prepare technical documentations on the deliverables
Identify, define and implement best practices for process improvements for SDLC management
Experiences:
Platform, product & software experience: You have 6+ years of hands-on experience using SQL, GCP, Informatica, Python and version control (git) with good analytical & debugging skills. Good to have experience in Data flow, Exasol, big data infrastructure, real time streaming, CDC, Java, java script.
Data modeling: Flair for data and strong design skills in data model, PL/SQL, dimensional model/star & snowflake schema, data lake/mart/set and to bring efficiency in data modeling for efficient querying data for analysis, understands criticality TDD and develops data validation techniques.
Cross functional domain experience: Must have experience in cross functional domain and end to end knowledge of business function like CRM (Oppty, Quote, Order, Fulfilment, Asset) and Finance (AP, AR, Revenue).
Project management: You demonstrate excellent project and time management skills, exposure to scrum or other agile practices in JIRA.
Mandatory Skills:
SQL, Python, GCP, ETL, Data Modeling
Any Graduate