AEM Architect

Responsibilities:

• Design, implement, and maintain scalable and reliable database solutions on the AWS platform.
• Architect, deploy, and optimize DynamoDB databases for performance, scalability, and cost-efficiency.
• Configure and manage AWS OpenSearch (formerly Amazon Elasticsearch Service) clusters for real-time search and analytics capabilities.
• Design and implement data processing and analytics solutions using AWS EMR (Elastic MapReduce) for large-scale data processing tasks.
• Collaborate with cross-functional teams to gather requirements, design database solutions, and implement best practices.
• Perform performance tuning, monitoring, and troubleshooting of database systems to ensure high availability and performance.
• Develop and maintain documentation, including architecture diagrams, configurations, and operational procedures.
• Stay current with the latest AWS services, database technologies, and industry trends to provide recommendations for continuous improvement.
• Participate in the evaluation and selection of new technologies, tools, and frameworks to enhance database capabilities.
• Provide guidance and mentorship to junior team members, fostering knowledge sharing and skill development.

Requirements:

• Bachelor’s degree in computer science, Information Technology, or related field.
• Proven experience as an AWS Architect or similar role, with a focus on database technologies.
• Hands-on experience designing, implementing, and optimizing DynamoDB databases in production environments.
• In-depth knowledge of AWS OpenSearch (Elasticsearch) and experience configuring and managing clusters for search and analytics use cases.
• Proficiency in working with AWS EMR (Elastic MapReduce) for big data processing and analytics.
• Strong understanding of database concepts, data modelling, indexing, and query optimization.
• Experience with AWS services such as S3, EC2, RDS, Redshift, Lambda, and CloudFormation.
• Excellent problem-solving skills and the ability to troubleshoot complex database issues.
• Solid understanding of cloud security best practices and experience implementing security controls in AWS environments.
• Strong communication and collaboration skills with the ability to work effectively in a team environment.
• AWS certifications such as AWS Certified Solutions Architect, AWS Certified Database - Specialty, or equivalent certifications are a plus.

Good experience in the Extraction, Transformation, and Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager,

Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Connect as ETL tool on Oracle, and SQL Server Databases.

 Knowledge of Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations teamed with

project scope, Analysis, requirements gathering, data modeling, ETL Design, development,

System testing, Implementation, and production support.

 Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts

and Dimensions

 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,

Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

 Developed mapping parameters and variables to support SQL override.

 Created applets to use them in different mappings.

 Created sessions, configured workflows to extract data from various sources, transformed data,

and loading into the data warehouse.

 Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

 Modified existing mappings for enhancements of new business requirements.

 Involved in Performance tuning at source, target, mappings, sessions, and system levels.

 Prepared migration document to move the mappings from development to testing and then to

production repositories

 Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex

SQL queries using PL/SQL.

 Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica

/Talend sessions as well as performance tuning of mappings and sessions.

 Experience in all phases of Data warehouse development from requirements gathering for the

data warehouse to develop the code, Unit Testing, and Documenting.

 Extensive experience in writing UNIX shell scripts and automation of the ETL processes using

UNIX shell scripting.

 Experience in using Automation Scheduling tools like Control-M.

 Hands-on experience across all stages of Software Development Life Cycle (SDLC) including

business requirement analysis, data mapping, build, unit testing, systems integration, and user

acceptance testing.

 Build, operate, monitor, and troubleshoot Hadoop infrastructure.

 Develop tools and libraries, and maintain processes for other engineers to access data and write

MapReduce programs.

-Should have experience in Creating and managing Liferay Portal themes

-Need to have experience working with JAVA technologies

-Excellent oral and written communication skills with a keen sense of customer service

-Excellent problem-solving and troubleshooting skills

-Process-oriented with great documentation skills.

-Should have knowledge of DXP

• Define and ensure visual and brand consistency
• Design user interaction models, workflows, and user interfaces for cross-device experiences
• Work closely with developers to ensure designs are built accurately to spec
• Share and present workflows, wireframes, and designs across multiple teams
• Research and benchmark latest UX/UI designs and standard practices across mobile and web
• Design logos, icons, flyers, pamphlets, and other marketing material
• Proficient in creating high and low fidelity prototypes

Desired Skills and Experience:

• Exceptional design skills, with acute attention to detail
• A great Portfolio that communicates a clean and up to date visual design sense
• Strong working knowledge of Adobe Creative Suite/Photoshop
• Ability to take a product concept from wireframe to high fidelity design mocks
• Understand the visual and the functional aspects of Web/Mobile design
• Understanding of newest tools and trends in UI/UX
• Creative problem-solving skill
• should be familiar with in addition to Photoshop: Balsamiq, Invision, Sketch, and Zeplin.
• Apply with your detailed portfolio on the dribble, Behance, etc

Key Skill Set 

• Working knowledge of Marketing Cloud and Salesforce CRM. 4- 6 years of experience in marketing analytics and proven track record of solving marketing use cases.
• Expert on Marketing Cloud – Journey builder, content builder, email studio, social studio and automation studio.
• Knowledge in Marketing cloud connector, data extensions, APU integration with external systems.
• Knowledge of HTML/CSS and AMPscript.
• Understanding of data analysis, trend spotting and technology in Digital space.
• Strong written & verbal communication skills.
• Skilled in problem solving, planning, as well as being able to adapt to new environments.
• Marketing Cloud Certification is a Plus.

Key Responsibility Areas:

• Implement B2C marketing journeys and communications via Salesforce Marketing Cloud.
• Design Customer Journeys and automations using Journey builder and automation studio.
• Design, proof-read, send and monitor campaigns.
• Drive Personalization.
• A/B Testing.
• Build analytics reports and dashboards to provide visibility into marketing campaigns, email/sms results and measure effectiveness.
• Analyze, listen and plan actions on various social media channels using Social studio.
• Ability to translate Business requirement into technical requirements.
• Work closely with the Sales & Product Teams and execute campaigns to meet business objectives.
• Monitor impact of each campaign on key site metrics and report to stakeholders, on a regular basis.