Vacancy expired!
Job Description:
- Ability to create Informatica mapping and workflows for maximum performance, stability based on system resource
- Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices
- Responsible for providing technical guidance / solutions, and documenting processes and coding
- Perform data analysis and data profiling against source systems and data warehouse
- Design ETL processes using Informatica Power Center
- Test solutions to validate whether requirements have been met
- Provide end-user support in UAT and post-deployment phases; assess and evaluate all the feedback to ensure that the requirements necessary to correct issues are addresse
- Understand, modify and explain code placed in various Informatica utilities
- Establishes cost and time estimates for development and implementation of projects
- 5+ years Unix Shell Scripting
- College graduate in Computer Science or related field
- 7+ years in Informatica 10.x or later
- 7+ years with Relational Databases - Oracle 11g, 12c, SQL Server 2012-2016
- 7+ years writing Complex SQL Queries and performance tuning
- 7+ years in Data Mapping, Data Modeling, Data Mining, and Data Warehousing/Mart
- Problem solving skills and ability to think algorithmically
- Strong analytical and organizational skills
- Solid understanding of the Agile processes, requirement gathering, analysis/design, development tools /technologies, release/version control and deployment management
- Full understanding of SQL, cardinality, levels of granularity, normalized vs de-normalized, handling of slowly changing dimensions, auditing, and optimizations techniques is required
- 3+ years working with SSIS
- Other BI Tools with Business Objects, ECM; Archival experience a plus
- Strong leadership and analytical/design skills
- Knowledge and experience with Hadoop
- 4+ years interacting with the customers/business analysts in gathering requirements and independently able to design and deliver the Informatica Mappings
- Experience working with offshore, co-ordination and oversight of deliverables
Vacancy expired!