Associate Technical Architect

The Technical Lead / Technical Consultant is a core role and focal point of the project team responsible for the whole technical solution and managing the day-to-day delivery. The role will focus on the technical solution architecture, detailed technical design, coaching of the development/implementation team, and governance of the technical delivery. Technical ownership of the solution from bid inception through implementation to client delivery, followed by after-sales support and best practice advice. Interactions with internal stakeholders and clients to explain technology solutions and a clear understanding of client’s business requirements through which to guide optimal design to meet their needs.

Job Description:

Must-Have Skills:

•    Database (one or more of MS SQL Server, Oracle, Cloud SQL, Cloud Spanner, etc.)

•    Data Warehouse (one or more of Big Query, SnowFlake, etc.)                
•    ETL tool (two or more of Cloud Data Fusion, Dataflow, Dataproc, Pub/Sub, Composer, Cloud Functions, Cloud Run, etc.)    
•    Experience in Cloud platforms - GCP        
•    Python, PySpark, Project & resource management            
•    SVN, JIRA, Automation workflow (Composer, Cloud Scheduler, Apache Airflow, Tidal, Tivoli or similar)                

Good to have Skills: 
•    UNIX shell scripting, SnowFlake, Redshift, Familiar with NoSQL such as MongoDB, etc
•    ETL tool (Databricks / AWS Glue / AWS Lambda / Amazon Kinesis / Amazon Firehose / Azure Data Factory / ADF / DBT / Talend, Informatica, IICS (Informatica cloud) )    
•    Experience in Cloud platforms - AWS / Azure        
•    Client-facing skills

Key Responsibilities:

• Ability to design simple to medium data solutions for clients by using cloud architecture using GCP
• Strong understanding of DW, data mart, data modeling, data structures, databases, and data ingestion and transformation.​
• Working knowledge of ETL as well as database skills
• Working knowledge of data modeling, data structures, databases, and ETL processes​
• Strong understanding of relational and non-relational databases and when to use them​
• Leadership and communication skills to collaborate with local leadership as well as our global teams
• Translating technical requirements into ETL/ SQL application code
• Document project architecture, explain the detailed design to the team, and create low-level to high-level design
• Create technical documents for ETL and SQL developments using Visio, PowerPoint, and other MS Office package
• Will need to engage with Project Managers, Business Analysts, and Application DBA to implement ETL Solutions
• Perform mid to complex-level tasks independently
• Support Clients, Data Scientists, and Analytical Consultants working on marketing solution
• Work with cross-functional internal teams and external clients​
• Strong project management and organization skills​. Ability to lead 1 – 2 projects of team size 2 – 3 team members.​
• Code management systems which include Code review, deployment, cod​
• Work closely with the QA / Testing team to help identify/implement defect reduction initiatives
• Work closely with the Architecture team to make sure Architecture standards and principles are followed during development
• Performing Proof of Concepts on new platforms/validating proposed solutions
• Work with the team to establish and reinforce disciplined software development, processes, standards, and error recovery procedures are deployed
• Must understand software development methodologies including waterfall and agile
• Distribute and manage SQL development Work across the team
• The candidate must be willing to work during overlapping hours with US-based teams to ensure effective collaboration and communication, typically between [e.g., 6:00 PM to 11:00 PM IST], depending on project needs.

Qualifications:

• Bachelor’s or Master's Degree in Computer Science with >= 7 years of IT experience

Location:

Bangalore

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent