Base Career helps you apply smarter for this job.
Key skills for this role
The role is responsible for delivering Data Warehouse (DWH) solutions using ETL technologies such as Informatica (IICS/IDMC), Databricks, Spark, PostgreSQL, and Oracle.
The individual will lead technical design and development activities, support production deployments, mentor team members, and ensure adherence to Guardian's SDLC, security, and compliance standards.
The role requires strong expertise in ETL development, data warehousing, performance optimization, production support, and solution architecture, while also driving automation and continuous improvement initiatives.
The role is responsible for delivering Data Warehouse (DWH) solutions using ETL technologies such as Informatica (IICS/IDMC), Databricks, Spark, PostgreSQL, and Oracle. The individual will lead technical design and development activities, support production deployments, mentor team members, and ensure adherence to Guardian's SDLC, security, and compliance standards. The role requires strong expertise in ETL development, data warehousing, performance optimization, production support, and solution architecture, while also driving automation and continuous improvement initiatives.
Design, develop, and maintain ETL solutions using Informatica (IICS/IDMC), Databricks, and Syncsort. Perform data extraction, transformation, and loading activities for BI and Data Warehouse projects. Conduct impact analysis and provide effort estimations for ETL enhancements and changes. Develop and execute unit test cases for all deliverables.
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
New York City, USA
Guardian is seeking a Global Capital Risk Analyst to manage regulatory capital forecasts, analyze financial results, and support capital optimization and enterprise planning. The role partners with investment, actuarial,
Plano, USA
Atlanta, USA
Boston, USA
, IND
Guardian Life is seeking a senior IT platform lead to administer enterprise messaging, email security, and Microsoft 365 collaboration services. The role includes troubleshooting, integrations, service management, migrat
Gurugram, IND
Chennai, IND
New York City, USA
Plano, USA
Atlanta, USA
Boston, USA
Chennai, IND
, IND
Develop and optimize SQL, PL/SQL, Spark SQL, Hive, and Presto queries.
Create and maintain procedures, functions, triggers, constraints, and cursors.
Perform query tuning and ETL performance optimization.
Interpret and work with conceptual, logical, and physical data models.
Design robust ETL architectures focused on data quality, performance, and error handling.
Support current-state ("As-Is") architecture and contribute to future-state ("To-Be") architecture design.
Evaluate new technologies and conduct proof-of-concepts (POCs).
Execute all SDLC phases including requirements analysis, design, development, testing, deployment, and support.
Follow SAFe Agile methodology and Guardian development standards.
Participate in release planning, deployment, migration, and post-production support.
Provide Level-2 production support and on-call support activities.
Troubleshoot ETL failures, application defects, and job abends.
Coordinate with DBA, Network, Storage, Scheduling, and User Administration teams for issue resolution.
Support warranty and stabilization activities after deployment.
Education: B.Tech Computers/MCA
Experience: 2.5 to 4 years in development projects with BI/ DWH background.
Verified company details for this employer are not available yet.
Full-time
Senior
Onsite
Apply faster on company sites with our extension.