Kforce

Informatica ETL Data Analyst/Developer

3+ months agoCharlotte, NC

Responsibilities

Kforce has a client in search of a Informatica ETL Data Analyst/Developer in Charlotte, NC.Responsibilities:

  • Develop complex workflows and mappings using Informatica ETL and shell scripts to satisfy the business requirements
  • Designing and developing ETL solutions using Informatica that follow the in-house ETL development standards; managing program coding for the extraction of data from all existing source systems, transforming data to industry standards and generating extract files
  • Create and maintain documentation of the physical and logical data models; data dictionaries; and ETL processes via process flow diagrams
  • Establishing testing/quality assurance environments; working with technical teams and system to ensure that programs and modifications are error free


Skills

  • 8-10 years' experience working in an enterprise class production data warehouse environment with at least 5+ years of Informatica ETL development
  • Strong Hands on experience in all aspects of Data Warehousing / Business Intelligence design implementations which Involves Data Model designs for Relational and Dimensional methodologies ( logical & physical, Star & Snowflake Schemas), Data Quality, Data Mining, Data Governance, ETL Architecture ,and Design and End user access tools ( OLAP Tools)
  • Solid experience in process and workflow tuning
  • Extensive experience in design, develop, maintaining and production support for Data Warehouses and Data Marts using ETL tools like Informatica PowerCenter
  • Experienced in testing, debugging and performance tuning of any ETL bottlenecks. Very large Database and DW implementation experience (20 TBs)
  • Experience on designing new solutions for the project Strong understanding of data warehousing concepts, schemas, Slowly Changing Dimensions, Facts and Dimensions
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Kforce is a professional staffing services firm offering Technology and Finance & Accounting jobs with top employers nationwide. We specialize in providing contract, contract-to-hire and direct placement opportunities, with over 50 years of experience in the staffing industry. Kforce offers many consultants comprehensive benefits depending on employment status, including medical, dental, 401(K), life insurance and disability. Our vision is to be "the firm most respected by those we serve."