Find the matching job for you with ease

The demand for skilled ETL developers is soaring as companies race to turn raw data into actionable insights. With data pipelines becoming the backbone of modern analytics, mastering ETL tools opens doors to high-impact projects. This role offers a chance to work onsite in the heart of Manhattan, collaborating with seasoned data engineers. # Job Summary We are seeking an ETL Developer to design, develop, and maintain data integration workflows using industry‑leading tools such as Informatica PowerCenter, Talend, and SSIS. The candidate will work with relational databases (Oracle, SQL Server, PostgreSQL), apply data‑modeling techniques, and ensure high‑quality data delivery for reporting and analytics. # Top 3 Critical Skills Table | Skill | Why it's critical | Mastery Level | |-------|-------------------|---------------| | SQL / PL‑SQL | Core language for querying and transforming data in relational databases. | Senior | | ETL Tools (Informatica, Talend, SSIS) | Enables design, execution, and maintenance of robust data pipelines. | Senior | | Data Modeling (Star & Snowflake schemas) | Structures data for efficient reporting and analytics. | Mid | # Interview Preparation **1. How do you design an efficient ETL workflow using Informatica PowerCenter?** *What the interviewer is looking for:* Understanding of mapping design, source‑to‑target transformations, performance tuning (partitioning, pushdown optimization), and handling incremental loads. **2. Explain the differences between Star and Snowflake schemas and when you would choose each.** *What the interviewer is looking for:* Ability to discuss normalization vs. denormalization, query performance implications, and suitability for different reporting scenarios. **3. Describe a situation where you optimized a slow‑running SSIS package. What steps did you take?** *What the interviewer is looking for:* Practical experience with buffer size tuning, parallel execution, use of fast‑load options, and monitoring tools. **4. How would you handle data quality issues (nulls, duplicates) during the ETL process?** *What the interviewer is looking for:* Knowledge of data cleansing techniques, use of lookup/cache transformations, and implementation of error‑handling workflows. **5. Compare Talend Open Studio with Informatica PowerCenter in terms of scalability and licensing.** *What the interviewer is looking for:* Awareness of open‑source vs. commercial licensing, cluster execution capabilities, and cost‑benefit considerations. # Resume Optimization - SQL - PL/SQL - Informatica PowerCenter - Talend - Microsoft SSIS - Data Warehousing - Data Modeling - Star Schema - Snowflake Schema - Oracle Database - SQL Server - PostgreSQL # Application Strategy When reaching out to the recruiter, send a concise email greeting, attach your updated resume, and clearly highlight your top skills that match the role. Make sure to mention related skills you possess, such as SQL/PL‑SQL, hands‑on experience with Informatica or Talend, and data‑modeling expertise. Reference any recent projects where you built or optimized ETL pipelines, and express enthusiasm for contributing to the team in Manhattan. # Career Roadmap | Current Role | Typical Experience | Core Focus | Next Position | |--------------|--------------------|------------|---------------| | ETL Developer | 2‑4 years building and maintaining data pipelines | ETL design, performance tuning, data modeling | Senior ETL Developer | | Senior ETL Developer | 5‑7 years leading complex integrations, mentoring junior staff | Architecture of large‑scale data flows, cross‑system integration | ETL Architect / Data Integration Lead | | ETL Architect | 8+ years shaping data strategy, overseeing enterprise‑wide pipelines | End‑to‑end data platform governance, technology roadmap | Director of Data Engineering |

