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
