What are the responsibilities and job description for the IICS Developer position at Stratacent?
Job Location: Mclean, VA/Dallas TX (Hybrid)
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:
- 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.