The banking sector is rapidly embracing data‑driven decision making, making skilled Data Analysts more valuable than ever. Companies are seeking professionals who can turn complex datasets into actionable insights, especially with modern cloud tools. This W2 Data Analyst role offers a chance to apply your banking knowledge while working on‑site in the vibrant Washington, DC metro area. # Job Summary We are looking for a detail‑oriented Data Analyst with strong banking experience to design, build, and maintain analytical solutions using Python, SQL, Snowflake, Databricks, Tableau, and AWS. The role is on‑site in McLean/Richmond, VA and requires translating business requirements into robust data pipelines and visual dashboards that support strategic decisions. # Top 3 Critical Skills Table | Skill | Why it's critical | Mastery Level | |-------|-------------------|--------------| | Python | Enables data cleaning, automation, and advanced analytics. | Senior | | SQL | Core language for querying relational data and Snowflake warehouses. | Senior | | Snowflake | Cloud data warehouse that scales banking datasets efficiently. | Mid | # Interview Preparation 1. **Explain how you would design an end‑to‑end data pipeline for daily transaction data using Python and Snowflake.** *What the interviewer is looking for:* Understanding of ETL concepts, data modeling, and cloud warehouse best practices. 2. **Write a SQL query to identify customers with transactions exceeding $10,000 in the last 30 days.** *What the interviewer is looking for:* Proficiency in window functions, date handling, and performance‑aware querying. 3. **How would you optimize a Tableau dashboard that is loading slowly for large banking datasets?** *What the interviewer is looking for:* Knowledge of data extracts, filter optimization, and visualization performance tuning. 4. **Describe a scenario where you used AWS services (e.g., S3, Redshift, Lambda) to support a data analytics project.** *What the interviewer is looking for:* Practical experience with cloud infrastructure and integration patterns. 5. **What are the key compliance and security considerations when handling sensitive banking data in Snowflake?** *What the interviewer is looking for:* Awareness of data encryption, role‑based access, and regulatory standards (e.g., PCI‑DSS). # Resume Optimization - Data Analyst - Banking industry - Python - SQL - Snowflake - Databricks - Tableau - AWS - On‑site - W2 employment # Application Strategy When reaching out to the recruiter, send a concise email that greets the hiring manager, briefly mentions the role you’re applying for, and attaches your updated resume. Explicitly highlight your banking analytics experience, your proficiency with Python and SQL, and any projects where you built Snowflake or Tableau solutions. Mention two‑to‑three of the listed skills (e.g., Python, Snowflake, Tableau) to show a direct match with the job requirements. # Career Roadmap | Current Role | Typical Experience | Core Focus | Next Position | |--------------|-------------------|------------|---------------| | Data Analyst | 0‑2 years | Banking data extraction, reporting, visualization | Senior Data Analyst | | Senior Data Analyst | 3‑5 years | Advanced analytics, model development, stakeholder partnership | Data Analytics Manager | | Data Analytics Manager | 5‑8 years | Team leadership, strategy, cross‑functional initiatives | Director of Analytics |

The demand for robust, high‑performance Java applications is soaring as businesses modernize their digital platforms. Companies are seeking developers who can build scalable back‑end systems that power everything from fintech to e‑commerce. This role offers a chance to work on critical projects for a respected client while sharpening your expertise in modern Java frameworks. # Job Summary We are hiring a Java Developer to design, develop, and maintain high‑performance, scalable back‑end applications. The ideal candidate will have solid experience in Java, backend development, and modern frameworks such as Spring or similar. Responsibilities include writing clean code, optimizing performance, collaborating with cross‑functional teams, and ensuring the reliability of production systems. # Top 3 Critical Skills Table | Skill | Why it's critical | Mastery Level | |-------|-------------------|--------------| | Java | Core language for all development tasks and performance tuning | Senior | | Spring Framework (or similar) | Enables rapid development of robust, enterprise‑grade services | Senior | | RESTful API design | Allows integration with front‑end and third‑party services at scale | Mid | # Interview Preparation 1. **Explain how you would design a high‑throughput Java service to handle 10,000 requests per second.** *What the interviewer is looking for:* Understanding of concurrency, thread pools, non‑blocking I/O, and performance profiling. 2. **Describe the difference between `HashMap` and `ConcurrentHashMap` and when you would use each.** *What the interviewer is looking for:* Knowledge of thread‑safety, synchronization overhead, and appropriate use‑cases. 3. **Walk me through the lifecycle of a Spring Bean and how you would configure it for lazy initialization.** *What the interviewer is looking for:* Depth of Spring framework knowledge and bean management. 4. **How do you implement pagination in a REST API while keeping the response fast and lightweight?** *What the interviewer is looking for:* Experience with query optimization, limit/offset, and possibly cursor‑based pagination. 5. **Give an example of a performance bottleneck you encountered in a Java application and how you resolved it.** *What the interviewer is looking for:* Real‑world debugging skills, profiling tools (e.g., JVisualVM, YourKit), and optimization techniques. # Resume Optimization - Java - Spring Framework - RESTful APIs - Backend Development - High‑Performance Applications - Scalable Architecture - Object‑Oriented Design - Microservices - Hibernate/JPA - Unit Testing (JUnit/TestNG) # Application Strategy When reaching out to the recruiter, send a concise email greeting them by name, attach your resume, and reference the role explicitly. Highlight your top skills—such as Java, Spring, and RESTful API development—mention relevant projects where you built scalable back‑end services, and map your experience directly to the key requirements listed in the JD. Keep the tone professional and express enthusiasm for contributing to CTS's client initiatives. # Career Roadmap | Current Role | Typical Experience | Core Focus | Next Position | |--------------|-------------------|------------|---------------| | Java Developer | 2‑4 years | Build and maintain Java services | Senior Java Developer | | Senior Java Developer | 4‑7 years | Lead complex projects, mentor juniors | Lead Engineer / Tech Lead | | Lead Engineer | 7‑10 years | Architecture, cross‑team coordination | Engineering Manager | | Engineering Manager | 10+ years | Strategy, people management, budgeting | Director of Engineering |

