Job Description
Mandatory skills: Informatica ETL, SQL, AWS, Snowflake
Job Summary
We are seeking an experienced Informatica ETL Lead with 10+ years of expertise in designing, developing, and implementing enterprise-scale data integration and ETL solutions. The ideal candidate should possess strong hands-on experience with Informatica PowerCenter, data warehousing, SQL, and ETL architecture, along with the ability to lead a team and collaborate effectively with business and technical stakeholders.
Key Responsibilities
Required Skills
Preferred Skills
Leadership Expectations
Educational Qualification
Job Summary
We are seeking an experienced Informatica ETL Lead with 10+ years of expertise in designing, developing, and implementing enterprise-scale data integration and ETL solutions. The ideal candidate should possess strong hands-on experience with Informatica PowerCenter, data warehousing, SQL, and ETL architecture, along with the ability to lead a team and collaborate effectively with business and technical stakeholders.
- Lead the design, development, and support of ETL solutions using Informatica PowerCenter.
- Analyze business requirements and translate them into scalable ETL and data integration solutions.
- Design and implement complex mappings, workflows, sessions, and reusable components.
- Lead ETL development teams and perform code reviews to ensure adherence to best practices.
- Optimize ETL processes for performance, scalability, and reliability.
- Work closely with business analysts, data architects, and stakeholders to define data integration strategies.
- Troubleshoot and resolve ETL production issues while ensuring minimal business impact.
- Support data migration, data quality, data governance, and modernization initiatives.
- Collaborate with offshore/onshore teams and provide technical leadership throughout the project lifecycle.
- Prepare technical design documents, deployment plans, and operational runbooks.
- 10+ years of IT experience with strong expertise in ETL and Data Warehousing.
- 8+ years of hands-on experience with Informatica PowerCenter.
- Strong experience in ETL design, development, and performance tuning.
- Extensive experience with SQL, query optimization, and database performance tuning.
- Experience with relational databases such as:
- Oracle
- SQL Server
- Teradata
- Snowflake (preferred)
- Strong understanding of Data Warehousing concepts, including:
- Star Schema
- Snowflake Schema
- Fact and Dimension Modeling
- Slowly Changing Dimensions (SCD)
- Experience with scheduling tools such as Control-M or equivalent.
- Excellent troubleshooting and root-cause analysis skills.
- Strong communication and stakeholder management skills.
Preferred Skills
- Experience with Informatica IICS (Intelligent Cloud Services).
- Experience with cloud platforms such as AWS, Azure, or GCP.
- Exposure to data lake and modern data platform architectures.
- Experience with Agile/Scrum methodologies.
- Knowledge of data governance and data quality frameworks.
Leadership Expectations
- Lead and mentor ETL development teams.
- Drive technical discussions with customers and business stakeholders.
- Provide effort estimations and technical solution recommendations.
- Ensure delivery quality and adherence to project timelines.
Educational Qualification
- Bachelor s degree in computer science, Information Technology, Engineering, or a related field.
- Informatica certifications will be an added advantage.
Numbers & Facts
| Location | Richmond, VA (Remote) |
| Industry | Computer Software |
| Company Size | 20 to 49 employees |
| Year Founded | 2014 |
| Website | http://www.tekfortune.com/ |
About Company
Tekfortune is a software solutions company providing project development and staff augmentation services to companies in various industries including Healthcare, Banking, Finance, Telecommunication and Aviation.
Tekfortune Inc delivers solutions to a wide variety of organizations of various sizes and industries. Our clients include mid-market to Fortune 1000 companies spanning across industries such as: Insurance, Financial, Pharmaceutical, Manufacturing, Retail and many others.
In Tekfortune Inc, we are offering selection of services and solutions at very reasonable rates. With years of experience in the placement and recruitment Industry and over time we have acquired the knowledge essential to comprehend the exact need and dependence on customers. Therefore we provide the customers the best and also the brightest candidates for vacancies. Moreover, by understanding the working interest of customers who is able to place them within the companies where they are able to get maximum opportunity for professional growth.
Tekfortune Inc has a strong emphasis on quality. Its goal would be to achieve client satisfaction by looking into making deliveries satisfaction of customer's business needs. Our ability to quickly identify and effectively employ proven fundamental principles, techniques and resources yields highly desirable results for our clients.
We understand that each industry and organization share a level of uniqueness that requires a tailored approach in order to deliver specific solutions. Such factors as client culture, industry regulations, organizational maturity, financial health and many more items may impact our approach to delivering client solutions.
Having served a wide variety of clients has provided Tekfortune the ability to build subject matter expertise across numerous industries. Our industry expertise combined with our specialized knowledge of Business Process Improvement, Requirements Management and Program & Project Management provides a powerful combination and a tremendous value to our clients.
We are run by a group of industry experts who have decades of experience in delivering custom solutions to our clients.
Tekfortune Inc delivers solutions to a wide variety of organizations of various sizes and industries. Our clients include mid-market to Fortune 1000 companies spanning across industries such as: Insurance, Financial, Pharmaceutical, Manufacturing, Retail and many others.
In Tekfortune Inc, we are offering selection of services and solutions at very reasonable rates. With years of experience in the placement and recruitment Industry and over time we have acquired the knowledge essential to comprehend the exact need and dependence on customers. Therefore we provide the customers the best and also the brightest candidates for vacancies. Moreover, by understanding the working interest of customers who is able to place them within the companies where they are able to get maximum opportunity for professional growth.
Tekfortune Inc has a strong emphasis on quality. Its goal would be to achieve client satisfaction by looking into making deliveries satisfaction of customer's business needs. Our ability to quickly identify and effectively employ proven fundamental principles, techniques and resources yields highly desirable results for our clients.
We understand that each industry and organization share a level of uniqueness that requires a tailored approach in order to deliver specific solutions. Such factors as client culture, industry regulations, organizational maturity, financial health and many more items may impact our approach to delivering client solutions.
Having served a wide variety of clients has provided Tekfortune the ability to build subject matter expertise across numerous industries. Our industry expertise combined with our specialized knowledge of Business Process Improvement, Requirements Management and Program & Project Management provides a powerful combination and a tremendous value to our clients.
We are run by a group of industry experts who have decades of experience in delivering custom solutions to our clients.
Skills
- Agile Programming Methodologiesunmatched
- Amazon Web Services (AWS)unmatched
- Analysis Skillsunmatched
- Best Practicesunmatched
- Business Analysisunmatched
- Cloud Computingunmatched
- Code Reviewsunmatched
- Communication Skillsunmatched
- Computer Scienceunmatched
- Data Lakeunmatched
- Data Migrationunmatched
- Data Qualityunmatched
- Data Warehousingunmatched
- Database Extract Transform and Load (ETL)unmatched
- Database Optimizationunmatched
- Design Documentunmatched
- Documentation Planunmatched
- Enterprise Data Integrationunmatched
- GCP (Good Clinical Practices)unmatched
- Identify Issuesunmatched
- Informaticaunmatched
- Information Technology & Information Systemsunmatched
- Leadershipunmatched
- Maintain Complianceunmatched
- Mentoringunmatched
- Microsoft SQL Serverunmatched
- Microsoft Windows Azureunmatched
- NCR Teradataunmatched
- Offshoringunmatched
- Operations Planningunmatched
- Oracleunmatched
- Performance Tuning/Optimizationunmatched
- Problem Solving Skillsunmatched
- Process Improvementunmatched
- Project Lifecycleunmatched
- Query Optimizationunmatched
- Relational Databases (RDBMS)unmatched
- Requirements Managementunmatched
- Root Cause Analysisunmatched
- SQL (Structured Query Language)unmatched
- Scrum Project Management and Software Developmentunmatched
- Snowflake Schemaunmatched
- Star Schemaunmatched
- Team Lead/Managerunmatched
- Technical Leadershipunmatched
- Technical Writingunmatched
- Technical/Engineering Designunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder