ETL Production Support Engineer

Net2Source Inc. is an award-winning total workforce solutions company recognized by Staffing Industry Analysts for our accelerated growth of 300% in the last 3 years with over 5500+ employees globally, with over 30+ locations in the US and global operations in 32 countries. We believe in providing staffing solutions to address the current talent gap Right Talent Right Time Right Place Right Price and acting as a Career Coach to our consultants. Job Summary -:Job Title: ETL Production Support EngineerLocation: RemoteETL Production Support EngineerETL Production Support Engineer to join the Investments Technology team responsible for establishing and maintaining an adaptable data infrastructure in order to provide access to high quality, consistent data in an easy and convenient manner to all authorized end users and applications.Our team is looking for a data driven person who has engineered and supported critical applications in an insurance / financial environment and is experienced in ETL, data warehousing and setting up data pipelines across the enterprise. This seasoned professional will need to interface with the Investments business and IT management, providing them with data solutions, timely and accurate status updates, short-term / long-term plans, release plans, etc. in a clear consistent manner that emphasizes performance metrics, strategic planning, continuous improvement and adherence to industry best practices. The candidate will display technical and functional competence in data management standards and uphold client's commitment to client values. Position ResponsibilitiesYour responsibilities will include the following activities: Production Support, Deployment & Migration, and Maintenance for Investments applications. Maintain service uptime as defined in service level agreements. Develop and maintain data pipelines and build out new integrations to support continuing increases in data volume and complexity. Implement processes and systems to monitor data quality, ensuring production data accuracy and assist in data analysis to troubleshoot and resolve data issues. Data engineering abilities and expertise in using SQL, DDL/DML, performance tuning, data modelling and data warehousing techniques. Knowledge of Python with an ability to code in other languages. In-depth experience working with enterprise scheduler BMC Control-M. Experience working with relational/non-relational databases and understanding of storage technologies like SQL Server. Work with DBA and other staff as necessary, to instantiate physical databases based on the models. Experience working with AWS services such as S3, EMR, EC2, or data lake architecture is a plus. Review data sources and assess data quality; determine the appropriate data inputs, outputs and integration rules and strategy. Advanced problem solving, data analytics and troubleshooting skills with the ability to identify and solve complex business needs. Exposure to Data Integration tools like SSIS and Informatica. Interface with business units, internal IT, customers, and management in the performance of duties. Experience with or knowledge of Agile Software Development methodologies.The above description includes most significant duties performed. However, other occasional work assignments not mentioned are assumed to be included. Management reserves the right to assign and/or reassign duties and responsibilities at any time.Knowledge Investment or financial services domain knowledge Relational database concepts; Strong experience data integration ETL concepts with strong Informatica and SSIS knowledge Strong RDBMS knowledge.Experience 10+ Years of IT industry experience, with 5+ years of experience as a Data Engineer or in data related areas. 5+ years of strong SQL, PL/SQL, SQL Server, stored procedures, and Control-M experience 3+ years of Python development experience Must have Experience with Data Integration Informatica, SSIS Strong UNIX Shell Scripting experience with Windows and Linux Experience working with CI/CD Bitbucket (GIT), Jenkins Significant experience interfacing with business end-users Preferred experience with NeoXam DataHub Preferred experience with .NET Preferred experience with AWS S3, EMR, EC2 Why work with us - At Net2Source, we believe everyone has an opportunity to lead. We see the importance of your perspective and your ability to create value. We want you to fit inwith an inclusive culture, focus on work-life fit and well-being, and a supportive, connected environment; but we also want you to stand outwith opportunities to have a strategic impact, innovate, and take necessary steps to make your mark. We help clients with new skilling, talent strategy, leadership development, employee experience, transformational change management and beyond.Equal Employment Opportunity Statement:Net2Source is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion or sexual orientation. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.Awards and Accolades:

• America's Most Honored Businesses (Top 10%)
• Awarded by USPAAC for Fastest Growing Business in the US
• 12th Fastest Growing Staffing Company in USA by Staffing industry Analysts in the US (2020, 2019, 2020)
• Fastest 50 by NJ Biz (2020, 2019, 2020)
• INC 5000 Fastest growing for 8 consecutive years in a row (only 1.26% companies make it to this list)
• Top 100 by Dallas Business Journal (2020 and 2019)
• Proven Supplier of the Year by Workforce Logiq (2020 and 2019)
• 2019 Spirit of Alliance Award by Agile1
• 2018 Best of the Best Platinum Award by Agile1
• 2018 TechServe Alliance Excellence Awards Winner
• 2017 Best of the Best Gold Award by Agile1(Act1 Group)