The demand for seasoned Business Analysts is soaring as organizations modernize their digital workflows and integrate complex systems. This role in Columbia, SC offers a hands‑on opportunity to drive critical State DOT initiatives and work directly with stakeholders on real‑world integrations. If you’re a US‑based professional with strong API and process‑mapping expertise, this position is a perfect fit. # Job Summary We are seeking an experienced Business Analyst to support a State Department of Transportation PMO initiative. You will analyze and document business processes, lead system integration and data‑flow analysis, gather detailed functional requirements (BRDs, User Stories, RTMs), and collaborate with stakeholders to ensure successful UAT, testing, and implementation. The position is fully onsite in Columbia, SC and runs for at least 12 months with possible extension. # Top 3 Critical Skills Table | Skill | Why it's critical | Mastery Level | |---|---|---| | Business Process Analysis | Enables clear documentation of current and future state workflows for the DOT PMO | Senior | | API & System Integration | Drives data exchange between legacy and modern platforms, a core project deliverable | Senior | | Requirements Gathering (BRDs, User Stories) | Translates stakeholder needs into actionable specifications for development and testing | Senior | # Interview Preparation 1. **Question:** Describe your approach to mapping a complex business process and translating it into a BPMN diagram using Visio or Lucidchart. **What the interviewer is looking for:** Ability to break down intricate workflows, use visual tools effectively, and communicate the process clearly to technical and non‑technical audiences. 2. **Question:** How have you handled API integration projects where data consistency and latency were major concerns? **What the interviewer is looking for:** Experience with API design principles, error handling, performance monitoring, and collaboration with development teams. 3. **Question:** Walk us through a time you authored a BRD and User Stories that were later used for UAT. What challenges did you face? **What the interviewer is looking for:** Skill in requirement articulation, traceability, stakeholder alignment, and ability to anticipate testing needs. 4. **Question:** Explain how you manage stakeholder expectations when scope changes occur mid‑project. **What the interviewer is looking for:** Communication tactics, change‑control processes, and negotiation skills. 5. **Question:** What techniques do you use to validate data flows during system integration testing? **What the interviewer is looking for:** Knowledge of data mapping, validation scripts, reconciliation methods, and defect tracking. # Resume Optimization - Business Analyst - Business Process Mapping - API Integration - Data Flow Analysis - BRD (Business Requirements Document) - User Stories - RTM (Requirements Traceability Matrix) - Visio - Lucidchart - Stakeholder Management # Application Strategy When reaching out to the recruiter, send a concise email that opens with a friendly greeting, attaches your resume, and clearly highlights your top relevant skills. Make sure to mention related skills you possess, such as API integration, requirements gathering, and process mapping, and reference specific projects where you applied these abilities. Emphasize that you are currently located in South Carolina and meet the citizenship requirements. # Career Roadmap | Current Role | Typical Experience | Core Focus | Next Position | |---|---|---|---| | Business Analyst (Advanced) | 5+ years | Process analysis, integrations, stakeholder management | Senior Business Analyst | | Senior Business Analyst | 7‑10 years | Strategic alignment, solution design | Lead Business Analyst | | Lead Business Analyst | 10+ years | Portfolio oversight, mentorship | Director of Business Analysis | | Director of Business Analysis | 12+ years | Organizational strategy, governance | VP of Business Operations |

