Strong hands-on experience building ETL pipelines and Data Replication
Hands-on experience on Informatica Intelligent Cloud Services (IICS), Attunity
Hands on with Querying no SQL (Mongo) DB & Snowflake
Hands on with Control M
Knowledge of application development lifecycles, & continuous integration/deployment practice
Experience with AWS EC2, S3, DynamoDB, Metadata Management
Proficient in Agile Software Development methodology, processes, and practices.
Experience Required
Bachelor's degree in computer science or IT, Advanced degree preferred
Minimum Eight (8) years overall current and hands-on development experience with Informatica Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS), Cloud Data Integration (CDI)
Minimum five (5) years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuning
Minimum three (3) years of current and hands-on UNIX shell scripting experience
Minimum three (3) years of current and hands-on scheduler experience (Control-M/Autosys)
Roles & Responsibilities
Consulting with data management teams to get a big-picture idea of the company’s data storage needs.
Presenting the company with warehousing options based on their storage needs.
Designing and coding the data warehousing system to desired company specifications.
Conducting preliminary testing of the warehousing environment before data is extracted.
Extracting company data and transferring it into the new warehousing environment.
Testing the new storage system once all the data has been transferred.
