IT Analyst Applications ETL - SSIS Developer

Responsibilities: Working closely with business & IT stakeholders and understand ETL requirements and build end to end ETL migration processes using SSIS and SQL Server Designing and building scalable ETL solutions and Data Modelling Writing complex SQL queries Unix shell commands and Java Script Testing and troubleshooting problems in ETL system designs and processes Analysing and improving existing ETL approaches and solutions Providing Architectural Guidelines Experience and expertise other ETL tools preferably Snaplogic and DataStage Expected to be part of the ideation design and deployment of ETL solutions Required Skillsets: Minimum 2 to 3 years of relevant experience should be able understand and develop complete ETL migration process Strong business analysis and requirement definition background in the areas of data integration (ETL) using SQL Server Integration services (SSIS) Excellent handson knowledge in SSIS packages and developing complex ETL jobs Good working knowledge experience in Snowflake and SQL Server Good knowledge in Python scripting will be a plus Development knowledge in visualization tools like Power BI will be a plus ETL development experience with SSIS with a focus on connecting with REST & SOAP APIs for Inbound/Outbound integrations Experience with JDBC Snowflake Azure Salesforce Redshift Zuora S3 Snaps will be a plus Experience with scheduling tools like Tidal Autosys/ControlM will be a plus Experience in using processing snaps like mapper unique Aggregate sort and join Experienced with implementation methodologies and best practices (e.g. Waterfall Agile) Experience in establishing criteria for data use/test cases Experience defining and implementing error and exception handling strategies Ability to balance multiple projects and work both independently and as part of a team Strong verbal and written communication skills presentation analytical organizational and interpersonal skills Strong troubleshooting problem solving and conceptualization skills Ability to work independently as well as being a collaborative team member Able to manage own duties including setting priorities The ability to work within a multidisciplinary team Experience in Cloud Migration Projects & Reverse Engineering Good Understanding of Cloud Concepts Having good knowledge of Caterpillar policies standards and procedures with broad understanding of Caterpillar s organization is a plus Work Timings: 1:00PM to 10:00PM IST (Approx.)