The demand for skilled QA Engineers who can navigate complex testing tools and geospatial data is soaring as companies push digital transformation. This remote QA Engineer role offers a chance to work with cutting‑edge technologies like QTP, GIS, GPS, and CRM systems while enjoying the flexibility of a home‑based setup. If you have a solid testing background and can hit the ground running, this contract gig could be your next big break. # Job Summary We are looking for a contract QA Engineer to design, execute, and maintain automated test suites using QTP and other tools. The role focuses on validating road‑mapping, GPS, GIS, ESP, and CRM applications, ensuring data integrity and functional reliability for remote users. # Top 3 Critical Skills Table | Skill | Why it's critical | Mastery Level | |-------|-------------------|--------------| | QTP (QuickTest Professional) | Core automation framework for functional testing of the applications | Senior | | GIS / GPS Integration | Validates geospatial data accuracy crucial for road and location‑based services | Senior | | CRM Systems | Ensures business workflows and customer data are error‑free | Mid | # Interview Preparation 1. **How do you design a QTP test script for a GIS‑based application?** *What the interviewer is looking for:* Understanding of object repositories, handling dynamic map objects, and data‑driven testing techniques. 2. **Explain how you would validate GPS coordinate accuracy in an automated test.** *What the interviewer is looking for:* Knowledge of coordinate validation, tolerance thresholds, and integration with external data sources. 3. **Describe your experience with DBT (Data Build Tool) in a QA context.** *What the interviewer is looking for:* Ability to orchestrate data transformations, run tests on data pipelines, and ensure data quality. 4. **What strategies would you use to test CRM workflows that involve road‑mapping features?** *What the interviewer is looking for:* End‑to‑end scenario planning, mock data creation, and verification of business rules. 5. **How do you handle test environment setup for remote testing of ESP (Enterprise Service Platform) modules?** *What the interviewer is looking for:* Experience with containerization, CI/CD pipelines, and environment isolation. # Resume Optimization - QA Engineer - QTP - DBT - GIS - GPS - ESP - CRM - Automated Testing - Remote Testing - Data Validation # Application Strategy When reaching out to the recruiter, send a concise email that starts with a friendly greeting, attaches your updated resume, and clearly highlights your top skills. Make sure to mention related skills you possess, such as **QTP automation**, **GIS data validation**, and **CRM workflow testing**, and reference any relevant projects where you applied these technologies. # Career Roadmap | Current Role | Typical Experience | Core Focus | Next Position | |--------------|-------------------|------------|---------------| | QA Engineer (Contract) | 2‑4 years in test automation and GIS/CRM domains | Test script development, data validation, tool integration | Senior QA Engineer | | Senior QA Engineer | 5‑7 years, leading test strategy, mentoring juniors | End‑to‑end test architecture, cross‑functional collaboration | QA Lead / Test Manager | | QA Lead / Test Manager | 8‑10+ years, overseeing multiple projects | Test governance, process improvement, stakeholder communication | Director of Quality Assurance |

