What are the responsibilities and job description for the ETL Developer position at Stratacent?
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 ETLL 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.
- Reusable pyspark code to populate dimension / history tables in data lake.
Skills required :
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 : www.stratacent.com )
Benefits
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.
