SUMMARY:
The candidate must be a self-starter, who can work under general guidelines in a fast-paced work environment. Overall minimum of 7 years of experience in business intelligence / Data Warehousing tools / technologies.
Experience in data integration using IBM Information server 11.x is a must.
RESPONSIBILITIES:
* Able to design and develop data stage (ETL) common data integration templates
* IBM Information server 11.x application administration
* Perform deep technical analysis by reverse engineering exiting business logic embedded in Unix / Perl / Data Stage jobs.
* Work as ETL SME to understand and drive analytical/business requirements
* Prepare detailed ETL design
* Prepare and validate end to end business logic and mappings.
* Develop ETL jobs, prepare unit test cases, test data and perform unit testing
* Code review with Data Integration SME
* Prepare detailed design, architecture, mapping sheet and other ETL documents
* Data Stage code roll and deployment
* Resolve all technical issues raised during SIT/UAT/Warranty phases
* Prepare root cause corrective action document for the ETL issues
* Perform batch support for EDW / AWS jobs on rotation.
REQUIREMENTS:
Industry Name | Experience | Preference
Banking and Brokerage | 3+ Years | Preferred
Industry Function | Experience | Preference
Information Technology | 7+ Years |
Financials, Marketing | 3+ years | preferred
Technology/Business Domain
BI / Data Warehousing | 7+ years | required
Big Data | 2+ years | Preferred
Cloud Technologies (AWS) | 1+ year | Desired
Technology /Application Category | Experience | Preference
Data Integration (ETL) technologies | 7+ Years | required
Hadoop Technologies, OLAP Technologies | 1+ year | preferred
AWS Analytics | 1+ year | preferred
AWS Snowflake | 1+ year | preferred
Azure Analytics | 1+ year | preferred
Azure Snowflake | 1+ year | preferred
Tech/ Product Tools | Experience | Preference
Data Stage (IBM Information Server 11.x) | 6+ Years | required
UNIX / Python Scripting | 5+ years | required
PL / SQL | 6+ Years | Required (Expert Level)SVN, GitHub, Control M / JCL | 3+ years | Preferred
Soft Skills | Preference
Excellent Communication | Required
Excellent Analytical Ability | Required
Special Requirements | Preference
ETL Batch System Support | preferred
EDUCATION, CERTIFICATION, TRAINING:
Minimum bachelor's degree or equivalent to bachelor's in computer science | required