Hands on , Design ( HLD and LLD) and implementation of an operational data store and data warehouse on one of the leading database platforms (e.g., Netezza,MySQL , Oracle)
Able to manage onsite and offshore teams and collaborate with stakeholders, development teams, and QA
Review development and test specifications
Implement, standardize and optimize ETL processes using Informatica Powercenter ETL( 9.1 / 9.5)
Ability to conduct discovery, perform root cause analysis, and make recommendations for the remediation of data quality issues
Troubleshoot data and/or system issues; create/maintain batch jobs; create systems documentation
Perform data analysis and identify data related issues as needed
Requirements:
8+ years of Solid experience with Informatica ETL tool ( 9.1 or 9.5)
Strong SQL skills and should be able to write SQL to compare and reconcile source and target databases.
Strong in Unix
Experience in large data warehouse implementations is a must
Experience in managing onsite and offshore teams or global delivery center model
Excellent interpersonal and communication skills; presents technically complex concepts in a way to foster understanding and acknowledgement of critical information
Exercises wide latitude in determining objectives and approaches to critical assignments
Must have excellent verbal and written communications skills, with an ability to express complex technical concepts in business terms
Must have excellent client-facing skills; solid teamwork and interpersonal skills; strong ability to work independently when appropriate
Develops solutions to problems of unusual complexity which require a high degree of ingenuity, creativity and innovation
Adapts and makes departures from traditional methods or approaches to develop solutions by evaluating a balanced risk based approach to support business objectives
Advises the company’s Enterprise Business Intelligence management and customers on advanced technical issues and provides technical expertisewithin the company in the areas of Business Intelligence , Analytics , Data warehousing and Master Data Management
Interacts and/or negotiates effectively with external and/or internal customers at all levels
Education:
MS/BS degree in a computer science field or related discipline