Informatica Cloud Developer - EDP

Qualications

• Bachelor's degree in Computer Science, Software Engineering, MIS or equivalent combination of education and experience
• Experience implementing software applications supporting data lakes, data warehouses and data applications on AWS for large enterprises
• Professional with 14+ years of IT experience in Requirement gathering, Design, Development.
• Excellent customer facing experience.
• Worked with AGILE and Onsite-Offshore model.
• Proven experience with Data Modeling, Data Governance, ETL Design, MDM, Data Quality and BI visualization tools.
• Architect, Design and develop Data Governance platform using Informatica DG products Informatica EDC AXON, 
• Experience configuring Informatica Data Governance using EDC and Axon, including business glossaries, dashboards, policies, search, Axon Workflows. Work with MDM, IDQ and Informatica DEI 
• Work with AWS cloud- CloudFormation, IAM, KMS, S3, EC2, VPC, EBS, Athena, Aurora, RDS, DMS, EMR, SNS, SQS, SWF, Glue, Data Pipeline, Snowball, Lambda, Airflow, IAM, CloudFront, Redshift, Data Pipeline, Lambda, Load Balancer, AWS Console, Identity and Access Management, Route 53 and Dynamo DB
• Work with GIT, Snowflake cloud DB, Cloud ETL/ELT, IICS, ANSIBLE, JENKINS and CI/CD process
• Extensively work with Data Governance, MDM, Business Glossary, Metadata management.
• Hands on experience with Software as a Service (SaaS), Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) cloud models. Architect the on-premises data migration to Azure and AWS.
• Work with JIRA, ServiceNow, SharePoint. 
• Have excellent Administration, Installation experience with Informatica Data Governance suite.
• Experience implementing composite services, data mapping and informatica BDM/DEI performance tuning
• Implement INFORMATICA Data Governance using EDC & AXON recommendations & best practices
• Demonstrates expertise with informatica BDM data integration into downstream applications, systems and consumers using various options, and be able to come up with the best suitable option based on project needs
• Translate business needs into master data solutions utilizing process flows and data flow techniques.
• Have good experience with PYSPARK, Spark ETL, SPARK SQL, Data Sets and Data Frames.
• Work with IDQ/BDQ- Address doctor, IDQ/BDQ-Reference tables, IDQ/BDQ Data Profiling.
• Strong Architectural knowledge in Data Management and Data Warehouse/Business Intelligence design and development. Implemented and lead projects at all stages of SDLC. Managed offshore onsite resources.
• Proficient in Data modeling, DWH principles (Inmon and Kimball), SEI-CMM standards of quality assurance. Good 
• Worked with Spotfire-Visualizations, Web Links, Calculated Columns, Custom Expressions, functions and Scripting. Migrate SPOTFIRE reports to Power BI. Have experience with Power BI.

TECHNICAL SKILLS

• ETL Stack: Informatica CAI, B2B Data Exchange, IDQ/BDQ, Power Center, MDM, BDM/DEI, SAP BODS, MS- SSIS, AWS Glue, AWS DataBrew.
• Data Governance: Informatica EDC, AXON
• Hadoop, HIVE, HUE, IMPALA, PYHTON, SPARK, HDFS, Ambari, Oozie, Zookeeper, IMPALA, TEZ, SOLR, HBase, Presto, Elasticsearch, Cassandra and Mongo DB.
• Cloud Data warehouse: Amazon Redshift, Snowflake Database
• Cloud Technologies-AWS: AWS- S3, EC2, VPC, EBS, Athena, Aurora, RDS, DMS, EMR, SNS, SQS, SWF, Glue, Data Pipeline, Snowball, Lambda, Airflow, IAM, KMS, CloudFront, Redshift, Data Pipeline, Lambda, Load Balancer, AWS Console, Identity and Access Management, Route 53 and Dynamo DB.
• Good to have: Data Modeling: OLTP, OLAP (Dimensional Data Model), NOSQL Data Model, Data Vault Modeling, ERWIN, ER Studio, Sybase Power Designer, MS VISIO, ACORD/DAMA-DMBOK2 Principles & Standards
• Good to have: Business Intelligence: POWER BI, TABLEAU
• Programming experience with Python, Shell scripting and SQL
• Experience in system analysis, design, development, and implementation of data ingestion pipeline in AWS
• Knowledge of ETL/ELT
• End-to-end data solutions (ingest, storage, integration, processing, access) on AWS
• Implement high velocity streaming solutions using Amazon Kinesis, SQS, and Kafka (preferred)
• Migrate data from traditional relational database systems, file systems, NAS shares to AWS relational databases such as Amazon RDS, Aurora, and Redshift
• Migrate data from APIs to AWS data lake (S3) and relational databases such as Amazon RDS, Aurora, and Redshift
• Informatica Certified Developer Preferred
• AWS Solutions Architect or AWS Developer Certification preferred

Responsibilties

• Work with Informatica EDC, AXON & AXON Marketplace to build and manage different ingestion patterns for EDP platform
• Experience with Data Governance, Data Quality, data management principles, processes, and systems.
• Work with Data Governance and Metadata management. Develop Impact and Lineage Analysis. Perform Data Profiling. Design Data Lake and load the data to Data Lake using ETL and PYSPARK
• Work with AWS- EC2, VPC, EBS, Athena, Aurora, RDS, DMS, EMR, S3, Redshift. 
• Work with AWS REDSHIFT table design. Use Amazon Redshift Spectrum to Query External Data
• Gather requirements from customers and understanding of master data management concepts
• Have excellent Administration, Installation experience with Informatica Product suite.
• Gather the requirements for creating Data Models, Business Glossary, business terms, policies, business rules
• Participate in the architecture and system design discussions
• Independently perform hands on development and unit testing of the applications.
• Responsible to identify and resolve any performance issues
• Keep up to date with new technology development and implementation
• Participate in code review to make sure standards and best practices are met
• Maintain the documentation for the Architecture & solutions