Role: Software Developer
Min Exp: 6+ Years
Salary Range: SGD 8500 - 9500
Key Skills:
· Sound knowledge in Data warehouse concepts
· Data Modeling using IBM Infosphere Data Architect
· ETL Development using Informatica Power Center & Data stage
· Strong SQL scripting knowledge in Oracle, SQL Server & Teradata
· Data Governance using IBM Information Governance Catalog
· Good knowledge in Informatica Intelligent Cloud services
· ETL Testing
· Good Knowledge in Control M & Autosys
· Good knowledge in UNIX
· Machine Learning Algorithms
· Statistical Analysis
· Good understanding in Big data & Hadoop ecosystem
· Strong Knowledge in Agile Methodology
· Stakeholder Management
Key Responsibilities:
· Ability / Experience in different domains: Banking, Telecom and Healthcare. Good knowledge on banking domain especially collections process of the bank.
· Strong experience in entire life cycle of data warehouse projects right from the beginning of requirement gathering, design, development to deployment in production.
· Interacted with users for requirement gathering and prepared functional specifications.
· Strong understanding of Datawarehouse concepts. Have experience in converting the requirements from clients to Logical and physical data models using IBM Infosphere Data Architect
· Strong knowledge in Informatica power center. Have experience in working with different source systems such as oracle, SQL server, XML & flat files (COBOL, csv etc..).
· Strong knowledge on Informatica administration activities like code migration using deployment groups, creating users, folders, purging objects and rebooting the servers etc...
· Strong knowledge in Performance tuning concepts of Informatica.
· Analyzing the threads and identifying the bottlenecks in mapping, increasing the buffer sizes of transformations according to the incoming data etc...
· Strong Knowledge in SQL scripting using SQL server and Oracle.
· Strong knowledge in performance improvement techniques of SQL Queries.
· Helped Client by maintaining the business glossary by Working on data governance activities like creating the business terms, forming the associations to other terms in business glossary, creating the data quality rules (to monitor the data), creating the assets and establishing the lineage using IBM information Governance catalog.
Key Requirements:
· Bachelor's degree in computer science, information technology, or a related field
· At least 8 years of experience and knowledge in Control M, Unix Shell Scripting, and SQL from source code repository, version control, code merge to deployment and housekeeping
· At least 6 years of experience in Hadoop, Hive, HBase, HDFS and Data Engineering
· Ability to multitask effectively and handle large amounts of data
· Highly driven, pro-active and a strong team player
· Excellent interpersonal skills and written and verbal communication skills in English
If interested please send your resume to [email protected] with the following details
1. Total Experience:
2. Notice Period:
3. Current Annual Package (+any AWS / Bonus):
4. Expected Annual Package:
5. Any offers in hand (Y/N):
6. Have exp working in Banking Domain & Data warehouse projects (Y/N):
7. Resident Status (Citizen / SPR / Others):
LION & ELEPHANTS
EA License No: 21S0789
https://lionandelephants.com/lande/