bigstock-Technology-Background-Modern--4

Search Jobs

Informatica Data Engineer

East Hartford, CT 06108

Posted: 01/23/2025 Industry: ENGINEER Job Number: 195086

Job Description

Informatica Data Engineer

Works with client management to identify and specify business requirements and processes for diverse development platforms, computing environments e.g., host based, distributed systems, client server, software, hardware, technologies and tools. Formulates logical statements of business problems and devises, tests and implements efficient, cost effective application program solutions e.g., codes and or reuses existing code through the use of program development software alternatives and or integrates purchased solutions.  Works independently, receives minimal guidance. Acts as a resource for colleagues with less experience. Solves complex problems takes a new perspective using existing solutions.


Responsibilities

  • Participate in team agile tasks and sessions such as story estimation, sprint planning demonstrations, and retrospectives.
  • Establishes IDQ environments (Dev, Staging & Test) according to project requirements
  • Design and develop data quality rules to evaluate and verify data transformations; update ETL scripts and data mappings to improve data migration activities using Informatica, Oracle, SQL, and other technologies.
  • Evaluate legacy databases and ERD's to determine high confidence data quality and best transformation strategies to next generation data model
  • Support data traceability, integrity and validation documentation along with ETL code, data dictionaries, profiles and script repository management.
  • Work closely with Data Architects and Test Specialist to verify business rules and develop test plans and test scripts for data validation.
  • Establish a portal for data analysts and customer to evaluate data anomalies /exceptions and data migration verifications.
  • Develop reports to display validation and review progress; in addition to generating data cleansing and exception management reports.
  • Work effectively with teammates; collaborate on shared work products and related tasks to ensure best solution derived.
  • Expertise in Informatica (v.9/10) Data Quality (IDQ), Oracle RDBMS
  • Bachelor’s Degree or an equivalent combination of education and training that provides the required knowledge, skills and abilities.
  • Strong interpersonal skills


Qualifications/ Skills


BS degree with 4+ years in SQL experience and 5+ years overall hands on Informatica Data Quality (IDQ) development experience. 

Strong understanding on Data Profiling / Data Analyst tool. 

Skilled and experienced in Informatica ETL tool suite including PowerCenter designer, workflow, monitoring and repository services. 

Proficient with Informatica ETL Integration using Teradata, Oracle, Mainframe, and SQL Server databases. 

Understanding of reusability, parameterization, and workflow design concepts. 

Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members. 

Strong Programing and SQL skills 

Informatica Admin experience is a plus.


Excellent oral and written communication and interpersonal skills. 

Strong organizational, multi-tasking, and time-management skills preferred. 

Ability to work independently or within a team for problem resolution. 

Strong knowledge of Microsoft Office tool set. 

Additional Information

HKA Enterprises is a global workforce solutions firm. If you're seeking a new career opportunity or project experience, our recruiters will work to understand your qualifications, experience, and personal goals. At HKA, we recognize the importance of matching employee goals with those of the employer. We strive to seek credibility, satisfaction, and endorsement from all of our applicants. We invite you to take time and search for your next career experience with us! HKA is an EEO Employer who participates in the US Citizenship and Immigration Services E-Verify Program.

Meet Your Recruiter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About East Hartford, CT

Discover exciting job opportunities in the vibrant area around East Hartford, Connecticut! Nestled in the heart of New England, this picturesque region offers a perfect blend of historic charm and modern opportunities. With renowned landmarks like the Mark Twain House and Museum, delicious cuisines ranging from classic lobster rolls to farm-to-table delights, and cultural venues like the Wadsworth Atheneum Museum of Art and the Hartford Stage, East Hartford provides a rich tapestry of experiences for job seekers. Explore career openings in this dynamic region, where growth meets charm. Your next career move awaits in East Hartford!