Senior Informatica consultant/developer with extensive experience in data analysis, ETL design and development, conversion from Informatica to IICS (Informatica Intelligent Cloud Services), testing and Support.
Duties:
Design, develop, deploy and support informatica ETL code.
Participating in Requirements and Design discussions with project stakeholders; Develop and document business requirements, impact assessments, process documentation and other related materials; Translate business requirements into ETL specifications
Convert existing Informatica mappings to IICS
Developing and documenting business User Acceptance Test strategies, test plans, and test scenarios
Write scripts to Integrate with Scheduler for automating production runs.
Consume and ingest data from cloud data sources S3 and Snowflake.
Ensure effective communication of user requirements
Create and maintain documentation (e.g., user guides, production Support)
Qualifications:
Strong critical thinking and analytical skills
Effective organization skills with attention to detail
Ability to manage multiple priorities and deadlines
A Bachelors Degree in Computer Science, Business, or related field
7+ years of experience with ETL development and 5+ with informatica
2+ years of experience with Cloud based data sources S3 and Snowflake.
Experience in full life cycle development of enterprise level applications
Proficient with SQL and Unix Scripting
Experience with using Enterprise Schedulers like Autosys, CTRL-M.
Experience in configuring data source connections including ODBC and JDBC