Key Responsibility Area: ( Specifies Key Result Areas for the Incumbent ) o Engage with clients to precisely identify and fulfill their data engineering needs. o Lead and manage special projects to meet strategic goals. o Develop advanced models with Snowflake and SSIS to enhance data accuracy and utility. o Continuously refine data processing rules and procedures for optimal results. o Design and implement scalable data architectures using Snowflake. o Maintain and enhance data pipelines, integrating new data sources and APIs as needed. o Monitor and ensure high data quality across systems for reliable decision-making. o Utilize SSIS for efficient data extraction, transformation, and loading processes. o Leverage Informatica knowledge to improve data management capabilities. Eligibility Criteria: (Skill set required to do the job- Knowledge, Tools, Technical Knowledge, Certifications etc.) o Demonstrated expertise in SQL and strong proficiency in programming languages such as Python. o Extensive experience in designing, building, and maintaining robust data pipelines and complex data architectures. o Prior experience with Informatica or equivalent ETL tools, providing a significant advantage. o In-depth understanding of ETL processes, data modeling techniques, and data warehousing principles. o Familiarity with big data frameworks like Hadoop or Spark, adding value to the role. o Strong knowledge of data serialization formats including Parquet, Avro, and JSON, essential for efficient data processing and storage. o Exceptional analytical skills, adept at problem-solving and technical troubleshooting. o Excellent communication and interpersonal skills, essential for effective client engagements and team collaboration. o Proven ability to independently manage multiple projects, demonstrating strong organizational and leadership skills. o Relevant professional certifications in Snowflake, SSIS, Informatica, or comparable data management technologies are highly regarded. BEHAVIORAL SKILLS: (Attitude, Aptitude and Abilities) o Ability to independently manage the full spectrum of ETL processes, data modeling, and data engineering tasks, ensuring high-quality data solutions. o Comfortable with numerical and quantitative calculations and analysis. o Excellent attention to details, high output accuracy and out-of-box thinking to bring in innovative approaches to problems/issues in data processing. o Excellent verbal and written English language communication skills
