Job Description

: Summarized Purpose Provides systems analysis, design, development, testing and support for moderately complex technical information system components. Essential Functions Understands and develops components and services according to specifications within a team environment. Prepares detailed system documentation including requirements, specifications, test plans and user manuals. Performs unit and system tests and, as needed, validation testing. Assists DBA with database design and implementation. Strong SQL and Analytical skills to pull data from Snowflake/Oracle/SQL Server and perform usage analysis and/or data profiling. Understanding of data warehousing and data modelling principles Experience in understanding both logical and physical data models Coordinates with Operations staff on deployment of applications. Works with business partners to analyze and address support requests including training. Provides support for existing systems and technologies, including second line application support during and after deployment. Ensures all activities are performed with quality and compliance. Design and implementation of ETL batches that meet the SLAs for the business\' Business Intelligence reporting. Development of data collection, data staging, data movement, data quality and archiving strategies. Plan and conduct ETL Unit and development tests, monitoring results and taking corrective action when necessary. Design and implement automation processes to control data access, transformation and movement and ensures source system data availability Working hours for India - 3PM to 12 AM IST Manila - 5:30 PM to 2:30 AM PHST Knowledge, Skills and Abilities Must have 8-10 year\'s experience who has min 2-3 year\'s experience in Talend and min 7 year\'s experience in SQL and EDW . Experienced in the use of the Talend ETL tool and Snowflake/Any Cloud based tools ( Must Have ) Client focused approach with strong interpersonal skills Must be able to multitask and pay close attention to detail Open to PROD support during the week and weekends Solid knowledge of basic relational database platforms (Snowflake, Oracle, SQL Server) and languages (PL/SQL, SQL) ( Must Have ) Build processes supporting data transformation, data structures, metadata, dependency and workload management Strong logic, analysis, and problem-solving skills A good understanding of the concepts and best practices of data warehouse ETL design. ( Must Have ) Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively Have designed and developed ETL work packages on at least one data warehouse project. Expertise in building and optimizing cloud data pipelines, architectures and data sets. Experience with AWS cloud services: Glue, S3, Databricks, EC2, EMR ( Nice to Have )

foundit