Informatica power center with CAI
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.
Never miss an opportunity! Create an alert based on the job you applied for.