Title/Position: IICS ETL Developer Job Location: (Onsite-Mclean, VA/Dallas TX) Duration: Contract Role Client- Stratacent Open for c2c and w2 both Relocation is also fine.  Skills Experience (in Years) Logistics Comments Total Experience Work Authorization Informatica Current Location IICS Notice Required to Join CAI/CDI Currently working API Integration Pyspark Reason of job change Snowflake LinkedIn profile 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.