System Engineer

Primary Responsibilities include: Defines, designs, and builds dimensional databases to meet business needs.
Assists in the application and implementation procedures of data standards and guidelines on data ownership, coding structures, and data replication to ensure access to and integrity of data sets. Conducts data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access. Researches, coordinates and installs software releases and database integration. Develops and implements strategies to translate business requirements and models into feasible and acceptable data warehouse designs to ensure that business needs are met. Provides data consulting in support of business and information technology initiatives to clients to improve client database systems. Coordinating and collaborating with cross functional teams and stakeholders for the smooth functioning of the Application. Implement measures to maintain/improve platform stability, security, and quality. Skill Set:Primary skills Data engineer with strong hands on experience in ETL development using Informatica power center, Python, Snowflake and SQL 5+ Years of experience in Informatica Power Centre, Python, Snowflake and SQL. Experience in shell scripting (able to write new scripts or modify existing based on requirement) Hands on experience to write business logic using SQL or PL/SQL ETL testing and troubleshooting. Good knowledge of code deployment process and documentation Good analytical and problem solving skills. Experience in scheduling tools like Autosys/ Control M Knowledge of Agile methodologies (scrum/kanban) Familiar with stashing tools like Git Hands on experience working on Flat Files, multiple databases like Oracle, Netezza, DB2, PostgreSQL Attitude to plan and organize work to deliver as agreed. Demonstrated experience in Agile development, application design, software development, and testing. Aptitude for learning and applying programming concepts. Ability to effectively communicate with internal and external business partners. Prior experience with Hadoop to snowflake migration will an AddOn Secondary/Desired skills Hadoop