Data Integration Engineer_ Analytics As a Service - Specialist -Operate

Minimum Year(s) of Experience (BQ) *: US 

Minimum of 1 year of experience 

Certification(s) Preferred: 

Preferred Skills (PQs): 

Required Skills: 

Informatica Power Center, SQL/PL-SQL 

Job description: 

Candidate is expected to demonstrate extensive knowledge and/or a proven record of success in the following areas:  

• Should have minimum 1+ year of Operate/Managed Services/Production Support Experience  

• Should have extensive experience in developing scalable, repeatable, and secure data structures and pipelines to ingest, store, collect, standardize, and integrate data for downstream consumption like Business Intelligence systems, Analytics modeling, Data scientists etc.  

• Designing and implementing data pipelines to extract, transform, and load (ETL) data from various sources into data storage systems, such as data warehouses or data lakes.  

• Should have experience in building efficient ETL/ELT processes using Informatica Power center 

• Should have Hands-on experience with Data analytics tools like Informatica, SSIS, Alteryx etc. 

• Design, implement, and maintain data pipelines for data ingestion, processing, and transformation in Informatica. 

• Work together with data scientists and analysts to understand the needs for data and create effective data workflows. 

• Collaborate with cross-functional teams to understand requirements and implement solutions 

• Participate in data modeling and data migration tasks as per client requirements to efficiently build analytics implementation 

• Implementing data validation and cleansing procedures will ensure the quality, integrity, and dependability of the data. 

• Improve the scalability, efficiency, and cost-effectiveness of data pipelines. 

• Monitoring and troubleshooting data pipelines and resolving issues related to data processing, transformation, or storage.  

• Implementing and maintaining data security and privacy measures, including access controls and encryption, to protect sensitive data  

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases  

• Should have experience in Building and maintaining Data Governance solutions (Data Quality, Metadata management, Lineage, Master Data Management and Data security) using industry leading tools  

• Should have Hands-on experience with Data analytics tools like Informatica, Collibra, Hadoop, Spark, Snowflake etc.  

• Should have Experience of ITIL processes like Incident management, Problem Management, Knowledge management, Release management, Data DevOps etc.  

• Should have Strong communication, problem solving, quantitative and analytical abilities. 

Nice to have: 

• Informatica Power center certification