Must have Advanced knowledge of Oracle SQL, PL/SQL and Experience in Oracle supplied packages, Dynamic SQL, collections, Records and PL/SQL Tables.
Must Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Must have Advanced knowledge of Big Data Talend and experience on Talend components like tHive*, Thdfs*,tOracle* tFilterRow,tAggregateRow, tMap, tNormalize, tDenormalize, tSortRow, tSampleRow, tFilelist and tReplicate, tOracleInput, tOracleOutput, tOracleConnection, tOracleOutputBulkExec etc.
Good technical skills in UNIX shell scripting and scheduling
**Responsibilities**:
- Create development standards based on Talend best practices / experience and lead other
developers in implementation of these standards.
- Mentoring other developers who have less experience in Talend / Big Data
- Support solution architect by leading ELT architecture design based on Talend and Big Data best
practices / experience.
- Coordinating with BAs / Mappers and Project Management in planning change requests / defect
fixes during project implementation and BAU phases
- Advising BAs / Mappers on how mappings would be efficiently implemented in code to ensure
optimal design.
- Provide and develop production grade Talend Big Data jobs with considerations on meeting the
IT organization's architecture standards.
- Work closely with data modelers/ system analysts on the required data interface/ requirement
specifications
- Conduct technical session/ clarification with data modelers and sub-system teams' prior solution
design, coding, and unit testing.
- Document and review design of Talend Big Data jobs and interface specification
- Implement error and exception handling.
- Import jobs to Talend Data Catalogue
- Integrate Talend jobs with Autosys and restart failed jobs from Autosys.
- Perform technical impact assessment, source code release and deployment checklist.
- Validate built conformance to required specifications.
- Support SIT and UAT activities e.g., perform defect analysis, troubleshooting and fixing.
- Coordinate and support Performance and Security Testing activities e.g., environment setup and
test scope
- Coordinate with infrastructure team on deployment and related activities.
- Provide enhancement and production support after project go live.
- Takes accountability in considering business and regulatory compliance risks and takes
appropriate steps to mitigate the risks.
- Maintains awareness of industry trends on regulatory compliance, emerging threats, and
technologies in order to understand the risk and better safeguard the company.
- Highlights any potential concerns /risks and proactively shares best risk management practices.
Skills requirements
- Bachelor's degree in Information Technology/Computer Science/Programming & Systems
Analysis or related course
- Talend Big Data version 7+ Developer experience: To have 3-5 years working experience
deploying code to production.
- Advanced knowledge of Oracle SQL, PL/SQL and Experience in Oracle supplied packages,
Dynamic SQL, collections, Records and PL/SQL Tables.
- Experience in developing Complex database objects like Stored Procedures, Functions, Packages
and Triggers using SQL and PL/SQL.
- Advanced knowledge of Big Data Talend and experience on Talend components like tHive*,
Thdfs*, tOracle*, tFilterRow, tAggregateRow, tMap, tNormalize, tDenormalize, tSortRow,
tSampleRow, tFilelist and tReplicate, tOracleInput, tOracleOutput, tOracleConnection,
tOracleOutputBulkExec etc.
- Good technical skills in UNIX shell scripting and scheduling.
- 3+ years working experience of Hadoop (Hortonworks) developer experience in Spark and Hive;
especially Spark version 2
- 4 years of Data Warehousing experience
- 2+ years of experience in Talend Big Data version 7 on Hadoop
- Experience designing Talend job orchestration through enterprise workload automation tool like
Control-M; preferably Autosys.
- Working knowledge of Hortonworks data platform for data ingestions frameworks from multiple
source systems e.g. AS400, Oracle Finance, MS SQL, etc.
- Development experience using Java, PL/SQL, SQL, Python, Scala with good knowledge of data
models and data flows with strong understanding of dimensional and relational databases,
including stored procedures, constraints, normalization, indexes and security.
- Insurance and financial reporting domain knowledge will be an advantage.
- Talend Big Data Integration and Big Data (Hadoop) developer certifications
- High level of integrity takes accountability of work and good attitude over teamwork.
- Knowledge of computing, software design, use of parameterization, database and security
concepts.
- Good communication, collaboration, analytical and Problem-solving skills.
- Good knowledge of best practices of data related or coding disciplines.
- Familiar with regulatory, security and industry guidelines
**Experience**:
- Talend: 3 years (requ