Mainframe environments are the backbone of many large enterprises, and demand for skilled testers who can bridge legacy systems with modern cloud practices is soaring. Companies are eager to modernize their mainframe applications while ensuring zero‑downtime, making this role both challenging and highly visible. This contract offers a chance to work onsite with a seasoned team and showcase your expertise in DB2 and ERP/CRM testing. # Job Summary We are seeking a Mainframe Tester to design, develop, and maintain test suites for mainframe‑based applications. The role involves functional and integration testing of DB2 databases, ERP/CRM modules, and collaborating with cross‑functional teams to resolve production issues. You will also contribute to best‑practice documentation and support cloud‑enabled testing initiatives. # Top 3 Critical Skills Table | Skill | Why it's critical | Mastery Level | |-------|-------------------|--------------| | Mainframe DB2 | Core data store for legacy apps; ensures data integrity across transactions. | Senior | | ERP/CRM Testing | Directly impacts business processes; requires deep functional knowledge. | Senior | | Cloud Technologies (AWS/Azure) | Enables hybrid testing environments and modern CI/CD pipelines. | Mid | # Interview Preparation 1. **Explain how you would design a test case for a DB2 transaction involving roll‑back scenarios.** *What the interviewer is looking for:* Understanding of ACID properties, rollback handling, and test data setup. 2. **Describe your experience integrating functional test suites with Agile sprint cycles.** *What the interviewer is looking for:* Ability to align testing with Scrum ceremonies, story points, and continuous feedback. 3. **How do you approach performance testing for ERP modules on a mainframe?** *What the interviewer is looking for:* Knowledge of load generators, transaction monitoring, and bottleneck analysis. 4. **What steps would you take to migrate a legacy mainframe test environment to AWS?** *What the interviewer is looking for:* Familiarity with cloud migration strategies, networking, and security considerations. 5. **Give an example of a defect you discovered in production and how you documented the resolution.** *What the interviewer is looking for:* Problem‑solving rigor, clear documentation, and communication with stakeholders. # Resume Optimization - Mainframe - DB2 - ERP testing - CRM testing - Functional testing - Java - Agile - Scrum - AWS - DevOps # Application Strategy When reaching out to the recruiter, send a concise email greeting, attach your updated resume, and explicitly highlight your top skills that match the role. Make sure to mention related skills you possess, such as **Mainframe DB2**, **ERP/CRM functional testing**, and **cloud‑enabled testing**. Reference any relevant projects where you applied these technologies and demonstrate how you can add immediate value. # Career Roadmap | Current Role | Typical Experience | Core Focus | Next Position | |--------------|--------------------|------------|---------------| | Mainframe Tester | 8+ years | DB2, ERP/CRM, functional testing | Senior Mainframe Tester | | Senior Mainframe Tester | 10‑12 years | Test strategy, automation, mentorship | Mainframe Test Lead | | Mainframe Test Lead | 12‑15 years | Cross‑team coordination, CI/CD integration | Testing Manager | | Testing Manager | 15+ years | Portfolio oversight, stakeholder management | Director of QA |

The world of scalable, event‑driven applications is exploding as businesses move to real‑time data processing. Senior Java developers who master Spring Boot, microservices, and big‑data tools like Spark are in high demand. This role offers a chance to lead cutting‑edge projects on AWS while shaping architecture for high‑throughput systems. # Job Summary We are seeking a seasoned Senior Java Developer to design, build, and maintain high‑performance backend services. The role focuses on Java 11+, Spring Boot microservices, event‑driven architectures using Kafka, and large‑scale data processing with Apache Spark/PySpark. You will collaborate with front‑end teams (Angular), DevOps, and data engineers to deliver end‑to‑end solutions on AWS. # Top 3 Critical Skills Table | Skill | Why it's critical | Mastery Level | |---|---|---| | Advanced Java (Java 11+) | Core language for building robust, high‑performance services | Senior | | Spring Boot & Microservices | Enables rapid development and deployment of scalable services | Senior | | Apache Spark (and PySpark) | Powers large‑scale data processing and event‑driven pipelines | Senior | # Interview Preparation 1. **Design a microservice that consumes Kafka streams and processes data using Spark. What are the key considerations for fault tolerance and exactly‑once semantics?** *What the interviewer is looking for:* Understanding of Kafka consumer groups, offset management, Spark Structured Streaming checkpoints, and strategies to achieve idempotency. 2. **Explain how you would containerize a Spring Boot application and deploy it on AWS EKS. Which AWS services would you integrate for CI/CD?** *What the interviewer is looking for:* Knowledge of Docker, Kubernetes manifests, Helm charts, and AWS services like CodePipeline, CodeBuild, and IAM roles. 3. **Compare and contrast relational (RDBMS) and NoSQL databases for storing event data. When would you choose one over the other?** *What the interviewer is looking for:* Ability to discuss consistency, scalability, query patterns, and trade‑offs between systems such as PostgreSQL vs. DynamoDB or MongoDB. 4. **Walk through a scenario where you need to migrate a database schema using Flyway in a CI/CD pipeline. How do you ensure zero downtime?** *What the interviewer is looking for:* Experience with versioned migrations, backward‑compatible scripts, blue‑green deployments, and automated testing. 5. **How does Angular interact with a Spring Boot backend in a microservices environment? Describe best practices for authentication and data transfer.** *What the interviewer is looking for:* Familiarity with REST/GraphQL APIs, JWT/OAuth2 security, CORS handling, and efficient payload design. # Resume Optimization - Java (Java 11+) - Spring Boot - Microservices Architecture - Apache Spark / PySpark - Kafka (Streaming) - AWS (EC2, EKS, S3, IAM, VPC) - Angular 13+ - RDBMS & NoSQL databases - Git version control - CI/CD (Jenkins, Flyway) # Application Strategy When reaching out to the recruiter, send a concise email that starts with a friendly greeting, briefly introduces yourself, and states your interest in the Senior Java Developer role. Attach your updated resume and be sure to highlight your top relevant skills—such as Advanced Java, Spring Boot microservices, and Apache Spark—and cite specific projects where you used these technologies. Mention any experience with AWS, Kafka, and Angular to demonstrate a full‑stack fit. End the email by expressing enthusiasm for a conversation and providing your contact details. # Career Roadmap | Current Role | Typical Experience | Core Focus | Next Position | |---|---|---|---| | Senior Java Developer | 8‑12 years, full‑stack backend, cloud | Architecture, performance, mentorship | Lead Java Engineer | | Lead Java Engineer | 12‑15 years, team leadership, tech strategy | End‑to‑end system design, cross‑team coordination | Engineering Manager | | Engineering Manager | 15+ years, people management, delivery | Portfolio ownership, stakeholder alignment | Director of Engineering | | Director of Engineering | 18+ years, organizational leadership | Vision, budgeting, multi‑discipline oversight | VP of Engineering |

