Senior Data Engineer - IT (ETL)

Job Description:

Experience Required: 4-6 Years

Certification Preferred: Informatica Certified (IDMC), Databricks Certified Data Engineer (a plus)

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. Experience & certification in Databricks is a plus.

Key Responsibilities

• Design 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, and Cloud.
• 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 Skills

• Strong 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, Spark SQL, Python).

Required Soft Skills

• Excellent 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.