Data Engineer II

Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.

Apexon brings together distinct core competencies – in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences – to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients’ toughest technology problems, and a commitment to continuous improvement.

Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents.

We enable #HumanFirstDIGITAL

Description

Snowflake data engineers will be responsible for architecting and implementing very large-scale data intelligence solutions around Snowflake Data Warehouse. A solid experience and understanding of architecting, designing and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse is a must. Need to have professional knowledge of AWS Redshift.

You’ll Be Responsible For (Responsibilities)

• Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes Snow SQL
• Writing SQL queries against Snowflake.
• Developing scripts Unix, Python etc. to do Extract, Load and Transform data Working knowledge of AWS Redshift
• Provide production support for Data Warehouse issues such data load problems, transformation translation problems.
• Translate requirements for BI and Reporting to Database design and reporting design.
• Understanding data transformation and translation requirements and which tools to leverage to get the job done.
• Understanding data pipelines and modern ways of automating data pipeline using cloud based

Testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.

You’ll Have (Qualification & Experience)

• Minimum 1 year of designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse.
• 3 years of hands-on experience with building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python
• 2 years of hands-on experience designing and implementing production grade data warehousing solutions on large scale data technologies such as Teradata, Oracle or DB2
• Expertise and excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies.
• Experience in building data ingestion pipeline using Talend, Informatica
• Experience in working with AWS, Azure and Google data services.

Our Commitment To Diversity & Inclusion

Did you know that Apexon has been Certifiedtrade mark by Great Place To Workregistered, the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK.

Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law.

You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy (apexon.com

Our Perks And Benefits

Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones.

As an Apexer, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.

Ind

We also offer:

• Group Health Insurance covering family of 4
• Term Insurance and Accident Insurance
• Paid Holidays & Earned Leaves
• Paid Parental Leave
• Learning & Career Development
• Employee Wellness