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 developmentQualifications:

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 – InformaticaKnowledge of tools, concepts and methodologies of BI/DWH.Knowledge of Agile Methodology/ SAFe PracticesResponsible 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/businessSelf-motivated and ability to work on his/her individual capacityAbility to identify automation opportunities and implement automation2+ years’ experience in performance tuning of report under high data volumes.Ability to problem solve and do root cause analysisTeam PlayerCustomer service orientation.Ability to understand the domain and communicate with client/businessSelf-motivated and ability to motivate others/teamAbility to identify automation opportunities and implement automationAbility to problem solve and do root cause analysisTeam PlayerCustomer service orientation.Basic overview of Absence Management industry and absence terminologyEstablish, 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 sustainmentSupport on-going ETL environment and support during maintenance or failureWork closely with ETL migration/ network teams and DBA’s on operational failures and triage issues.Expertise in shell scripting & SQL Query WritingExperience in drafting ETL specificationsUnderstanding and ability to explain development of logical data modelsManage and prioritize enhancements activity by closely working with business and provide regular status reportingGood understanding of various data models, both relational and dimensional and their associated principles.Knowledge of governance and metadata management of ETL toolsVast experience in performance tuning of report under high data volumes.

Technology: 

Informatica Power Center & Power Exchange/SyncSort/ SSIS/ PIG, Unix, SVN, Oracle, Python, R programmingInformatica 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