- Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: IICS Developer/Mclean, VA (Onsite) 6+ months.
Urgent! IICS Developer/Mclean, VA (Onsite) 6+ months Job Opening In McLean Virginia – Now Hiring Suncap Technology, Inc.
Informatica Developer Data Warehousing & ETL
Role is 5 days a week onsite McLean, VA - local candidates only
6+ months
About the Role
We are seeking an experienced Informatica Developer to design, build, and optimize enterprise data integration and data warehouse solutions.
The ideal candidate will have strong expertise in SQL, data warehouse concepts, and data loading/comparison mechanisms to support complex ETL workflows and ensure data accuracy, consistency, and scalability across business-critical systems.
Key Responsibilities
Design, develop, and maintain ETL workflows using Informatica PowerCenter/Cloud to support enterprise data integration needs.
Implement data loading strategies for large-scale structured and semi-structured data.
Develop efficient SQL queries, stored procedures, and performance tuning for optimal data processing.
Work with data warehouse concepts (fact tables, dimension tables, star/snowflake schemas, slowly changing dimensions, partitioning, indexing).
Design and implement data comparison and reconciliation mechanisms to ensure data quality and consistency across systems.
Collaborate with data architects, analysts, and business teams to gather requirements and translate them into technical ETL solutions.
Perform data profiling, cleansing, and validation to support business reporting and analytics.
Optimize ETL pipelines for scalability, performance, and reliability.
Participate in code reviews, debugging, and production support for ETL processes.
Work with version control, CI/CD, and scheduling tools for deployment and automation of data workflows.
What You'll Bring with You
5+ years of experience as an Informatica Developer in enterprise data warehouse environments.
Strong expertise in SQL (Oracle, SQL Server, PostgreSQL, or similar), including performance tuning.
Deep understanding of data warehouse concepts (ETL/ELT, OLAP/OLTP, dimensional modeling, star/snowflake schemas).
Hands-on experience in data loading techniques (incremental loads, CDC, batch, streaming).
Strong knowledge of data comparison and reconciliation mechanisms for validating large data sets.
Experience with ETL performance optimization and error handling.
Familiarity with cloud data platforms (AWS Redshift, Snowflake, Azure Synapse, or GCP BigQuery) is a plus.
Strong problem-solving and debugging skills for ETL and data issues.
Ability to work in Agile teams, collaborating with business and technical stakeholders.
Excellent communication skills with the ability to explain technical solutions to non-technical users.
✨ Smart • Intelligent • Private • Secure
Practice for Any Interview Q&A (AI Enabled)
Predict interview Q&A (AI Supported)
Mock interview trainer (AI Supported)
Ace behavioral interviews (AI Powered)
Record interview questions (Confidential)
Master your interviews
Track your answers (Confidential)
Schedule your applications (Confidential)
Create perfect cover letters (AI Supported)
Analyze your resume (NLP Supported)
ATS compatibility check (AI Supported)
Optimize your applications (AI Supported)
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
European Union Recommended
Institution Recommended
Institution Recommended
Researcher Recommended
IT Savvy Recommended
Trades Recommended
O*NET Supported
Artist Recommended
Researchers Recommended
Create your account
Access your account
Create your professional profile
Preview your profile
Your saved opportunities
Reviews you've given
Companies you follow
Discover employers
O*NET Supported
Common questions answered
Help for job seekers
How matching works
Customized job suggestions
Fast application process
Manage alert settings
Understanding alerts
How we match resumes
Professional branding guide
Increase your visibility
Get verified status
Learn about our AI
How ATS ranks you
AI-powered matching
Join thousands of professionals who've advanced their careers with our platform
Unlock Your IICS Developer Potential: Insight & Career Growth Guide
Real-time IICS Developer Jobs Trends in McLean, Virginia, United States (Graphical Representation)
Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for IICS Developer in McLean, Virginia, United States using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 19736 jobs in United States and 445 jobs in McLean, Virginia. This comprehensive analysis highlights market share and opportunities for professionals in IICS Developer roles. These dynamic trends provide a better understanding of the job market landscape in these regions.
Great news! Suncap Technology, Inc. is currently hiring and seeking a IICS Developer/Mclean, VA (Onsite) 6+ months to join their team. Feel free to download the job details.
Wait no longer! Are you also interested in exploring similar jobs? Search now: IICS Developer/Mclean, VA (Onsite) 6+ months Jobs McLean Virginia.
An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Suncap Technology, Inc. adheres to the cultural norms as outlined by Expertini.
The fundamental ethical values are:The average salary range for a IICS Developer/Mclean, VA (Onsite) 6+ months Jobs United States varies, but the pay scale is rated "Standard" in McLean Virginia. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.
Key qualifications for IICS Developer/Mclean, VA (Onsite) 6+ months typically include Other General and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.
To improve your chances of getting hired for IICS Developer/Mclean, VA (Onsite) 6+ months, consider enhancing your skills. Check your CV/Résumé Score with our free Resume Scoring Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.
Here are some tips to help you prepare for and ace your job interview:
Before the Interview:To prepare for your IICS Developer/Mclean, VA (Onsite) 6+ months interview at Suncap Technology, Inc., research the company, understand the job requirements, and practice common interview questions.
Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Suncap Technology, Inc.'s products or services and be prepared to discuss how you can contribute to their success.
By following these tips, you can increase your chances of making a positive impression and landing the job!
Setting up job alerts for IICS Developer/Mclean, VA (Onsite) 6+ months is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!