Model risk management is becoming a cornerstone for financial institutions as regulators tighten oversight on predictive models. Companies are actively seeking analysts who can bridge business requirements with technical model governance. This MRM Tech Analyst role in New York offers a chance to shape model lifecycle processes while working with cutting‑edge Python and SQL code. # Job Summary We are looking for a senior‑level MRM Technical Analyst to partner with business stakeholders, translate regulatory requirements into user stories, review Python/SQL model code, and support end‑to‑end model governance, inventory, and validation workflows. # Top 3 Critical Skills Table | Skill | Why it's critical | Mastery Level | |-------|-------------------|--------------| | Model Risk Management (MRM) | Ensures regulatory compliance and model governance | Senior | | Python programming | Enables code review and automation of model workflows | Senior | | SQL data querying | Supports validation, inventory, and data analysis tasks | Senior | # Interview Preparation 1. **How do you translate regulatory requirements into technical specifications for model risk management?** *What the interviewer is looking for:* Ability to map compliance rules to user stories, familiarity with documentation standards, and clear stakeholder communication. 2. **Describe your process for reviewing and validating Python model code.** *What the interviewer is looking for:* Knowledge of code quality metrics, testing frameworks, and how to identify model‑risk issues. 3. **What steps would you take to maintain a model inventory and ensure its accuracy over time?** *What the interviewer is looking for:* Understanding of inventory management tools, version control, and periodic validation procedures. 4. **Can you give an example of a complex stakeholder management situation you handled?** *What the interviewer is looking for:* Communication skills, conflict resolution, and ability to align technical solutions with business goals. 5. **How would you design a user story for a new model validation workflow?** *What the interviewer is looking for:* Structured storytelling, acceptance criteria definition, and alignment with regulatory expectations. # Resume Optimization - Model Risk Management - MRM - Python - SQL - Business Analyst - Stakeholder Management - User Stories - Model Governance - Model Validation - Regulatory Compliance # Application Strategy When reaching out to the recruiter, send a concise email greeting, attach your tailored resume, and explicitly highlight your top skills. Make sure to mention related skills you possess, such as Model Risk Management, Python, and stakeholder communication, and reference specific projects where you applied these competencies. # Career Roadmap | Current Role | Typical Experience | Core Focus | Next Position | |--------------|--------------------|------------|---------------| | MRM Tech Analyst | 8+ years in BA & MRM | Model governance, Python/SQL code review | Senior MRM Analyst | | Senior MRM Analyst | 10‑12 years | Lead validation projects, mentor juniors | MRM Lead | | MRM Lead | 12‑15 years | Strategy, cross‑team coordination, risk frameworks | MRM Manager | | MRM Manager | 15+ years | Portfolio oversight, regulatory liaison | Director of Model Risk Management |