**Job Description:** Project Planning, Tracking, & Reporting • Contribute into the initial coding estimates. • Support the team in project planning activities and in evaluating risks. • Communicate regularly with the team about development changes, scheduling, and status. Design • Understand assigned detailed (LLD) design and do code development **Qualifications:** The major responsibility of this role is to do BI & DWH project implementations using ETL tools – Informatica. 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. competencies/Skills: Individual Contributor Competencies Skills: + 2-4 years of hands-on and good experience in ETL tools – Informatica + Knowledge of tools, concepts and methodologies of BI/DWH. + Knowledge of Agile Methodology/ SAFe Practices + Responsible for proof-of-concept of new approaches and ideas, technology evaluation, maintain the As Is data architecture, develop To Be and transition architecture. + Ability to understand the domain and communicate with client/business + Self-motivated and ability to work on his/her individual capacity + Ability to identify automation opportunities and implement automation + 2+ years’ experience in performance tuning of report under high data volumes. + Ability to problem solve and do root cause analysis + Team Player + Customer service orientation. + Ability to understand the domain and communicate with client/business + Self-motivated and ability to motivate others/team + Ability to identify automation opportunities and implement automation + Ability to problem solve and do root cause analysis + Team Player + Customer service orientation. + Basic overview of Absence Management industry and absence terminology + 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 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. + Expertise in shell scripting & SQL Query Writing + Experience in drafting ETL specifications + Understanding and ability to explain development of logical data models + Manage and prioritize enhancements activity by closely working with business and provide regular status reporting + Good understanding of various data models, both relational and dimensional and their associated principles. + Knowledge of governance and metadata management of ETL tools + Vast experience in performance tuning of report under high data volumes. Technology: + Informatica Power Center & Power Exchange/SyncSort/ SSIS/ PIG, Unix, SVN, Oracle, Python, R programming + Informatica Certified preferred **Education and Experience:** Education: B.Tech Computers/MCA Experience: 2 to 8 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** Every day, Guardian helps our 29 million customers realize their dreams through a range of insurance and financial products and services. Our Purpose, to inspire well-being, guides our dedication to the colleagues, consumers, and communities we serve. We know that people count, and we go above and beyond to prepare them for the life they want to live, focusing on their overall well-being — mind, body, and wallet. As one of the largest mutual insurance companies, we put our customers first. Behind every bright future is a GuardianTM. Learn more about Guardian at guardianlife.com .