Test Automation Engineer

Software Guidance & Assistance, Inc., (SGA), is searching for a Test Automation Engineer for a CONTRACT assignment with one of our premier Financial Services clients in Philadelphia, PA .

Responsibilities :

• Develop comprehensive data verification and validation for backend data-oriented systems using modern frameworks such as Pandas, Informatica and other industry tools approved for use as applicable.
• Using scripting/programming languages like Python and R with a modern IDE (Anaconda, Jupyter notebook, or similar), and source code management products like GIT and Subversion.
• Advanced written and oral communications skills. Independently, presents both orally and in writing, findings and assessments; prepares and presents information and responses to highly complex inquiries; demonstrates the ability to manage the communication process; the ability to communicate with clients, colleagues and management to explain complex
• Issues clearly and concisely; actively engages in transferring technical knowledge
• Diffuses conflict and builds consensus.
• Advanced analytical and problem-solving skills. Possesses a logical, analytical and creative approach to problems.
• Perform functional, integration, system, regression and/or performance test.
• Design, develop and execute automation scripts using approved tools.
• Evaluate software performance and current test methodologies, recommend process improvements.
• Manage defects and collaborate with development staff to resolve issues.
• Plan and estimate testing efforts in collaboration with project team.
• Coach/mentor/share expertise with personnel

Required Skills:

• Bachelor's degree with a concentration in Information Technology or Computer Science or equivalent significant experience in information technology and software testing is required.
• Minimum of 7 years of experience designing and developing tests for ETL and Data Warehouse solutions using a software development approach
• Minimum of 7 years of automation development experience with technologies described below.
• Familiar with Source control like Git
• Experience building continuous test jobs that execute on a schedule or based on events
• Hands on experience in API testing like, Karate, Postman
• Hands on experience in Python and R with a modern IDE like AWS Glue, Databricks, Jupyter notebook, Informatica Power Center
• Ability to create complex SQL / database queries for creating test data and validating data integrity
• Automated testing of databases and ETL processes built using technologies and frameworks available as Cloud solutions
• Experience in variety of large Database systems like AWS Redshirt, PostgresSQL, Oracle Exadata
• Develops solutions to automate testing of databases and ETL processes built using technologies and frameworks such as SSIS, Oracle Integration products, Data Warehouse products and other industry tools approved for use as applicable.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.