Logo
Smart IT Frame

ETL Tester/Lead/Manager

Smart IT Frame, Milwaukee, Wisconsin, United States, 53244


Greetings from

Smart IT Frame , Hope you are doing well! Smart IT Frame

specializes in enabling you with your most critical line of resources. Whether it is for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in emerging technologies, we have provided global technology workforce solutions in North America, Canada & India. We take pride in delivering specialized talent, superior performance, and seamless execution to meet the challenging business needs of customers worldwide. Position: ETL Tester/Lead/Manager Work Location: Mileaukee WI Duration: Fulltime

As an ETL Test Engineer, you will be responsible for both manual and automated testing to validate data sources, extract data, apply transformation logic, and load data into target tables. You'll work closely with data engineering teams to ensure a sustainable testing approach. Key responsibilities include: Testing data validation scenarios, data ingestion, pipelines, and transformation processes. Using automated testing tools and understanding information governance principles in a testing capacity. Automating tests across multiple platforms and technologies throughout the development lifecycle. Managing test cases and handling issue and defect management. Testing systems that capture, verify, and maintain field-generated metadata. Familiarity with various back-end and front-end languages, libraries, databases, web servers, web services, APIs, and UI/UX design. Knowledge of modern testing development practices and integrated testing products integration with tools such as GitLab. Experience with Agile Software Development & Testing methods for cloud deployments. Must have - Skills required for this role: 1. Insurance domain knowledge is Most 2. Main Frame Background (extracting files from MF and comparing in Db2) 3. Python [Most] , 4. DB2, Aurora SQL, MySQL, PostgreSQL, Databricks, Snowflake 5. Power BI/SSRS/SSIS for report testing 6. Messaging events (SNS/SQS/Kafka) 7. Informatica tool for ETL 8. AWS Cloud S3 Skills API/Microservices RestAssured Testing, AWS Cloud data Testing, Azure Cloud data Testing, BI Reports / Data Visualization Testing, Cloud migration and Platform modernization Testing, Python Data Automation Testing, Tosca Data Integrity (DI) Testing