Business Intelligence / Data Management

LOCAL CANDIDATES ONLY 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 | Required Financials, Marketing | 3+ years | preferred Technology/Business DomainBI / Data Warehousing | 7+ years | required Big Data | 2+ years | Preferred Cloud Technologies (AWS) | 1+ year | Desired Technology /Application Category | Experience | PreferenceData Integration (ETL) technologies | 7+ Years | requiredHadoop Technologies, OLAP Technologies | 1+ year | preferredAWS Analytics | 1+ year | preferred AWS Snowflake | 1+ year | preferredAzure Analytics | 1+ year | preferredAzure Snowflake | 1+ year | preferredTech/ Product Tools | Experience | PreferenceData Stage (IBM Information Server 11.x) | 6+ Years | requiredUNIX / Python Scripting | 5+ years | requiredPL / SQL | 6+ Years | Required (Expert Level)SVN, GitHub, Control M / JCL | 3+ years | PreferredSoft Skills | PreferenceExcellent Communication | RequiredExcellent Analytical Ability | RequiredSpecial Requirements | PreferenceETL Batch System Support | preferred

EDUCATION, CERTIFICATION, TRAINING: Minimum ba

This role requires that all successful applicants be fully vaccinated against COVID-19 as a condition of the engagement and provide proof of such vaccinations within 3 days of commencement of services