Data Build Tool Developer (Remote)

We are Cognizant Artificial Intelligence Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. However, clients need new business models built from analyzing customers and business operations at every angle to really understand them. With the power to apply artificial intelligence and data science to business decisions via enterprise data management solutions, we help leading companies prototype, refine, validate, and scale the most desirable products and delivery models to enterprise scale within weeks You must be legally authorized to work in United States without the need of employer sponsorship, now or at any time in the future Job Title: Data Build Tool Developer (Remote) Role/Responsibilities: Solid understand and hands-on experience on dbt (database build tool) to perform ETL/ELT tasks. Fluent in relational design principles and writing complex SQL. Beginner experience with Docker and deploying code as a container/microservice. Beginner understanding of cloud environments such as Azure (preferred) GCP and AWS. In-depth understanding of Data Warehousing ETL concepts and data modeling principles. Reverse engineer existing SSIS packages and convert them into DBT code. Expertise on engineering platform components such as Data Pipelines Data Orchestration Data Quality Data Governance & Analytics. Hands-on experience on implementing large-scale data intelligence solution around Snowflake DW. Work with Architects on cloud data migration strategy and planning lead the team to drive towards it. Design build and maintain scalable data pipelines and access patterns using standard tools and custom code. Utilize and advance CI/CD framework. Responsible for monitoring production servers scheduled jobs and incident management. Knowledge on DBT Architecture. Review the unit testcases test scripts and the logs. Review the QA migration strategy test approach and test logs. Migration to higher environment and work with QA team on the bug fix. Performance tuning. Excellent interpersonal organizational written communication oral communication and listening skills. Must have experience of Agile development methodologies. Co-ordinate with the onshore developer and offshore development team to follow the design best practice code reviews and bug free code to UAT & production. Prepare the code deployment plan and review with the architects and project team. Experience on Healthcare Payer & Clinical data domain. Required Qualifications: Skillset: DBT. Technical Skills: Azure Google Cloud Platform ETL Validation Nice to have skills: Snowflake Salary and Other Compensation: This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans. Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements: Medical/Dental/Vision/Life Insurance Paid holidays plus Paid Time Off 401(k) plan and contributions Long-term/Short-term Disability Paid Parental Leave Employee Stock Purchase Plan Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law. Cognizant is an Equal Opportunity Employer M/F/D/V. Cognizant is committed to ensuring that all current and prospective associates are afforded equal opportunities and treatment and a work environment free of harassment. Cognizant is recognized as a Military Friendly Employer and is a coalition member of the Veteran Jobs Mission. Our Cognizant Veterans Network assists Veterans in building and growing a career at Cognizant that allows them to leverage the leadership, loyalty, integrity, and commitment to excellence instilled in them through participation in military service. Must Have Skills Snowflake, DBT Good To Have Skills ETL Validation Google Cloud Platform Azure Technical Skills SNo Primary Skill Proficiency Level Rqrd./Dsrd. 1 ETL Validation PL3 Desired 2 Snowflake PL4 Required 3 Google Cloud Platform PL3 Desired 4 Azure PL3 Desired Proficiency Legends Proficiency Level Generic Reference PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels. PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects. PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects. PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.