We are storming the marketplace with the highly skilled, experienced, and certified professionals that businesses need.

Find your perfect job.

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