Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

Engineer - IT(ETL)

unlimited holidays - fully flexible
Remote: 
Hybrid
Contract: 
Full time
Experience: 
Mid-level (2-5 years)
Work from: 
Chennai (IN)

Offer summary

Qualifications:

2+ years experience with ETL tools, Good understanding of Data Warehousing, Knowledge of SAFe Agile Methodology, B.Tech in Computers or MCA.

Key responsabilities:

  • Implement BI DWH projects using ETL tools
  • Guide and mentor team members
Guardian Life logo
Guardian Life Financial Services XLarge http://guardianlife.com/
5001 - 10000 Employees
HQ: New York
About Guardian Life
Who we are Guardian makes a difference in the lives of people when they need us most. With over 160 years of stability and fiscal integrity, we are a trusted resource to generations of families and business owners, inspiring well-being and helping build financial confidence. Today, we stand behind 29 million consumers, helping them prepare and plan for a bright future for themselves and their families. We help business owners care for their employees. And we help people recover and thrive in times of unexpected loss. As a modern mutual insurance company, we believe in driving value beyond dividends. We invest in our colleagues and are building a progressive, innovative and inclusive culture. We uplift individuals and communities through thoughtful social and environmental programs. What we stand for In 1860, a community of immigrants joined together to insure and protect their businesses and families. They were guided by powerful ideals that we’ve continued to stand behind and evolved throughout the years: we do the right thing, we believe people count, we courageously shape the future together, and we go above and beyond for the people we serve. Guardian employees embrace and live by these values every day. They remind us to put people at the heart of all we do so that we can help protect what matters most to you. Want to help bring these values to life? Join us for a rewarding career and the opportunity to shape the future. Disclosures: Financial information concerning Guardian as of December 31, 2022, on a statutory basis: Admitted assets = $76.0 billion; liabilities = $67.2 billion (including $55.0 billion of reserves); and surplus = $8.8 billion. Dividends are not guaranteed. They are declared annually by Guardian’s Board of Directors. Guardian® is a registered trademark of The Guardian Life Insurance Company of America. © Copyright 2023 The Guardian Life Insurance Company of America 2023-156184 Exp. 5/25
See more Guardian Life offers

Job description

Job Description:
The major responsibility of this role is to do BI & DWH project implementations using ETL tools – Informatica/ SyncSort, Querying using HIVE, PRESTO, Spark. He/she is responsible for guiding the team and sharing knowledge with them. Candidate will be responsible for successful deployment and support of the code. He/she will be responsible for guiding and mentoring team members and new hires
Qualifications:

Skills:       

  • 2+ years of hands-on and good experience in ETL tools – Informatica/SyncSort
  • Excellent Communication and analytic skills
  • Good Understanding of Data Warehousing and etl concept
  • Knowledge of SAFe Agile Methodology
  • Perform hands-on design and development activities for Extract Transform and Load (ETL) tasks using Guardian approved tools like Informatica and Syncsort and adept at performing impact analysis for ETL changes.
  • Perform hands-on development activities using Guardian approved tools like Syncsort components (DMX tasks and jobs, integrating with scheduler), HIVE, HAWQ, Spark SQL, AWS-EMR and perform Unit testing for all deliverables
  • Perform hands-on UNIX, PL/SQL, HQL development and perform Unit testing for all deliverables
  • Create and maintain Technical documentation for work deliverables including but not limited to Functional specification, Unit Test Plans, Deployment and Migration Documents, Mapping Document, Data Flow Document, Runbooks and Release notes
  • Experience with advanced PL/SQL – Procedures, Triggers, Constraints, Cursors, Functions
  • Experience with ETL and query performance optimization, technical analysis, and solution design
  • Coordinate and interact with the On-site / Off-shore team to clarify on requirements / issues if any
  • Perform all applicable SDLC activities for the work items assigned including requirement analysis, impact analysis and effort estimations.
  • Perform initial analysis of tasks, perform effort estimations based on Guardian standards, assign and monitor work queues.
  • Provide Review, Testing support and production deployment and post-production (warranty) support for work deliverables
  • Ensure adherence to Guardian Security, Compliance and Development Standards for work deliverables.
  • Co-ordination with the Guardian SME's and participate in knowledge transition sessions
  • Establish, maintain, and enforce ETL design principles, techniques, standards, and best practices
  • Drive the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling.
  • Review and assess existing ETL applications, to support new features, performance improvements, upgrades, and provide ongoing support.
  • Resolve any Application defects or Job abends
  • Work closely with other teams – DBA’s, Network, Storage, Scheduling and User Admin to triage issues and resolve job abends
  • Work on creating steady state deliverables and provide clarifications required for timely Production incident resolution and carrying out
  • On Call Level 2 Production support activities for supported applications
  • Responsible for proof-of-concept of new approaches and ideas, technology evaluation, maintain the As Is data architecture, develop To Be and transition architecture.
  • Self-motivated and ability to work on his/her individual capacity
  • Ability to identify automation opportunities and implement automation

 
Technology: 
Informatica, Syncsort, UNIX, SQL, understanding of Data Warehousing and Data Modelling, Oracle, SQL Server, DB2, , Python
 
 
Education and Experience:
 
Education:    B.Tech Computers/MCA
Experience:  2-4 years in development projects with BI/ DWH background.

Location:

This position can be based in any of the following locations:

Chennai, Gurgaon

Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Industry :
Financial Services
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

Data WarehousingETL (Extract Transform Load)SyncsortInformaticaSparkrData ModelingUnixPL/SQLSQL (Programming Language)Apache HiveTechnical DocumentationPython (Programming Language)SAFe Agile

Other Skills

  • Teamwork
  • Communication
  • Analytical Skills
  • Problem Solving
Are you interested?

Related jobs

See more jobs
Sign in or sign up with Google or LinkedIn