Guardian Code -A- Thon Hiring Challenge – ETL Chronicles v4.0 Hackerearth Test MCQs Programming Questions Answers & its Solution

Are you looking for a Guardian Code -A- Thon Hiring Challenge – ETL Chronicles Hackerearth Test MCQs Programming Questions Answers & its SQL Queries Solution? In this challenge description, you will get to know about the "Guardian Code -A- Thon Hiring Challenge – ETL Chronicles" - Guardian Inc Hackerearth Test Interview Recruitment Process and the Test Pattern of the Guardian Inc Company.

About the Company

Every day, Guardian provides Americans the security they deserve through our insurance and wealth management products and services. Since our founding in 1860, our long-term view has helped our customers prepare for whatever life brings whether starting a family, planning for the future or taking care of employees. Today, we're a Fortune 250 mutual company and a leading provider of life, disability, dental, and other benefits for individuals, at the workplace and through government-sponsored programs. The Guardian community of over 9,000 employees and our network of over 2,500 financial representatives is committed to serving with expertise when, where, and how our clients need us. Our commitments rest on a strong financial foundation, which at year-end 2021 included $10.7 billion in capital and $1.9 billion in operating income.

Company Name: Guardian Inc

Job Location:  Chennai and Gurgaon

Degree Needed: Computer Science/E&TC, MCA, MBA IT, MSc (CS) 

 Experience Eligible- 3-8+ years  

Job Profile: Software Development Engineer/Senior Engineer/ Technical Lead/ Architect

Skill: JavaScript (Node.js),  Python

CTC: As per industry standards 

Details About Guardian Code -A- Thon Hiring Challenge – ETL Chronicles - Hackerearth Test Questions Answers

The objective of the challenge is to identify the best Software Engineers to join a passionate team and work towards Advancing the World of Health!

 

Challenge Overview:

Do you love challenges that offer you an exciting career with a Fortune 250 company? Here is your chance to win it. Participate in the Code -A- Thon Challenge and grab the opportunity to join our technology team. Compete in this coding challenge to test your coding and problem-solving skills by solving real-world technical challenges.

Eligibility Criteria:

• Years of experience: 3-8 years
• Skills: JavaScript (Node.js)

Challenge Format:

• 10 MCQs
• 1 Programming Questions (Language Restriction: Python)
• 1 SQL Question (Supported Databases: MySQL, MS SQL, PostgreSQL, and OracleDB)

Recruitment process:

1. Take our online challenge ( 2 Hours )

• Open till 23rd October 11:55 PM (GMT+5:30). Top-ranked coders from our online challenge will be invited for an in-person hackathon. 

2. Get Selected 

• You will be invited to Code -A- thon challenge & will be interviewed for positions at Guardian India operations. (Terms and conditions apply)
• The job opportunity is based in Gurgaon & Chennai for the Technology team, India 

 

The candidature will be subject to meeting Guardian Inc eligibility criteria in addition to test clearance.  

Opening Positions:  ETL Developer

Experience:	3-8 years
Compensation:	Best in industry
Job Location:	Chennai and Gurgaon

Skills:

• Support, upgrade, maintenance of ETL server/client/jobs
• Knowledge of Agile Methodology/ SAFe Practices
• Establish, maintain and enforce ETL design principles, techniques, standards and best practices.
• Exp working with & able to demonstrate knowledge of complex Informatica transformations.
• Exp working with very large data sets in ETL projects.
• Exp working on UNIX platforms - AiX.
• Exp in ETL performance tuning /optimization;
• Exp with the Informatica command line utilities;
• Exp drafting ETL specifications;
• Exp developing complex ETL mappings;
• Exp developing & deploying SSIS packages in an Enterprise environmentAbility to understand the domain and communicate with client/business
• Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation &metadata management.
• Strong knowledge of Unix & Unix Shell scripting
• Experience with Enterprise Scheduling tools such as Control-M is a plus.
• Tools, Concepts and Methodologies of BI/DWH.
• Excellent Customer Relations – forms productive relationships with customers & development teams.
• Excellent writing & communication skills.
• Excellent analytical skills.
• Review and assess existing ETL applications, to support new features, performance improvements, upgrades, and ongoing sustainment
• Support on-going ETL environment and support during maintenance or failure
• Work closely with ETL migration/ network teams and DBA’s on operational failures and triage issues.
• Good understanding of various data models, both relational and dimensional and their associated principles.
• 3-4 years’ experience in performance tuning of report under high data volumes.
• Data Lake Support
• SQL, Unix scripting, Informatica (must have)
• Hadoop, HIVE, Presto
• Syncsort (good to have)
• Pyspark, Python and AWS
• Good communication, coordination skills across multiple teams, analytical skills
• Good aptitude, logical thinking and a good attitude

Technology: 

• Informatica Power center, Informatica Cloud & SSIS

Education and Experience:

Education: B.Tech Computers/MCA

Experience: 3 to 8 years in support projects with BI/ DWH background involving  Informatica Power center, Informatica Cloud & SSIS (SQL Server Integration Services) tools, Shell scripting, SQL Query writing

 

Do You Want To Get Download the Free Guardian Code -A- Thon Hiring Challenge – ETL Chronicles Test - Hackerearth Test Questions and Answers with Programming Questions Solution with SQL Queries, Guardian Inc Hackerearth Online Challenging Test, and HR Technical Interview Question and Answer?