Job Requirements:
• 2-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