Demo

IICS ETL Developer

Stratacent
Mc Lean, VA Full Time
POSTED ON 3/18/2025
AVAILABLE BEFORE 5/18/2025

Job Details

Stratacent is seeking an experienced ETL developer for one of our project with a financial customer to help modernize their existing data ingestion patterns within their data platform. This modernization entails thorough understanding of ETL and data lake concepts within AWS ecosystem. Prior experience working on building transformations utilizing IICS and pyspark are required.
Responsibilities :

  • Work with internal SMEs to understand overall data architecture in scope for project deliverables.
  • Understand all existing integration points within the AWS ecosystem, in scope for project deliverables e.g. Step functions, Dynamo DB, Glue.
  • Work with internal support teams Analyze existing ETL process written using Talend and PySpark.
  • Develop in scope transformations using Pyspark and IICS.
  • Perform Unit testing and assist code promotion to higher environments for user testing.
  • Create reusable code for API component (reading from API endpoints):
  • Reusable IICS CAI process to retrieve json/xml data from multiple endpoints.

Skills required:

  • Bachelor's degree in computer science or equivalent is required.
  • Dataflux exposure in reading code is good to have.
  • IICS is a must.
  • Informatica PowerCenter background is required
  • Multiple years programming experience. Broad understanding of general business and management practices is preferred.
  • Complete understanding of all phases of the software development life cycle.
  • Expert Knowledge of application design principles, systems development and analysis.
  • Advanced Informatica design and development skills using Informatica power center and power exchange.
  • Experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
  • Experience using parameter files, parameters/variables and troubleshooting using advanced informatica techniques like session partitioning, push down optimization etc.
  • Must be well versed with all Unix commands needed for running ETL jobs as well as for troubleshooting source and target files.
  • Prior experience in AGILE environment.


About Us
Stratacent is an IT Managed Services firm, headquartered in Jersey City, NJ, with two global delivery centers and offices in New York City, India, London and Canada.
We are a leading IT services provider focusing in Financial Services, Insurance, Healthcare and Life Sciences. We help our customers in their digital transformation journey and provide solutions around Cloud Services, Automation, Data and Analytics, Application Development, IT Service Management and Cyber Security.
We have partnerships with AWS, Azure, Google Cloud Platform, Automation Anywhere, Snowflake and SAS.
(To learn more: )
Benefits

  • Health Insurance
  • Vision Plan
  • Dental Plan
  • Health Saving Account (HSA)
  • Paid Time Off and Vacations
  • 401K Plan
  • Continuous Learning Program

Stratacent is an equal opportunity employer. As such, to the extent defined by federal, state, and municipal law, Stratacent will not discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, age, sex, national origin, ancestry, handicap, or any other factor protected by law.

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.

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a IICS ETL Developer?

Sign up to receive alerts about other jobs on the IICS ETL Developer career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$91,609 - $116,575
Income Estimation: 
$115,838 - $142,817
Income Estimation: 
$114,981 - $143,201
Income Estimation: 
$68,745 - $88,154
Income Estimation: 
$87,428 - $116,878
Income Estimation: 
$91,609 - $116,575
Income Estimation: 
$91,609 - $116,575
Income Estimation: 
$115,838 - $142,817
Income Estimation: 
$114,981 - $143,201
Income Estimation: 
$151,182 - $194,086
Income Estimation: 
$190,942 - $250,988
Income Estimation: 
$114,981 - $143,201
Income Estimation: 
$129,640 - $165,363
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Stratacent

Stratacent
Hired Organization Address Woodbridge, NJ Full Time
Job Title : Implementation Specialist I Job Type - Contract (Potential to Convert to FTE at Client Site) Location -Iseli...
Stratacent
Hired Organization Address Jersey, NJ Full Time
Title/Position: QA Lead Job Location: Pune Experience: 10 Years Employment Type: Full Time Shift Timings: UK Shift Respo...
Stratacent
Hired Organization Address Mc Lean, VA Full Time
Title: Cloud Data Engineer Location: Mclean, VA/Dallas, TX (Hybrid) Duration: Fulltime (W2) Required Skills: Pyspark han...
Stratacent
Hired Organization Address Jersey, NJ Full Time
Title/Position: HR Administrator Job Location: Jersey City NJ - Hybrid Employment Type: Full Time Stratacent is seeking ...

Not the job you're looking for? Here are some other IICS ETL Developer jobs in the Mc Lean, VA area that may be a better fit.

IICS Developer

Stratacent, Mc Lean, VA

Senior Informatica IICS Developer

Kanor Systems, Mc Lean, VA

AI Assistant is available now!

Feel free to start your new journey!