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
