Technical Lead-Data Engg

About Us:
Birlasoft, a global leader at the forefront of Cloud, AI, and Digital technologies, seamlessly blends domain expertise with enterprise solutions. The company s consultative and design-thinking approach empowers societies worldwide, enhancing the efficiency and productivity of businesses. As part of the multibillion-dollar diversified CKA Birla Group, Birlasoft with it

Essential Duties and Responsibilities: This section contains a list of five to eight primary responsibilities of this role that account for 5% or more of the work. The incumbent will perform other duties assigned. Development of new ETL/data transformation jobs, using PySpark or Python in AWS. Enhancement and support on existing ETL/data transformation jobs. Can explain technical solutions and resolutions with internal customers and communicate feedback to the ETL team. Perform technical code reviews for peers moving code into production. Perform and review integration testing before production migrations. Provide high level of technical support and perform root cause analysis for problems experienced within area of functional responsibility. Can document technical specs from business communications.

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. List knowledge, skills, and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. 6+ years of ETL experience. Experience with core Python programming for data transformation. Intermediate-level Python and PySpark skills. Can write, read, understand and debug existing code Python and ySpark code from scratch. Strong knowledge of SQL fundamentals and snowflake experience, understanding of subqueries, can tune queries with execution hints to improve performance. Able to write SQL code sufficient for most business requirements for pulling data from sources, applying rules to the data, and stocking target data Proven track record in troubleshooting ETL jobs and addressing production issues like performance tuning, reject handling, and ad-hoc reloads. Proficient in developing optimization strategies for ETL processes. Basic AWS technical support skills. Has ability to log in, find existing jobs and check run status and logs Will run and monitor jobs running via Control-M Can create clear and concise documentation and communications. Can document technical specs from business communications. Ability to coordinate and aggressively follow up on incidents and problems, perform diagnosis, and provide resolution to minimize service interruption Ability to prioritize and work on multiple tasks simultaneously Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.