Key Roles and Responsibilities : Participates in gathering ETL requirements from business analysts and owners to produce requirements documents.
Developing database objects, and creates ETL processes.Creates databases, table spaces, tables, indexes, triggers, procedures, and other database objects.
Helps define the content and structure of the database (schema) and advises users on efficient techniques for extracting data.
Works within defined content and structure of the database (schema)Work with team to implement changes and provide post-implementation user support and system supportLeading & mentoring junior project teamEstimate work content and achieving planned timelinesProvides recommendation and solution including workaround solution to solve problemMaintenance, health check, and application support on client site.
Analyzes, designs, programs, debugs, and modifies software enhancements and / or new products used in local, networked, cloud-based or Internet-related computer programs.
Code may be used in commercial or end-user applications, such as materials management, financial management, HRIS, mobile apps or desktop applications products.
Using current programming language and technologies, writes code, completes programming, and performs testing and debugging of applications.
Completes documentation and procedures for installation and maintenance.May interact with users to define system requirements and / or necessary modifications.
Knowledge, Skills, and Attributes : Excellent trouble shooting skillsAble to work in teamHaving experience in leading a team & projectGood team players and maintain the integrity and display good attention to detailAbility to understand and analyze complex systemsDemonstrated analytical, organizational, and project management skills, using relevant information to make timely and critical decisions that affect cross-functional teamsAbility to handle client and customer issues tactfully and professionallyAcademic Qualifications and Certifications : Bachelor's degree in computer science or software engineeringBachelor Degree in Computer Science or similar fieldsRequired Experience : 4 years of experience developing, maintaining and administering RDBMS including creating and updating scripts, procedures, or queries in SQL2 years of hands on ETL experience with complicated coding and maintenance in any ETL tools (i.
e. Informatica Power Centre, SSIS, Pentaho, etc )Experience with installation, configuration and stabilization of medium- to large-scale ETL systemsExperience with Programming Languages such as C, C++, Java, Python, etc.
or an advanced or equivalent degree without experience; or equivalent work experience.