Stratacent · 1 day ago
ETL Developer
McLean, VA
Full-time
Onsite
Mid LevelStratacent is an IT Managed Services firm, headquartered in Jersey City, NJ, focusing on Financial Services, Insurance, Healthcare and Life Sciences. The ETL Developer will modernize data ingestion patterns within a financial customer's data platform, requiring expertise in ETL and data lake concepts within the AWS ecosystem.
Big DataInformation TechnologyDatabase
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
Qualification
Required
Bachelor's degree in computer science or equivalent is required
IICS is a must
Informatica PowerCenter background is required
Multiple years programming experience
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
Preferred
Dataflux exposure in reading code is good to have
Broad understanding of general business and management practices is preferred
Benefits
Health Insurance
Vision Plan
Dental Plan
Health Saving Account (HSA)
Paid Time Off and Vacations
401K Plan
Continuous Learning Program
Company
Stratacent
Stratacent is an IT managed services company with an emphasis in data driven solutions.
Founded in 2012
201-500 employees
H1B Sponsorship
Stratacent has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (2)
2023 (8)
2022 (5)
2021 (5)
2020 (14)
Funding
Current Stage
Growth StageLeadership Team
Amit Arya
Founder & CEO
Company data provided by crunchbase