Data Management Engineer II

Job Requirements:

• 1-4 years of work experience

• Excellent analytical, organizational, and problem-solving and skills

• Has mature written and verbal communication skills, as well as presentation skills.

• Ability to work independently and collaborate with others at all levels of technical understanding

• Self-motivated and dedicated with the ability to triage and prioritize technical issues, work with team members to problem resolution

• Ability to plan and carry out responsibilities with some direction

• Ability to quickly learn new systems and business processes and adapt to changing technology and priorities

• Experience in coordinating with data stewards and analysts to understand business requirements, functional requirements, and conversion of business rules into technical specifications

• Experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions and ETL data pipelines

• Experience in various programming languages like Java and Python, orchestration tools and processes or other directly related experience.

• Hands on experience in database and table design, proficient in writing complex SQLs, expertise in performance tuning of SQLs

• Excellent knowledge of the Informatica platform as a whole and the integration among different Informatica components and services

• Good experience in end-to-end implementation of DW & BI projects, especially in data warehouse and mart developments

• Experience in Relational Modeling, Dimensional Modeling, Modeling of Unstructured Data and business process relationships

• Good understanding of Data integration, Data quality paradigms and data governance/ data architecture concepts

• Working knowledge in handling various web services and APIs (Soap, REST)

• Working experience on Informatica Cloud Services (IDMC) development; Cloud Data Integration (CDI), Cloud Application Integration (CAI), Cloud Data Quality CDQ and CDGC

• Experience in ETL design and development using Informatica PowerCenter, Data Quality, and Data Engineering using various transformations, and ETL design/development methodologies.

• Experience developing profiles and scripts for the execution and testing of mappings and workflows to implement data stewardship and exception processing

• Full lifecycle project experience as a developer in designing and developing ETL jobs.

• Knowledge of UNIX/Linux shell scripting, scheduling and orchestration tools and processes.

• Good understanding of XML/Json structures.

• Experience working in Agile framework and project management methodologies

• Knowledge of data analysis in AWS environment (Athena, Redshift, S3, Sagemaker, EMR) is a plus

• Knowledge of Python libraries (Pandas, Numpy, Plotly, Pyspark, Sklearn) is a plus

• Knowledge of using Change Data Capture methodologies is a plus

• Knowledge of data analysis in Azure platform (Data Factory/Synapse/etc.) is a plus

• Experience working with Power BI in data analytics space is a plus.

• Experience with Big data technologies is a plus