About Business Unit :
At the heart of everything we do is data and this team. Our premium data assets empower the team to drive desirable outcomes for leading brands across industries. Armed with high volumes of transactional data, digital expertise and unmatched data quality, the team plays a key role in improving all our product offerings. Our data artisans are keen on embracing the latest in technology and trends, so there’s always room to grow and something new to learn here.
Why we are looking for you :
- You have hands on experience in SQL, Postgres DB & Advance SQL Skills to work with Epsilon Market place team
- You have hands on experience in coding languages like Python & Shell Scripting.
- You have hands on experience in fine tuning SQL Queries.
- You are very good in handling & working closely with key partners of the Project, you must communicate and keep them informed on overall health on projects impacting Data platforms.
- You have exposure on Data warehouse, BI.
What you will enjoy in this role :
As part of onboarding team will be onboarding multiple CRM Client’s across globe (US, APAC).Working on ingest of anonymized data is responsible for integration of first party client information into the CNVR ad serving ecosystemWorking on the data assets which will be further used in performance measurement and efficacy of the defined solution, as well as feeding business intelligence, analytics and data mining.Working on scheduling, backup and recovery, and scripting (specifically python) for data integration.Supporting application works on the front lines of CNVR, as a direct face to our client roster that truly enables their ability to turn their valuable data assets into monetization and increased customer engagement.Click here to view how Epsilon transforms marketing with 1 View, 1 Vision and 1 Voice.
What you will do?
End to end development of automated receipt of anonymized dataQuality detection of file layouts and file contents before acceptance into productionDevelopment of SQL based ETL routines that transform raw data into production assets to meet required business rule specificationsEnsuring that coded solutions meet functional business requirements for ad serving and measurementApplication specific controls and schedulingCustom solution building for syndicated and third party datasetsMigration of production data assets to downstream consuming systemsDisaster Recovery and Business Continuity implementationsWorkload Performance Management and TuningQualifications
Bachelor’s Degree in Computer Science or equivalent degree is required3 - 6 years of experience in development using SQL, Adv SQL, PL-SQL, PythonRelational DBMS, MPP and SQL knowledge (Oracle, SQL Server, MySQL, Greenplum), Postgres DBSolid experience in writing Basic and Advanced SQL queries and tuning / optimizing themExperience with distributed database systemsLinux shell scriptingLanguage Skills - PythonSolid understanding in Data warehouse is plusGood experience in working with geographically and culturally diverse teamsGood verbal and written communication skillsExcellent written and verbal communication skillsExcellent Analytical and problem-solving skillsAbility to diagnose and solve problems quickly