Highlights: US based firm 24 LPA + 0 - 15% Variable bonus Experience required: 7 Years Data Integration expertise with Snowflake Your notice period must be one month Description: Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Gather requirements and business process knowledge to transform the data in a way that’s geared towards the needs of end users. Creates logical and physical data flow models for ETL applications. Ensure that the data architecture is scalable and maintainable. Work with data modelers and business analysts to understand project requirements and convert them technical document and Jira stories. Analyze data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions. Document procedures for ETL pipelines and work with stake holders for engagement and approval. Automate data processes for event driven and time based schedule using orchestration and workflow tools. Focus Points: Experience with developing SQL queries and PL/SQL scripts in cloud warehouse like Snowflake or similar technologies Strong understanding on cloud warehouse architecture and services in AWS or similar cloud platform Optimization and performance tuning of data processing workflows for improved efficiency Knowledge of building data pipelines using Python using pandas data frame and SQL connectors Preferred knowledge of Java and developing application for reading data from message queues Knowledge of data warehouse principles like star schema model using slowly changing dimension and facts Experience in code deployment and release management policies and procedures Experience is scheduling jobs using Autosys or similar tools Strong soft skills including attention to detail, verbal and written communication, team oriented and self-motivated Application The questions in this form are by the hiring manager for initial screeningAre you residing in Chennai or a nearby area for this Hybrid job? If Yes, please share city name and zip/postal code: *Did you ever apply or have an interview at DTCC ( http://www.dtcc.com)? If yes, please share details *Please share your highest level of education: *How many years of experience do you have with Data Integration (Snowflake) *This job requires expertise in AWS, Snowflake, ETL, SQL, PL/SQL, Python. Please share your experience in each skill set and any notable project / achievement. *Are you happy with the hybrid work arrangement which requires 3 days a week on site? *Please share your present CTC: *Please share your expected CTC: (24 LPA is maximum) *Full Name *Email Address *Contact No *Please share your LinkedIn profile *How soon can you join? *Upload Your CV *Choose FileNo file chosenDelete uploaded file- (Pdf, Doc, Docx)Declaration: I declare that the all above information is accurate and shareable with the hiring manager for initial screening *YesNo Send
