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 to working 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 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