Apply Now

Informatica Lead

Hybrid in Dallas, TX, US • Posted 2 hours ago • Updated 2 hours ago

Contract W2

12 Months

No Travel Required

Hybrid

$50 - $54/hr

K-Tek Resourcing LLC

Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

Informatica PowerCenter
Informatica Lead
ETL
PL/SQL
SQL
Oracle
SQL Server
DB2
PostgreSQL
Data Integration
Data Warehousing
Data Modeling
Dimensional Modeling
Star Schema
Snowflake Schema
Source to Target Mapping (STTM)
Performance Tuning
Database Design
Data Quality
Agile
SDLC
Banking
Financial Services
Production Support
Release Management
Team Leadership
Informatica Workflows
Mapplets
Sessions
Data Migration

Summary

Job Title: Informatica Lead

Location: Dallas, TX / Pittsburgh, PA (Hybrid – 3 Days Onsite)
Rate: $50–54/hr
Industry: Banking & Financial Services (BFS)

Job Description

We are seeking a highly experienced Informatica Lead with 15+ years of IT experience to lead enterprise-scale ETL, data integration, and data warehousing initiatives. The ideal candidate will possess deep expertise in Informatica PowerCenter, PL/SQL, Data Modeling, and Enterprise Data Integration while providing technical leadership to onsite and offshore teams.

This role requires a hands-on technical leader who can design scalable ETL solutions, optimize database performance, and collaborate with business stakeholders, architects, and development teams to deliver high-quality data solutions.

Key Responsibilities

Lead end-to-end design, development, testing, deployment, and support of Informatica-based ETL solutions.
Design and develop complex Informatica mappings, mapplets, sessions, workflows, and reusable components.
Translate business requirements into scalable ETL workflows, source-to-target mappings, and database designs.
Develop and optimize PL/SQL packages, stored procedures, functions, triggers, views, and complex SQL queries.
Design logical and physical data models, relational tables, indexes, constraints, and dimensional models.
Collaborate with business analysts, data architects, DBAs, QA, and application teams to deliver enterprise data integration solutions.
Lead onsite and offshore development teams through code reviews, mentoring, design reviews, and delivery planning.
Troubleshoot ETL, database, performance, and production issues while implementing long-term solutions.
Optimize Informatica workflows and SQL queries for performance, scalability, and maintainability.
Support Data Warehouse, Data Mart, Operational Data Store, and Reporting initiatives.
Participate in Agile ceremonies, sprint planning, backlog refinement, and release planning.
Prepare technical design documents, deployment guides, data mapping documents, and production support documentation.
Ensure adherence to SDLC, Agile methodologies, data governance, and enterprise coding standards.

Required Qualifications

15+ years of IT experience in Data Integration, ETL Development, and Data Warehousing.
Strong hands-on experience with Informatica PowerCenter and related Informatica tools.
Expert-level PL/SQL and advanced SQL development experience.
Strong knowledge of relational database design, normalization, indexing, partitioning, and performance tuning.
Hands-on experience with Data Modeling, Dimensional Modeling, Star Schema, and Snowflake Schema.
Experience with Oracle, SQL Server, DB2, PostgreSQL, or similar relational databases.
Expertise in Source-to-Target Mapping (STTM), ETL design patterns, data validation, reconciliation, and batch processing.
Experience leading onsite/offshore development teams.
Strong understanding of SDLC, Agile methodologies, release management, and production support.
Excellent communication, leadership, analytical, and stakeholder management skills.

Preferred Skills

Experience with enterprise data warehouse modernization initiatives.
Banking or Financial Services domain experience.
Experience working with distributed Agile teams.
Strong documentation and technical leadership experience.

If you''re an experienced Informatica Lead with strong ETL, database, and leadership expertise, we''d like to hear from you!

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10411276
Position Id: 9046185
Posted 2 hours ago

Company Info

About K-Tek Resourcing LLC

Vision

To be a trusted partner and advisor to our customers

Mission

At K-Tek we believe in understanding the specific needs of the customer and tailor-creating innovative solutions to meet these needs. We invest in our employees and customers. We build a relation of trust with our customers through empathy, solutions and being the first time right.

Who We Are & What We Do

K-Tek Resourcing is a consulting organization with offices in Houston TX and St. Paul, MN. It is supported by 2 global delivery centers, located in India. With its global employee strength of over 250, K-Tek has been supporting its clients for over 9 years. We have been consistently achieving a growth of 30% Year on Year. We have an extensive experience of working in domains including BFSI, Retail, Healthcare and Pharma, Oil & Gas, Travel & Hospitality and Insurance. The technologies we service are IT Infrastructure, Mobile Technologies, Cloud & Big Data Solutions. We understand the needs of our customers and provide them with customized solutions and resources with the tenet of being the "First Time Right".

Values

-Commitment to our customers success through Integrity

-Excellence through Quality

-Growth through customer value creation

Go to company profile

Contact the job poster

Darpan Gome

Recruiter @ K-Tek Resourcing LLC

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior Business Analyst

Hybrid in Dallas, Texas

•

13d ago

<>Note: Candidates must be willing to work on W2 only. We are considering candidates with 7+ years of experience only (minimum 7 years required). Must be able to work on direct W2.Hello,I hope this message finds you well. My name isNitesh, and I am a Recruiter withK-Tek Resourcing LLC, a trusted U.S. staffing company with over a decade of experience in talent acquisition. We are currently hiring for the following position: Job Title:Sr. Business Analyst Work Model:Hybrid Job SummaryWe are lookin

Easy Apply

Full-time

Depends on Experience

Search all similar jobs

More jobs at K-Tek Resourcing LLC in Dallas, TX