ETL / Informatica Developer (Closed)
SkillStorm is seeking an ETL / Informatica Developer for our client in Charlotte, NC. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.
Required Skills:
- 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
- 5+ years Unix Shell Scripting
- 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
Desired Skills:
- 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
Summary Work:
- 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 addressed
- Understand, modify and explain code placed in various Informatica utilities
- Establishes cost and time estimates for development and implementation of projects
#LI-DNI
Similar Jobs
Business Event Analyst
Contract job in Charlotte
Technical Design Lead
Contract job in Charlotte