Platzhalter Bild

Senior Technical Lead at CSW

CSW · New York, United States Of America · Onsite

$68,000.00  -  $139,700.00

Python

SQL

Microsoft Excel

Apply Now

Skill (Primary)

Data Governance-Master Data Management (MDM)-Informatica Master Data Management (MDM)

Location

New York

Job Family

Development

Employee Group

Business Line FT

Job

Informatica Senior MDM Lead

Job Description (Posting).



Job Title/RoleInformatica Developer
Must Have Skills
  • 10+ years of hands-on experience in ETL development for a data warehouse.
  • 10+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
  • Candidate should have hands on experience working on Informatica power center application upgrade or new installation of the application servers.
  • Experience working with complex SQL and Kimball design methodology
Job Description:
Detailed JD
ROLE SUMMARY
The Informatica Developer will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for an enterprise data warehouse.
ROLE RESPONSIBILITIES
  • Develop new ETL and enhancements and modify existing code using Informatica PowerCenter.
  • Work independently to develop, configure, and unit test programs from specs (source to target mappings).
  • Work closely with data architects, reporting team and application team on ETL development efforts.
  • Design and document ETL solutions for projects, estimate work effort and provide status of tasks.
  • Provide technical support for the administration and production support of Informatica.
  • Provide first and second level troubleshooting, and baseline and operational support.
  • Adhere to best practices and methodologies for ETL development team.
  • Present all work in design and code review sessions to senior team members.
  • Prepare documents that describe, and support code developed.
  • Identify improvements to the data warehouse environment. Work with the team to implement these solutions.
  • Escalate issues to the right party when required.
  • Work closely with the Informatica development team for code migrations on a daily basis, perform other admin activities.
TECHNICAL QUALIFICATIONS
  • 10+ years of hands-on experience in ETL development for a data warehouse.
  • 10+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
  • Candidate should have hands on experience working on Informatica power center application upgrade or new installation of the application servers.
  • Experience working with complex SQL.
  • Expertise with integration technologies and processes.
  • Experience working with Query Surge.
  • Experience with window environment.
  • Possess knowledge of testing tools and techniques.
  • Working knowledge of Kimball design methodology.
GENERAL QUALIFICATIONS
  • Excellent analytical, organization, presentation, and facilitation skills.
  • Possess the ability to handle multiple tasks under tight deadlines.
EDUCATION REQUIREMENTS
  • Bachelor's degree in Computer Science, MIS, related field, or equivalent experience.


 

Entity

CSW

Skill Level 3 (Secondary Skill 1)

Data Science-Advanced Analytics-Python

Skill Level 3 (Secondary Skill 2)

Technical Skills (APPS)-Databases-RDBMS-MS SQL

Skill Level 3 (Secondary Skill 3)

Technical Skills (APPS)-Databases-RDBMS-Oracle PL/SQL
Apply Now

Other home office and work from home jobs

Firmenlogo

Inventory Specialist

Walgreens · Taos, United States Of America

Firmenlogo

Inventory Specialist

Walgreens · Turners Falls, United States Of America

Firmenlogo

Inventory Specialist

Walgreens · Maple Grove, United States Of America