Job Description

:
Certification Preferred: Databricks Certified Data Engineer, Informatica (IDMC)
Job Summary
We are seeking a skilled and motivated Data Engineer with strong experience in Data Warehousing concepts, ETL/ELT development, and hands-on expertise in Informatica. The ideal candidate will have a solid understanding of data modeling, excellent communication skills, and experience working in Agile environments. Certification in Databricks is a plus.
Key ResponsibilitiesDesign and develop ETL/ELT processes using Guardian-approved tools such as Informatica, SSIS, and Syncsort. Work with big data technologies including HIVE, HAWQ, Spark SQL, Python, PySpark and AWS EMR. Perform hands-on development in UNIX, PL/SQL, HQL, and conduct unit testing for all deliverables. Interpret and work with logical, physical, and conceptual data models and ER diagrams. Create and maintain technical documentation including functional specs, test plans, deployment guides, mapping documents, and runbooks. Optimize ETL and query performance, conduct impact analysis, and contribute to solution design. Collaborate with on-site/offshore teams to clarify requirements and resolve issues. Participate in all SDLC activities including requirement analysis, effort estimation, development, testing, and deployment. Provide production support including Level 2 on-call support and incident resolution. Ensure compliance with Guardian's security and development standards. Engage with Guardian SMEs for knowledge transition and steady-state support. Drive ETL architecture design, enforce best practices, and assess existing applications for improvements. Identify and implement automation opportunities to improve efficiency.

Required Technical SkillsStrong understanding of Data Warehousing and Data Modeling. Proficiency in ETL/ELT tools - Informatica, SSIS, Syncsort. Experience with PL/SQL - procedures, triggers, constraints, cursors, functions. Familiarity with SAFe Agile methodology. Experience with big data tools and cloud platforms (AWS EMR, Spark SQL).

Required Soft SkillsExcellent Communication Skills - ability to clearly articulate technical concepts to both technical and non-technical stakeholders. Analytical Thinking - strong problem-solving skills and ability to perform root cause analysis. Collaboration - experience working in cross-functional teams and coordinating with on-site/offshore teams. Self-Motivation - ability to work independently and take ownership of deliverables. Adaptability - comfortable working in a dynamic environment with changing priorities. Attention to Detail - thorough in documentation, testing, and quality assurance. Proactive Mindset - ability to identify opportunities for improvement and automation.

Location:
This position can be based in any of the following locations:
Chennai
Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday