Home > Indianapolis jobs > Indianapolis computer/technical

Posted: Sunday, October 1, 2017 12:19 AM

Contract to hire opportunity to develop: ETL packages and jobs using Microsoft SSIS and SAP Data Services as well as Database tables, views, and other objects in SQL Server and SAP HANA databases, Graphical and SQL calculation views in SAP HANA, and Dashboards in Tableau Desktop and publish to Tableau Server Knowledge Services, established in 1994 and headquartered in Indianapolis IN, is a certified woman:owned (WBE) professional services organization with over 1500 employees located in offices throughout North America. Founded by Julie Bielawski, CEO, Guidesoft, Inc. DBA Knowledge Services is an industry leader in Managed Service Programs (MSP), Employer of Record / Payrolling Services, National Recruitment, and Staffing Services. We provide outstanding services to major organizations in various industries, including; IT, Healthcare, Entertainment, Media, Federal and State Governments, Public Utilities, Telecom, Manufacturing and more. As such, Knowledge Services is committed to providing opportunities for growth : in our company, in each team member and in our relationships. We believe titles do not define a person, but provide a framework to each personA?s endless potential. Our focus on improving our team, product and processes drive us every day. We are guided by our four Pillars that set the foundation of who we are and how we conduct business: Knowledge, Integrity, Innovation, and Service. Position Summary: Knowledge Services is hiring for an ETL Developer/ Data Engineer for a contract:to:hire position (6 month contract, then converted to salaried employee). This position is with our client, The State of Indiana in the Office of Information Technology. To be eligible, candidate must be able to convert to a full time State employee. Must be able to work in the U.S. without sponsorship. ResponsibilitiesDevelop:ETL packages and jobs using Microsoft SSIS and SAP Data ServicesDatabase tables, views, and other objects in SQL Server and SAP HANA databasesGraphical and SQL calculation views in SAP HANADashboards in Tableau Desktop and publish to Tableau ServerUse:Software development life cycle methodologies to develop, test, deploy, and manage ETL codeSource code repositories like TFS and Data Services central repositories for source code version controlWork with:Business Analysts and client agencies to refine and document business requirements and to test and validate data and dashboards deployed to client agenciesAdmin team on technical issuesCleanse and publish data according to business requirements and specification documentationDocument ETL packages and jobs in ETL specification documentationParticipate in ETL code reviews and testingCollect data source metadata for use in data catalogProvide maintenance and support for production ETL jobs and dashboardsTest and evaluate new tools and upgrades to existing softwareRequired Skills and Experience: **Most Important Skills**BachelorA?s degree and 3+ years of Data Warehouse/Business Intelligence work experience strongly preferredExtensive experience using Advanced knowledge of ETL, including the ability to read and write efficient, robust code, follow or implement best practices and coding standards. Design/implement common ETL strategies (CDC, SCD, etc.), and create reusable/maintainable jobsAdvanced SQL coding and troubleshooting skillsOther Skillsets Requested:Strong understanding of relational and dimensional database and data warehousing structures, theories, principles, and practicesExperience with:ETL tools (SSIS, Data Services, Informatica, DataStage or similarData modeling, database design, and query performance tuning and optimization in various relational database systems (SQL Server, SAP HANA, Oracle, Teradata or similar)Database development and data manipulation using PL/SQL and T:SQL (stored procedures, functions, packages, triggers)Manipulating very large datasetsComplex matching transformsText analysis and hashingProfiling data using SAP Information StewardStru


• Location: Indianapolis

• Post ID: 30617152 indianapolis is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017