ELT Developer

Role: ETL Developer Duration: 24 Months Location: Remote Required Skills: IBM DataStage, ETL Python SQL Linux Job Description : Apex Systems is currently seeking an experience ETL Developer for an excellent job opportunity. The ETL Developer is responsible for the definition, development, and testing of the processes and programs necessary to extract data from the client's operational databases/files and deliver it to the desired target environments. Duties include extraction, transformation, cleansing and loading of data into a data warehouse, data marts, etc. The ETL Developer is experienced with all of the techniques used to manage and maintain a data warehouse environment. The ETL Developer defines the program specifications for the data migration processes, as well as the necessary test plans used to ensure successful execution. The ETL Developer is also responsible for managing the metadata associated with the ETL processes used to populate the data warehouse. Knowledge of data warehousing ETL procedures such as changing dimension strategies and use of surrogate values is a necessity. Depending on one’s performance, ability, and career goals, there will be ample opportunities to expand one’s skill sets beyond ETL development and into the various aspects of the IBM InfoSphere Information Server Suite, such as QualityStage, Information Analyzer, Change Data Delivery, Balance Optimizer, and Master Data Management. Qualifications: 5+ years of experience in ETL (prefer experience with IBM DataStage), SQL, UNIX/Linux, Big Data distributed systems, various programming languages like Python, orchestration tools and processes or other directly related experience. Extensive experience in data migration, data analysis, data transformations, conversion, interface, large volume data loading (ETL techniques), database modeling, and performance SQL tuning.? Significant experience in leveraging database tools to develop DDL scripts, stored procedures, and functions to create and alter database objects. Have a good understanding of entity-relational database design, including data normalization and ERD modeling. Experience working with Greenplum, Oracle, SQL Server, DB2, Teradata, and delimited text files would be helpful. Basic knowledge of Cloud computing, search technology, building real-time data pipelines, scheduling tools and processes. Hands on experiences with Git version control processes, data streaming technologies such as Kafka, and unstructured data handling preferred. Serve in the goalie (On-Call) rotation to support the Production environment. Responsible for maintaining enterprise-grade platforms that enable data-driven solutions. Good analytical, organizational, and problem-solving skills. Ability and desire to learn new technologies quickly. Ability to elicit, gather and analyze user requirements. Ability to work independently and collaborate with others at all levels of technical understanding. Able to meet deadlines. Good judgment and project management skills. Ability to communicate both verbally and in writing with both technical and non-technical staff. Ability to work in a team environment and have good interpersonal skills. Ability to adapt to changing technology and priorities. Must be able to interpret, validate and map business requirements to an appropriate solution. Thanks & Regards, Manoj - Technical Recruiter Thought wave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6304919831 EXTN: 158 Email : Manoj@thoughtwavesoft.com Website:www.thoughtwavesoft.com https://www.linkedin.com/in/chettipalli-manoj-398b02246