DWH-Data Engineer

Associate / Junior

|

Remote

Meytier Premier Employer

Apply NowAppliedThis job might no longer be active.

Working there

{"group":"Organization","title":"DWH-Data Engineer","zohoId":"557706000009873001","endDate":"2022-11-15T00:00:00.000Z","jobType":"Full Time","job_url":"241-tiger-analytics-dwh-data-engineer","agencyId":1,"location":[{"lat":13.0833,"lon":80.2833,"city":"Chennai","text":"Chennai, Tamil Nadu 600096, India","state":"Tamil Nadu","country":"","zipCode":"600096","is_state":false,"is_country":false,"state_code":"TN","countryCode":"","isLocationSet":true,"loc_h3_hex_res4":"84618c5ffffffff","isLocationResolved":false,"is_address_available_from_parser":true}],"maxSalary":null,"minSalary":null,"startDate":"2022-09-22T00:00:00.000Z","onBehalfOf":"59","description":"<span id=\"spandesc\"><p style=\"margin: 0px 0px 10px; text-align: justify\" class=\"align-justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">As a Data Engineer, focused on modern data warehousing, you will be working on teams that will build a variety of modern DW solutions. More specifically, you will:</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></p><ul><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Transit data within/across traditional RDBMS, MPP DW, modern cloud-based DW</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Build data warehouses &amp; data marts on-premises/cloud</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Ingest batch and streaming data, build ELT / ETL pipelines</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Perform data profiling and quality analysis</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Understand and load dimensional data models</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Perform SQL performance tunings on long running queries</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Collaborate with business consultants, data scientists, and application developers to develop analytics solutions</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li></ul><p style=\"margin: 0px 0px 10px; text-align: justify\" class=\"align-justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><b><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Required Experience, Skills &amp; Competencies:</span></span></b></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></p><ul><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Hands-on experience with:</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><ul><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">SQL</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">ETL tools (e.g. Informatica, Talend, Pentaho, SSIS)</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">RDBMS (e.g. Oracle, DB2, SQL Server)</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">DW on cloud (e.g. Snowflake, Redshift, Azure Synapse)</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Cloud environments (e.g. AWS, Azure, GCP)</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Unix shell scripting</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Scheduling tools (e.g. Control-M, Autosys, Cron)</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li></ul><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">Experience in working with data marts and dimensional models (star, snowflake schema)</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"highlight\" style=\"\"><span class=\"colour\" style=\"\"><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\">5+ years of relevant experience</span></span></span></span><span class=\"size\" style=\"font-size: 13px\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><br /></span></span></li></ul><div class=\"align-justify\" style=\"text-align: justify\"><br /></div></span><br />","isHybridJob":false,"isRemoteJob":true,"noOfOpenings":1,"maxExperience":"7","minExperience":"5","isOnPremiseJob":false,"onBehalfOfName":"Tiger Analytics","otherlocations":[],"zohoCurrencyIn":"USD","experienceLevel":"Associate / Junior","zohoNoOfOpenings":{"noOfOpenings":1,"fulfillmentIds":["557706000009873001-1"]},"otherJobReference":null,"sharpenedJobTitle":"DWH-Data Engineer","job_category_group":3,"portalLocationDisplay":"Chennai TN","expertise_coreskill_or_product":["Other"],"job_id":"2659"}