ETL Developer - Fedility

 Competencies/Skills: Individual Contributor Competencies
 
Skills:                    

• 4+ years of hands-on and good experience in ETL tools – Informatica/SyncSort
• Knowledge of tools, concepts and methodologies of BI/DWH.
• Knowledge of Agile Methodology/ SAFe Practices
• 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
• 4+ 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.
•  

• 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.

Technology: 

• Informatica Power Center/ Informatica Cloud/SyncSort, Unix, SVN, Oracle, Python, R programming
• Informatica Certified preferred

 
 
Education and Experience:
 
Education:            B.Tech Computers/MCA
 
Experience:           4 to 6 years in development projects with BI/ DWH background.