Senior Data Engineer Job in Techno Wise

Responsibilities: Design, develop and implement robust and extensible ETL solutions to support data warehouse integrations and transformations using CDI/CAI services on IICS platform, UNIX/PowerShell. Partner with business and subject matter experts to identify, document & design based on the business requirements, functional specs and translate them into appropriate technical solutions. Understand the Software Development Lifecycle and ability to apply the SDLC to existing and future development initiatives. Responsible for estimating, planning, and managing the user stories, tasks and reports on Agile Projects. Performance tuning and optimizations of ETL Jobs, SQL Queries and Scripts. Configure and maintain scheduled ETL jobs. Manage and Implement CICD for Informatica Intelligent Cloud Services ETL pipelines. Develop advanced PLSQL Procedures, Functions and SQL jobs. Support exploratory data analysis, statistical analysis and predictive analytics. Develop data integrations between internal and external/third party sources. Support production issues and maintain existing data systems by researching and trouble-shooting any issues/problems in a timely manner. Develop technical solutions using Data Bricks, Snowflake or Azure Synapse architecture. Participate in the development of corporate-wide strategies, processes, and standards for data architecture, storage and reporting. Proactive, great attention to detail, results-oriented problem solver Additional Job Requirements: Bachelor s Degree or higher in Engineering, Technology or related field experience required. 9+ years of experience with any ETL Integration tools like Informatica Power center, IICS, Talend, etc., 4+ years of experience in CDI/CAI Integration Services in IDMC platform. 8+ years of experience working with SQL queries. In depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework. 5+ years experience with design, build, test, and maintain data integrations for data marts and data warehouses. 4+ years experience with Azure Cloud platform and services. 2+ years experience working with Snowflake, Data Bricks or Azure Synapse data platforms. Ability to effectively prioritize and execute tasks in a high-pressure environment and react to project adjustments and alterations promptly and efficiently. Demonstrated experience with various BI technologies. Proven abilities to take initiative and be innovative. Analytical mind with a problem-solving aptitude Excellent verbal and written communication skills Experience managing all phases of the project life cycle, including running project prioritization meetings, post-installation project post-mortem meetings and a proven track record of managing multiple tasks and meeting deadlines. Collaboration with both onshore and offshore development teams